Why must a conceptual model be verified? What steps are involved in the verification process?
The verification of a conceptual model is crucial to a successful database design. The verification process allows the designer to check the accuracy of the database design by: Re-examining data and data transformations. Enabling the designer to evaluate the design efficiency relative to the end user’s and system’s design goals. Keep in mind that, to a large extent, the best design is the one that serves the end‑user requirements best. For example, a design that works well for a manufacturing firm may not fit the needs of a marketing research firm, and vice versa. The verification process helps the designer to avoid implementation problems later by: Validating the model’s entities. (Remember the minimal data rule.) Confirming entity relationships and eliminating duplicate, unnecessary, or improperly defined relationships. Eliminating data redundancies. Improving the model’s semantic precision to better represent real‑world operations. Confirming that all user requirements (processing,
