Q1. Consider the given relation:
CAR_SALE(Car#, Date_sold, Salesman#, Commission%, Discount_amt)
Suppose that a car might be sold by multiple salesmen, and therefore {Car#, Salesman#} is the primary key. Additional dependencies are:
Date_sold →Discount_amt and
Salesman# → Commission%
Based on the given primary key, is this relation is 1NF, 2NF or 3NF? Explain why or why not? How would you successively normalize it wholly?
Q2. A set of FDs for the relation R{A, B, C, D, E, F} is AB → C, C → A, BC → D, ACD → B, BE → C, EC → FA, CF → BD, D→ E. Find out a minimum cover for this set of FDs.
Q3. Describe multi-valued dependencies and as well explain 4NF with suitable illustration.