Diagram Conventions   «Prev  Next»

Lesson 7 Users revisited
Objective Revise an ER diagram based on a final interview with end users.

Interview end Users

Once the ER diagram is complete, the next step is to review it and any related documentation with specific end users to determine if the model is an adequate container for the data to be stored, and/or if there are modifications that ought to be made. Some specific areas to review include:
  1. Business objects: Have all business objects and their characteristics been converted into entities and attributes?
  2. Business rules: Have constraints on entities, attributes, and relationships derived from business rules (and common-sense rules) been properly identified and, where appropriate, incorporated into the model?
  3. Queries and user views: Do end users agree that the model, as constructed, will result in a database that returns useful information to them quickly and efficiently?
If there are modifications to be made to the conceptual model and, in particular, to any relationship constraints placed on that model, these should be addressed before the next major step in the logical design stage is taken: data normalization (discussed in the next course in this series).
The next lesson describes the process of “verbalizing” the ER diagram.

Accommodating Client - Exercise

Before moving on to the next lesson, click the Exercise link one last time to try your hand at modifying the Stories on CD ER diagram to accommodate a revised business rule.
Accommodating Client - Exercise