• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

1. Core Access > 11. Use a Junction Table

Use a Junction Table

Correctly model a many-to-many relationship.

It’s easy to fall into the trap of assuming all relationships are of the one-to-many type. It’s true that many data relationships do follow the one-to-many paradigm. For example, one person has zero or more telephone numbers. However, not all data is meant to be modeled in this way.

A perfect example of data that appears to fit the one-to-many model, but doesn’t, is the relationship between instructors and students. On the one hand, one instructor does have many students, thereby proving a one-to-many relationship exists. On the other hand, one student has many instructors—which is also a one-to-many relationship. So, what is the problem?


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint