BCA Semester 3 – System Analysis and Design – Unit 4: Design (12Hrs)
Comprehensive questions and detailed answers for Unit 4: Design (12Hrs). Perfect for exam preparation and concept clarity.
Distinguish between system and user documentation and determine which types of documentation are necessary for a given information system.
What is difference between a 2NF and 3NF?
Explain the guidelines to design in an interface and dialogue box e-commerce system.
How can you transform ER Diagram into relation? Explain with your own suitable example.
What are the steps in creating decision table? How do we reduce the size and complexity of a decision table?
How can you transform ER Diagram into relation? Explain with your own suitable example.
Giving a simple example, explain how ER schemas are converted into a set of relations.Your example should have the use of multivalued and composite attributes too.Cardinality is a must.
What is the significance of normalization? Explain 2NF giving a suitable example.
What is normalization? Explain the major objectives of database design.
. Define DFD. Write rules to draw a DFD. Draw a DFD upto level 1 for library management system.
a) Write guidelines to design a forms and reports.
b) Explain types of system implementation.
Define case tool. Explain different types of case tool that can be used in different phases of SDLC.
Define data modeling. Explain logical data model in detail.
What are the various types of menu design which can be adopted to meet the system complexity and usability?
Sample Questions
What is difference between a 2NF and 3NF?
Explain the guidelines to design in an interface and dialogue box e-commerce system.
How can you transform ER Diagram into relation? Explain with your own suitable example.
What are the steps in creating decision table? How do we reduce the size and complexity of a decision table?
And more questions available on this page.