Discuss the issues to convert the relationship for the new


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)
Zipcode(Zipcode, City, State)

Request for Solution File

Ask an Expert for Answer!!
Basic Computer Science: Discuss the issues to convert the relationship for the new
Reference No:- TGS0143059

Expected delivery within 24 Hours