0% found this document useful (0 votes)
8 views3 pages

Order Normalization Process

Uploaded by

abdullahzahidhp
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
8 views3 pages

Order Normalization Process

Uploaded by

abdullahzahidhp
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

ORDER(order#, customer#, name, address, orderdate(product#, description, quantity, unitprice))

1234 9876 billy 456 11/04/98 A123 pencil 100 3


B234 eraser 200 1.5

C345 sharpner 5 8.00

order# customer# Name Address Orderdate Productno description Quantity unitprice))

1234 9876 billy 456 11/04/98 A123 pencil 100 3


B234 Eraser 100 1.50

C345 Sharpner 5 8.00

1235 …s … …. … … … ..
1st NF

Order(order#,cust#, name, address)

OrderDetail(order#,orderdate, prod#,desc, quantity, unitprice)

2NF

Order(order#,cust#, name, address)

OrderDetail(order#,orderdate,

Product(prod#,desc, quantity, unitprice)

You might also like