Master-Detail Relationship A master-detail relationship is a one-to-many type relationship. For example, in one school there are multiple departments. That is, there is a one-to-many relationship between the school and departments.