a) Consider the following relation: CAR_SALE(Car, Date_sold, Salesperson, Commission, Discount_amt) Assume that a car may be sold by multiple salespeople, and hence {Car, Salesperson is the primary key. Additional dependencies are Date_sold Discount_amt Salesperson Commission Based on the given primary key, is this relation in INF, 2NF, or 3NF? Why or why not? How would you successively normalize it completely? b) Normalize the following table with different level of Normalization. EmplD Name Manager Dept. Sector Spouse! Children Engineering 6G Lisa 285 Carl Carison Smithers 365 Lenny Smithers Marketing 8G Hamer Simpson Mr. Burns Safety 7G 458 Maggie Marge Bart