Question: 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
.png)
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?
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
Step by Step Solution
3.33 Rating (168 Votes )
There are 3 Steps involved in it
a Minimal cover F fd1 fd2 where fd1 cylinders Fee fd2 Origin Tax b The only candidate key o... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
887-CS-DB (2200).docx
120 KBs Word File
