Database Redesign After your database was put into production, a design flaw was

Question

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?

Explanation / Answer

Vehicle to driver relationship should be N:M. A single vehicle can have multiple drivers, in different points of time. Therefore, the vechicle table should have driver number in it's columns, and a field isActive which would indicate the current driver of the vehicle.

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.