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)