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#} is the primary key. Suppose the following dependencies exist: Date Sold rightarrow Discount Amt, and Salesman# rightarrow Commission% (1) Is this relation in 1NF? Why or why not? (2) Is this relation in 2NF? Why or why not? (3) Is this relation in 3NF? Why or why not? (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