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