# CTE Resource Center - Verso - Database Design and Management (Oracle) Task 1685818511

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Resolve many-to-many relationships.

Definition

A many-to-many relationship can be modeled, however, it cannot be implemented in a relational database because it violates data integrity. A many-to-many relationship is reduced to two one-to-many relationships with an intersecting entity. Create a new entity that is positioned between the existing two entities.

Resolution is accomplished by following these steps:

  1. Determine the name of an intersecting entity (name using a combination of the two many-to-many names if necessary).
  2. Define the first one-to-many relationship and put the many on the intersecting entity.
  3. Add the other relationship (which should be the original relationship between the two entities without the cardinality). Define the second one-to-many relationship, again with the many on the intersecting entity.

Other Related Standards

Microsoft Imagine Academy Resources

[2.022] Microsoft Digital Literacy: Productivity Programs—Lesson 6

[4.019] Access 2010: Modify Database Tables—Lesson 3

[5.035] Access 2010: Project 3