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
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:
- Business objects: Have all business objects and their characteristics been converted into entities and attributes?
- 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?
- 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?