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:

Correct option is C

1. Requirement Analysis: This is the first step, where the needs of the database and the users are collected and analyzed.
2. Conceptual Design: After requirements are gathered, a high-level model (e.g., ER diagram) is created to represent data and relationships.
3. Logical Design: The conceptual model is transformed into a logical schema, often in a normalized relational model.
4. Physical Design: The final step involves creating the actual database structure, including indexing and partitioning, based on the logical schema.
Information Booster:
Database Design Phases:
· Requirement Analysis: Ensures that all data and functional needs are well-understood before proceeding.
· Conceptual to Physical Design: Progressively refines the database structure from abstract to implementable.
Additional Knowledge:
Option (a): Does not follow the logical order from requirements to physical implementation.
Option (b): Starts with Logical Design, which should follow Conceptual Design.
Option (d): Begins with Physical Design, which is not feasible without prior logical and conceptual planning.