help with normalization of Book and order details

Expand Post »

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

normalization forum post NEW.doc (55.0 KB, 31 views)

Similar Threads

Forms in Random access files in Visual Basic 4 / 5 / 6
Creating linked pages in PHP
Sending form email in PHP

chickenyd

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Apr 2006

Permalink

May 1st, 2006

Re: help with normalization of Book and order details

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

pty

Reputation Points: 64

Solved Threads: 39

Posting Pro

Offline

530 posts
since Oct 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Database Design Forum Timeline: A database that support multiple mobile platforms

Next Thread in Database Design Forum Timeline: Relationship between Asset, Mac Address and IP address

DaniWeb Message

Cancel Changes

User Name
Password