Database Redesign
After your database was put into production, a design flaw was discovered! One of the relationships modeled as a 1:N relationship was really an N:M relationship. The database issue invoves the following tables, with PK italicized and underlined.
VEHICAL (VIN, Make, Model, Color, LicenceTag)
DRIVERS (DriverLicenseNo, LastName, FirstName, Address, Zip, VIN)
ZIPCODE (Zipcode, City, State)
Which 1:N relationship should be an N:M relationship? How would you redesign the database to correct the issue? What else must you consider when updating the structure of your database tables?