Arrange the following phases of database design in the correct order: (A)…
2024
Arrange the following phases of database design in the correct order:
(A) Physical Design
(B) Conceptual Design
(C) Logical Design
(D) Requirement Analysis
Choose the correct answer from the options given below:
- A.
(B), (D), (A), (C)
- B.
(C), (A), (B), (D)
- C.
(D), (B), (C), (A)
- D.
(A), (D), (C), (B)
Attempted by 2845 students.
Show answer & explanation
Correct answer: C
Correct sequence: Requirement Analysis → Conceptual Design → Logical Design → Physical Design.
Requirement Analysis — Gather user needs, business rules, and constraints that the database must satisfy.
Conceptual Design — Create a high-level model (for example, ER diagrams) identifying entities and relationships without considering a specific DBMS.
Logical Design — Translate the conceptual model into a logical schema (tables, attributes, keys, and relationships), and apply normalization rules.
Physical Design — Decide physical storage structures, indexing, partitioning, and DBMS-specific implementation details to optimize performance.
Reasoning: You must first understand what the system needs (requirements). The conceptual model captures those needs at a high level, the logical model maps them into database constructs, and the physical design makes implementation choices for performance and storage.
A video solution is available for this question — log in and enroll to watch it.