Database Answers Car Transporter

Printer Printer-friendly version.

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
Customer Deliveries

The Draft Business Rules have been defined and are listed below.
The Area being Modelled is :-
A Food Manufacturing Business.

A. DESIGN NOTES :
A.1 The Detail reflects the Requirements.
For example, Drivers have been included, but if this level of detail is not in the Requirmenet,
then Drivers can be removed, which will simplify the Model.

B. The Things of Interest, ('THINGS'), include :-
B.1 Customers, which are Distributors.
B.2 Delivery Routes.
B.3 Locations on Routes.
B.4 Employees, which are Drivers in this Model.
B.5 Orders - which can be either Regular Orders and Actual Orders.
B.6 Products.
B.7 Trucks

C. These THINGS are Related as follows :-
C.1 A DELIVERY_ROUTES visits a number of DELIVERY_ROUTE_LOCATIONS.
C.2 A DELIVERY contains a number of ORDERS.
C.3 An ORDER contains a number of PRODUCTS.
C.4 A REGULAR_ORDER allows the Customer, (Distributor), to say "Send me my Regular Order".
C.5 An ACTUAL_ORDER allows for changes to the REGULAR_ORDER.
C.4 A TRUCK can be associated with zero, one or many ORDER_DELIVERIES.

D. Other Characteristics of these THINGS include :-
D.1 A CUSTOMER can have one or zero PHONE_NUMBER.

E. Sample Data includes :-
E.1 To be determined

F. Typical Enquiries include :-
F.1 To be Determined
 
A GLOSSARY OF TERMS WOULD GO HERE AS A TABLE ...
Barry Williams
24th. February 2003
Principal Consultant
Database Answers
Home Ask a Question Careers Contact us Data Models First Timers Search Site Map