3.2. Conceptual Schema Design Procedure

When developing an information system, we first specify what is required and produce a design to meet these requirements. For reasons outlined earlier, we recommend first developing this design at the conceptual level using Object-Role Modeling. This entails describing the structure of the UoD formally in terms of an ORM conceptual schema. If an ORM context is understood, we’ll often shorten “ORM conceptual schema” to just “conceptual schema”.

The procedure for designing a conceptual schema small enough to manage as a single unit is referred to as the Conceptual Schema Design Procedure (CSDP). Large business domains are first divided into subareas (which may overlap). These subareas are normally prioritized ...

Get Information Modeling and Relational Databases, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.