Database Answers Pebble Beach

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
Customers and Partial Deliveries
Back to the Data Model.

The User Requirements have been defined below.
The Area being Modelled is :-
Partial Orders

User Requirements :-
A database for an online company. 
It should be capable of despatching orders to a different address that the invoicing address, 
and partial as well as complete orders. 

I have normalised the delivery and invoicing addresses, but I am not sure on 
how to normalise the partial and full orders. 

Your help will be greatly appreciated. 

Thanks for your help in advanced. 


A. DESIGN NOTES :
A.1 A Product Hierarchy has been assumed, where each Product has just one Parent Product.

B. The Things of Interest, ('THINGS'), include :-
B.1 Customers
B.2 Orders.
B.3 Payment Methods
B.4 Products.
B.5 Shipments

C. These THINGS are Related as follows :-
C.1 A CUSTOMER can have zero, one or many ADDRESSES. 
C.2 A CUSTOMER can place zero, one or many ORDERS.
C.3 A CUSTOMER can have one or many PAYMENT_METHODS.
C.4 Each ORDER can involve one or many PRODUCTS.
C.5 Each ORDER can involve one or many SHIPMENTS.

D. Other Characteristics of these THINGS include :-
D.1 To be determined

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

F. Typical Enquiries include :-
F.1 To be Determined
  Barry Williams
28th. October 2006
Principal Consultant
Database Answers
Home Ask a Question Careers Contact us Data Models First Timers Search Site Map