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 : 12:55:21
|
| hi i am new to this finding it hard to gras this question i have putting into normalisation 3nfCan-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.would really appreciate advice |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-03-26 : 15:23:00
|
| You should really ask you teacher for help with your homework if you don't understand how to do this.CODO ERGO SUM |
 |
|
|
davekey
Starting Member
4 Posts |
Posted - 2006-03-26 : 16:02:07
|
| he is in belgum unfortunatly on a confronce and i am trying hard to do it on my own but i carnt find any decent web sites |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-03-26 : 17:49:19
|
| Decide on the entities and which properties those entities have.Decide on a PK and make sure that each property is only dependent on the pk.The entities you can get from the description by just looking at what's important.Have a go at that then post what you get for advice.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
|
|
normalization