Database Answers Being an Actor takes Courage
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for a Party Master Index   
An Access Database is available on demand.

If you are new to Data Models, this page of my new Tutorial will help you understand the Data Model.
A perennial problem is that Data Modellers sometimes need to talk about Customers and Parties, but business users and SMEs prefer to talk only about Customers because Party can be a difficult concept to grasp at first.
This means we need an approach that is acceptable to both types of people.
I created this Data Model because the Party Master Index looks like it might offer a neat and simple solution to this perennial problem.

If you have any comments we would be glad to hear them.
This is the Business-eye View (aka 'Semantic Model') for a Customer, Staff and Supplier.

Business-eye Semantic Data Model for Party Master Index
This is the Logical design

Logical Data Model for Party Master Index
This is the Physical design where we have showed the Attributes to clarify the details.

Physical Data Model for Party Master Index

Barry Williams
Principal Consultant
Database Answers Ltd.
London, England
June 20th. 2012

© DataBase Answers Ltd. 2012
About Us Contact Us