Master-Detail-GrandDetail Relationship

A master-detail-granddetail relationship is a one-to-many-to-many type relationship.

For example, in one school there are multiple departments, and in each department there are multiple courses. That is, there is a one-to-many-to-many relationship between the school, departments, and courses.