help with normalization of Book and order details

Reply

Join Date: Apr 2006
Posts: 1
Reputation: chickenyd is an unknown quantity at this point 
Solved Threads: 0
chickenyd chickenyd is offline Offline
Newbie Poster

help with normalization of Book and order details

 
0
  #1
Apr 14th, 2006
Hi,

I been trying to normalize my data for my project but I got lost half way and I dont know if what I done is correct.

Any have suggestions plz.

I have attached the file.
Attached Files
File Type: doc normalization forum post NEW.doc (55.0 KB, 17 views)
Reply With Quote Quick reply to this message  
Join Date: Oct 2005
Posts: 521
Reputation: pty is on a distinguished road 
Solved Threads: 37
pty's Avatar
pty pty is offline Offline
Posting Pro

Re: help with normalization of Book and order details

 
0
  #2
May 1st, 2006
your orders stuff needs looking at.

you assume that one person will order a quantity of one book on one order.

a better way to do it would be to have multiple order lines belonging to one order; this would allow a customer to make an order for multiple books at once
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the Database Design Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC