Part II. Normalization Part

2. Consider the following relation:

CAR_SALE(CarNo, Date_Sold, Salesman, Commission, Discount)

1. Assume that a car can be sold by multiple salesmen.
2. Assume the following additional dependencies:
   1. Date_sold -> Discount
   2. Salesman -> Commission

Present the best set of normalized relations for the above set of data.

3. Consider the following relation:

BOOK(Book_title, Author, Book_type, ListPrice, Author_affiliation, Publisher)

And, assume that the following dependencies exist:

Book_title -> Publisher, Book_type

Book_type -> ListPrice

Author -> Author_affiliation

Present the best set of normalized relations for the above set of data.