Arrange the following phases of database design in the correct order :

(A) Physical Design

(B) Conceptual Design

(C) Logical Design

(D) Requirement Analysis

1. A(B), (D), (A), (C)
2. B(C), (A), (B), (D)
3. C(D), (B), (C), (A)
4. D(A), (D), (C), (B)

Pick an option to check yourself, or open the answer below.

Show answer & explanation

Correct answer: C. (D), (B), (C), (A)

Explanation

Requirement analysis → conceptual design → logical design → physical design.