What is the correct sequence of database design process?
A. Create conceptual schema
B. Data model mapping
C. Requirements collection and analysis
D. Physical design
Choose the correct answer from the options given below:

Explanation

Database design begins with requirements collection and analysis to understand the data and processing needs. This is followed by building the conceptual schema (e.g. an ER model) independent of any specific DBMS, which is then mapped to a logical data model in the data model mapping step (e.g. ER-to-relational). Finally, physical design chooses storage structures, indexes and access paths for implementation. This gives the order Requirements (C) → Conceptual schema (A) → Data model mapping (B) → Physical design (D), i.e. C, A, B, D.