[Solved]1 Idea Functional Dependencies Purpose Normalization Process Definition 2nd Normal Form De Q37161995

1. What is the idea of functional dependencies? What is thepurpose of normalization process? What is the definition of 2ndnormal form? What is the definition of 3rd normal form?

2.CAR_SALE (CarNo, Date_Sold, Salesman, Commission,Discount_amt) Assume that a car can be sold by multiplesalesmen.Assume the following additional dependencies:

Car# –> Date_sold

Date_sold–> Discount_amt

Salesman# –>  commission

A. Based on the given primary key, is the relation in 1NF, 2NFor 3NF? Explain why or why not

B. Normalize the relation CAR_SALE completely to 3NF.

Expert Answer

---

Answer to 1. What is the idea of functional dependencies? What is the purpose of normalization process? What is the definition of … . . .