Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
davekey
Starting Member
4 Posts |
 Posted - 2006-03-26 : 15:52:12
|
| i am finding it hard to normalize this data for this question can you pls help. it has to be in 3nf formCan-O-Worms Ltd. make and sell compost bins over the internet. There are seven types of bin, each having a code and price. Their Sales Order dept take customer information (name, address, type and quantity of bins) from a simple email posting. The bins are shipped to the customer and the shipments logged into a delivery book , giving customer name and address, shipper (Parcel force, TNT, ANC, Overnite, Royal Mail), date shipped, quantity and type of each bin.Bins are shipped on a 30 day return policy, so after one month of shipping an invoice is sent to the customer. The invoice also details each bin supplied, the date it was shipped, unit cost of each bin, the overall invoice cost.Customer payments (cheque numbers) are logged and matched against a copy of the invoice before banking. Every month the log is searched for outstanding debts and these are compiled into a report. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
|
|
|
|
|
|
|
nomalizaton for databases