help with normalization of Book and order details

Question

chickenyd 0 Newbie Poster

19 Years Ago

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.

This attachment is potentially unsafe to open. It may be an executable that is capable of making changes to your file system, or it may require specific software to open. Use caution and only open this attachment if you are comfortable working with msword files.

normalization_forum_post_NEW.doc (55 KB)

2 Contributors
1 Reply
114 Views
2 Weeks Discussion Span
Latest Post 19 Years Ago Latest Post by pty

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

pty 882 Posting Pro · Answer 1 · 2006-05-01T20:09:54+00:00

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