8. 8. 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 inn CAR?

e. Develop a dependency-preserving solution that eliminates this Normal Form violation. Is your solution a lossless-join decomposition?

8. consider the following relation instance of the CAR relation schema: CAR Model #cylinders Origin Tax Fee 15 30 Japan Mustang USA 45 Fiat Italy 18 30 Accord 15 Japan USA. 45 Century Musta Canada Monte Carlo Canada 45 Civic Japan 15 Mustang Mexico 15 30 Mustang Mexico 15 45 Civic Korea 15 30 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? e. Develop a dependency-preserving solution that eliminates this Normal Form violation. Is your solution a lossless-join decomposition? 459