Syllabus Detail

  • Resolve complex many to many (M:N) relationships in an RDBMS. 12 ATAR

 

Step 1 - Background

  • Many-to-many (m:n) relationships add complexity and confusion to your model and to the application development process. The key to resolve m:n relationships is to separate the two entities and create two one-to-many (1:n) relationships between them with a third intersect entity. The intersect entity usually contains attributes from both connecting entities.. (more here)

Step 2 - Vocabulary

  • Entities

 

Step 3 - Summary of Main Points

  • Main point 1 is here
  • Main point 2 is here

 

Step 4 - The Detail

 Not 

 

Step 5 - Further Research

  1. Geek

 

Step 6 - Worksheet and Practice (yet to be added)

 

 

Found an error on this page? Please let us know via the contact form under the Home menu item.