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. |