Alf Petersen (Entity Relationship Modeling Principles) indicates that a many-to-many relationship is technically impossible to implement because the relationship requires that both entities in the relationship exist before the other. Discuss how a many to many relationship might be resolved for the following relations. As part of your discussion, include the role played by keys.

For this assignment, consider the following entities. Assume that you belong to a family that has more than one automobile and that within the family there is more than one driver. The relationship between these two entities would look like the following:

Any driver might be able to drive several vehicles, and several vehicles might be associated with any particular driver. This many-to-many relationship cannot technically exist so it must be resolved.

The following article may provide insight into resolving a many to many relationships between entities: Resolving Many-to-Mary Relationships: http://www.smartdatacollective.com/karenlopez/23039/resolving-many-many-relationships

Vehicles Drivers PK |Vehicle ld Number PK License Number Model Year Name