Conceptual Data Model 2 Constraints History Analytical Model

Conceptual Data Model 2 Constraints History Analytical Model Bogdan Shishedjiev Conceptual Data Model 1

Constraints • Types – Assembly – Stability – Subtyping • Disjoin • Cover Bogdan Shishedjiev Conceptual Data Model 2

Assembly Constraints • Inclusion {[Takes exam] [enrolls]} Bogdan Shishedjiev Conceptual Data Model 3

Assembly Constraints • Totality Bogdan Shishedjiev Conceptual Data Model 4

Assembly Constraints • Exclusivity {not ([enrolls] and [candidate])} Bogdan Shishedjiev Conceptual Data Model 5

Assembly Constraints • Equality Bogdan Shishedjiev Conceptual Data Model 6

Assembly Constraints • XOR Bogdan Shishedjiev Conceptual Data Model 7

Stability Constraints • Association stability Bogdan Shishedjiev Conceptual Data Model 8

Stability Constraints • Link stability Bogdan Shishedjiev Conceptual Data Model 9

Stability Constraints • Attribute Stability Bogdan Shishedjiev Conceptual Data Model 10

Subtype Constraints • Disjoint – Every instance is in a only one subtype • Cover – All instances are in subtypes Bogdan Shishedjiev Conceptual Data Model 11

Case Study - Policlinic Bogdan Shishedjiev Conceptual Data Model 12

Case Study - Policlinic Bogdan Shishedjiev Conceptual Data Model 13

Historicizing • Historicizing an attribute Bogdan Shishedjiev Conceptual Data Model 14

Example – A Repair Company Bogdan Shishedjiev Conceptual Data Model 15

Example – A Repair Company Bogdan Shishedjiev Conceptual Data Model 16

Example – A Repair Company Bogdan Shishedjiev Conceptual Data Model 17

Example – A Repair Company Bogdan Shishedjiev Conceptual Data Model 18

Example – A Repair Company Bogdan Shishedjiev Conceptual Data Model 19

Example – A Repair Company Bogdan Shishedjiev Conceptual Data Model 20