After your database was put into production a design flaw was discovered. One of the relationships identified as a 1:N relationship was determined to be a N:M relationship. Using the example of vehicles and drivers, discuss the issues to convert the relationship for the new cardinality including the new relationships and attributes for the tables.You can Assume that Driver’s License number is always unique, even across different states. Also assume that zipcode determines city and state.Vehicle(VIN, Make, Model, Color, Licence_tag)Drivers(Driver_license_no, last_name, first_name, middle_name, address, zip, VIN)In the given scenario, the VIN, Driver_ID, ZIP are the unique keys, of the table Vehicle, Driverand Zipcode. AsDriver_id is needed by the Vehicle table in order to trace the corresponding vehicle…
New relationships and attributes
We help you get better grades, improve your productivity and get more fun out of college!!
Do my Assignment for me
How it works – it’s easy
Place your Order
Submit your requirements through our small easy order form. Be sure to include and attach any relevant materials.
Make a payment
The total price of your order is based on number of pages, academic level and deadline.
We assign the assignment to the most qualified tutor. When the tutor completes the assignment, it is transferred to one of our professional editors to make sure that the assignment meets all of your requirements.
Once complete, we’ll send your assignment via the email provided on the order form.