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 modeling | High-level modeling to understand organization-wide data needs. |
Logical database design | Define the structure of the database, including tables, relationships and attributes. |
Physical database design | Plan the specific implementation details, like storage, indexing and access mechanisms. |
Database implementation | Build the actual database according to the design specifications. |
Testing and quality assurance | Ensure the database works correctly and meets requirements. |
Data migration | If transitioning from an existing system, move data to the new database. |
Deployment and rollout | Put the database into production use for end-users. |
Ongoing maintenance | Continuously monitor, optimize and maintain the database. |