|
|
|
|
|
|
|
|
|
|
  |
|
A Dezign Data Model is available.
The Draft Business Rules have been defined and are listed below. A. The Area being Modelled is :-
Newsagents.
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 | |