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)