Consider the following relation: CAR-SALE(Car#, DateSold, Salesman, Commission%, DiscountAmt). Assume that a car may be sold by multiple salesmen and hence CAR#, Salesman#1 is the primary key. Suppose the following dependencies exist: DateSold -> DiscountAmt, and Salesman#-> Commission% (1) Is this relation in 1NF? Why or why not? (5 points) (2) Is this relation in 2NF? Why or why not? (5 points) (3) Is this relation in 3NF? Why or why not? (5 points) (4) Please successively normalize this relation up to 3NF (include the detailed normalization steps for 1NF, 2NF, and 3NF, respectively). For each new relation obtained in the normalization/decomposition process, please underline the primary key of the relation. (30 points)