
3. LM->N
   N->L

4. Normal forms in order

0NF
Order(order#, customer#, name, address, orderdate(product#, description, quantity, unitprice))

1NF
Order(order#, customer#, name, address, orderdate)
Order_Product(order#, item#, description, quantity, unitprice)

2NF
Order(order#, customer#, name, address, orderdate)
Order_Product(order#, item#, quantity)
Product(item#, description, unitprice)

3NF

Order(order#, customer#, orderdate)
Customer(customer#, name, address)
Order_Product(order#, product#, quantity)
Product(product#, description, unitprice)


5. Normalization


(i) Functional dependencies are:
Student_id, Major ——>  Advisor
Advisor  ——>  Major

(ii) Anomalies for this table include:

Delete – student deletes advisor info
Insert – a new advisor needs a student
Update – inconsistencies

(iii) Candidate keys are: StudentId, Major or StudentId, Advisor

(iv) The table is 3NF. Major is a prime attribute. 

(v) The table is not BCNF. A BCNF decomposition is R1(StudentId, Advisor), R2(Advisor, Major)