Database Answers Old Locks and Keys (Click for Web Site)
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for the Data Model for Inheritance and Customers   
An Access Database is available.

If you are new to Data Models, this page of my new Tutorial will help you understand the Data Model.
In the Logical Data Model we have a Circle symbol that shows an Inheritance Relationship we define a Parent Customer with 3 Children Customers.
Each of the Children inherits all the charactistics of the Parent and has some additional charactistics of its own.
A more detailed Discussion is available.

Conceptual Customers Data Model

Data Model for the Data Model for Inheritance and Customers
Logical Customers Data Model

Data Model for the Data Model for Inheritance and Customers
Conceptual version of Our Canonical Data Model


Canonical Data Model
Physical Data Model
Here we show how we implement Inheritance in a Relational Database.
We copy all Attributes from the 'Children' to the 'Parent' then we create SQL Views for each 'Child'.
This gives us flexibility and power.

Physical Data Model
  Our "Participants" ERwin Canonical Data Model
This is a little different from the Conceptual version

ERwin Canonical Data Model
About Us Contact Us