The first step in database development is which of the following?

By: Prof. Dr. Fazal Rehman Shamil | Last updated: February 3, 2024

 

Question:  The first step in database development is which of the following?

A   Enterprise data modeling

B   Logical database design

C   Physical database design and definition

D  Database Implementation

Answer:   Enterprise data modeling

 

Steps in database development       Description
Enterprise data modelingHigh-level modeling to understand organization-wide data needs.
Logical database designDefine the structure of the database, including tables, relationships and attributes.
Physical database designPlan the specific implementation details, like storage, indexing and access mechanisms.
Database implementationBuild the actual database according to the design specifications.
Testing and quality assuranceEnsure the database works correctly and meets requirements.
Data migrationIf transitioning from an existing system, move data to the new database.
Deployment and rolloutPut the database into production use for end-users.
Ongoing maintenanceContinuously monitor, optimize and maintain the database.