|
The Draft Business Rules have been defined and are listed below.
The Area being Modelled is :-
Avon Cosmetics.
A. DESIGN NOTES :
A.1 The User has defined the Requirements as follows :-
I have been given responsibility for a new Project and my first task
is to create a model for a cosmetic firm such as Avon (with consultants
who take orders and then give products to clients).
B. The Things of Interest, ('THINGS'), include :-
B.1 Agents
B.2 Customers.
B.2 Franchise Areas.
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
B.6 Products.
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
|
  |
Barry Williams
15th. May 2004
Principal Consultant
Database Answers
|
|