Consider the following relation instance of the CAR relation schema:

a. What is the minimal cover of functional dependencies that exists in CAR?
b. What is (are) the candidate key(s) of CAR?
c. If there is more than one candidate key, select a primary key from among the candidate keys.
d. Based on the primary key, what is the immediate normal form violated in CAR?

Transcribed Image Text:

Model Camry Mustang Fiat Accord Century Mustang Monte Carlo Civic Mustang Mustang Civic Origin Japan USA Italy Tax 15 0 18 15 0 0 0 15 15 15 15 #cylinders Fee 30 45 30 30 45 30 45 30 30 45 30 6 4 Japan USA Canada Canada Japan Mexico Mexico Korea 4 6 4 6 4