Database Answers Header Contacts in Fiji
FACTS for the Data Model for Contacts and Products
Home Ask a Question Careers Data Models FAQs SQL Scripts Search Site Map  

A Conceptual Data Model is also available.

A very simple contacts database to list company products, company profiles and 
communications with that company. 

A. What are the Things of Interest in the area being modelled :-
A.1 Company Profiles.
A.2 Communications.
A.3 Contacts - a person authorised by the Company to communicate on their behalf.
A.4 Our Employees
A.5 Products.

B.How are they related ?
B.1 A COMPANY offers one or many PRODUCTS.
B.2 A COMMUNICATION is always with either one COMPANY or one CONTACT.
B.3 A COMMUNICATION can be made by zero or one of OUR_EMPLOYEES.
B.4 A COMMUNICATION can relate to zero or one PRODUCT.
B.5 A COMMUNICATION always has one of a defined set of OUTCOMEs.
B.6 A COMMUNICATION always has a defined STATUS.
B.7 A PRODUCT can be offered by one and only one COMPANY.

Barry Williams
Principal Consultant
Database Answers

[ Home Page | Ask Us a Question | Day in the Life | Email Us | FAQs | Search & Site Map ]

© IceBreaker WebDesigns 2001