Database Answers Header Kasbah du Toubkal Hotel, Morocco
Home Ask a Question Data Models FAQs SQL Scripts Search Site Map  
Boschendahl Estate, South Africa A Dezign Data Model is available.
The Draft Business Rules have been defined and are listed below.
A. The Area being Modelled is :-

B. The Things of Interest, ('THINGS'), include :-
B.1 Customers
B.2 Customer Orders
B.2 Deliveries
B.3 Delivery Agencies
B.3 Newsagents
B.4 Newsagents Chains

C. These THINGS are Related as follows :-
C.1 A CUSTOMER can make one or many ORDERS.
C.2 A CUSTOMER_ORDER can be associated with one or many CUSTOMER_DELIVERIES.
C.3 A NEWSAGENT can have zero, one or many CUSTOMERS.

D. Other Characteristics of these THINGS include :-

E. Sample Data includes :-
To be determined

F. Typical Enquiries include :-
F.1 How many Customers does a Newsagent have ?
Barry Williams
Principal Consultant
Database Answers
19th. November 2002
[ Home Page | Ask Us a Question | Email Us | Site Map ]

© 2002