Database Answers Pebble Beach

Printer Printer-friendly version.

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
Avon Cosmetics

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
Home Ask a Question Careers Contact us Data Models First Timers Search Site Map