Back to the Data Model.
The User Requirements have been defined below.
The Area being Modelled is :-
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.3 Payment Methods
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
28th. October 2006