University Example (cont’d)
Step 3. Determine Relationship type (cont’d)
- For FACULTY-teaches-COURSE we are told each faculty member teaches zero, one, or two courses. We are told some courses are taught by zero, one, two, or three faculty. This is a many-to-many relationship.
- For STUDENT-takes-COURSE each student enrols in one to six courses and each course is taken by zero or up to 30 students. This too is a many-to-many relationship.