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