Database Answers Header Fishing Boat in Fog, Alaska
Data Model for Customers - Commercial and Personal
Home Ask a Question Careers Data Models FAQs SQL Scripts Search Site Map  

You can check out the FACTs or Business Rules which the Data Model must comply with.

There is also a Data Model for Organisations, Persons and Products.
I have drafted some Design Notes on implementation of Inheritance, and here are corresponding diagrams for three Physical Data Models :-

  1. Model Nr.1, like the Conceptual one, showing the master entity, with two children.
  2. Model Nr.2, showing only the two children, each having inherited the attributes of the parent.
  3. Model Nr.3, showing the master entity, with all attributes of both children.

Conceptual Data Model for Customers - Commercial and Personal

Barry Williams
Principal Consultant
Database Answers


[ Home Page | Day in the Life | Email Us | FAQs | Site Map ]

© Database Answers 2001