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!

Please help me with this question! 4. We want to designe a

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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!