1. Consider the following relation:
CAR_SALE(Car#, Date_sold, Salesman#, Commission%, Discount_amt)
Assume that a car may be sold by multiple salesmen, and hence {Car#, Saleman#} is the primary key. Additional dependencies are
Date_sold -> Discount_amt
Salesman# -> Commission%
a) Based on the given primary key, is this relation in 1NF, 2NF, or 3NF? Why?
b) Normalize the design so that the resulting relational schemas are in 3NF. Only list the final relational schemas, no process necessary.
2. Below is one report from some pet clinic: see image.
Un-normalized form (UNF): (PET_ID, PET_NAME, PET_TYPE, PET-AGE, OWNER, (VISIT_DATE, PROC_NO, PROC_DESC)* )
a) Based on the data, is the UNF in 1NF, 2NF, or 3NF?
b) Normalize the design so that the resulting relational schemas are in 3NF. Only list the final relational schemas, no process necessary.