Previous Topic: Reviewing the DesignNext Topic: Step 2: Review the Physical Database Model


Step 1: Review the Logical Database Model

In the initial stages of logical design, you identified the business problem that users hoped to solve by creating a database. After interviewing several company employees, you performed a thorough analysis of the business system, determining the processing functions performed by the corporation and the flow of data during typical executions of these functions.

An analysis of the system provided documentation of the types of data required by corporate users to perform their day-to-day business tasks. With this documentation, you created the entity-relationship diagram, which serves as a model of the corporate enterprise.

During the final review of a database design, you should make sure that the physical design does not compromise the logical model for the database.