210 likes | 431 Views
Conceptual Data Model 2. Constraints History Analytical Model. Constraints. Types Assembly Stability Subtyping Disjoin Cover. Assembly Constraints. Inclusion. {[Takes exam] [enrolls]}. Assembly Constraints. Totality. Assembly Constraints. Exclusivity.
E N D
Conceptual Data Model 2 Constraints History Analytical Model Bogdan Shishedjiev Conceptual Data Model
Constraints • Types • Assembly • Stability • Subtyping • Disjoin • Cover Bogdan Shishedjiev Conceptual Data Model
Assembly Constraints • Inclusion {[Takes exam] [enrolls]} Bogdan Shishedjiev Conceptual Data Model
Assembly Constraints • Totality Bogdan Shishedjiev Conceptual Data Model
Assembly Constraints • Exclusivity {not ([enrolls] and [candidate])} Bogdan Shishedjiev Conceptual Data Model
Assembly Constraints • Equality Bogdan Shishedjiev Conceptual Data Model
Assembly Constraints • XOR Bogdan Shishedjiev Conceptual Data Model
Stability Constraints • Association stability Bogdan Shishedjiev Conceptual Data Model
Stability Constraints • Link stability Bogdan Shishedjiev Conceptual Data Model
Stability Constraints • Attribute Stability Bogdan Shishedjiev Conceptual Data Model
Subtype Constraints • Disjoint • Every instance is in a only one subtype • Cover • All instances are in subtypes Bogdan Shishedjiev Conceptual Data Model
Case Study - Policlinic Bogdan Shishedjiev Conceptual Data Model
Case Study - Policlinic Bogdan Shishedjiev Conceptual Data Model
Historicizing • Historicizing an attribute Bogdan Shishedjiev Conceptual Data Model
Example – A Repair Company Bogdan Shishedjiev Conceptual Data Model
Example – A Repair Company Bogdan Shishedjiev Conceptual Data Model
Example – A Repair Company Bogdan Shishedjiev Conceptual Data Model
Example – A Repair Company Bogdan Shishedjiev Conceptual Data Model
Example – A Repair Company Bogdan Shishedjiev Conceptual Data Model
Example – A Repair Company Bogdan Shishedjiev Conceptual Data Model