3.4. CSDP Step 2: Draw Fact Types and Populate
Once we have translated the information examples into elementary facts, and performed quality checks, we are ready for the next step in the conceptual schema design procedure. Here we draw a conceptual schema diagram that shows all the fact types. This illustrates the relevant object types, predicates and reference schemes. Once the diagram is drawn, we check it with a sample population.
|
CSDP step 2: Draw the fact types and apply a population check. |
Consider the sample output report of Table 3.6. Let us agree that the information in this report can be expressed by the following three elementary facts, using “regNr” to abbreviate “registration number”:
The Person named ‘Adams B’ drives the Car ...
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.
