CAR-SALE (Car#, Date-sold, Salesman#, commission%, Discount-amt)

Assume that {Car#, Salesman#} is the primary key. Additional dependencies are

Date-sold -> Discount-amt

Salesman# -> commission%

Based on the given primary key, is this relation in 1NF, 2NF or 3NF? Why or why not? How would you successively normalize it completely?

1. Introduction:

Normalization is a process of achieving good database design. A database design needs some refinement which is achieved through normalization. Complex relations are decomposed into simpler relation using normalizations. Normalization is also used to check quality of database design. There are three levels of normalization. In a given …