What will be the right sequence of the phases of database design?
A. Physical Design
B. Conceptual Design
C. Logical Design
D. Requirement collection and analysis
Choose the correct answer from the options given below:
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: B. D, B, C, A
Explanation
Database design proceeds from requirements analysis to conceptual design (ER model), logical design (relational schema) and finally physical design: D, B, C, A.More Database Management Systems questions
- An alternate key in a database table is also called
- In concurrency control, the phantom problem may occur when
- Which of the following is/are FALSE statement(s)? A. An all-key relation is always in BCNF since it has no FDs. B. A relation that is not i…
- Which of the following commands can be used to modify data in an SQL table? A. INSERT B. DELETE C. UPDATE D. SELECT Choose the correct answ…
- Which of the following tables contains the primary information in a data warehouse?
- The INSERT command is used to A. add a single tuple to a relation B. add multiple tuples to a relation C. add values to specific attributes…