Question: Please help me with this question! 4. We want to designe a database to manage the fleet of a small taxi company. We start with
Please help me with this question!

4. We want to designe a database to manage the fleet of a small taxi company. We start with the following table: vehicle(VIN, make, model, year, color, mileage, status, driver_SSN, driver_name, driver_contact, dealer_name) We have the following dependencies: VIN, driver_SSN make, model, year, color, mileage, status, driver_name, driver_contact, dealer_name VIN make, model, year, color, mileage, status driver_SSN driver_name, driver_contact make dealer_name Please identify the candidate keys and BCNF violations (if any). If the table is not in BCNF, decompose it into BCNF ( 9 points)
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
