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
- 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.