How to model triplet connections?

My database is of a common school, with courses, people, semesters, etc. I have roles that people hold, such as instructor, student, trustee, volunteer, etc. How can I create relationships such as this person has a student connection to this course? Or this person has an instructor connection to that course? It looks like three things need to be picked to complete the connection but connections only involve two objects.

You could connect Object A to Object B and connect Object B to Object C.

Hi @Greymont,

If I’m understanding you correctly, you can simply create multiple connection fields.

Let’s say your objects are:

  • Courses
  • Students
  • Instructors
  • Enrollments

The Courses object would have a connection field for Instructors and another for Enrollments (i.e. each course has instructor(s) and many enrollments)
The Enrollments object would have a connection field for Student and another for Course.

The reason for putting Enrollments in its own object—rather than putting a Students field directly on the Course—is so we can capture additional information about the enrollment such as the semester/dates of enrollment, grade received, etc.