University Example (cont’d)
You are now told that in addition to the relationships given, each student is assigned a faculty advisor who gives direction in choosing courses.
Use occurrences diagram to visualize relationship between entities
We are told each student is advised by exactly one faculty advisor. We can assume that each faculty member advises zero, one, or more students. This means the additional relationship is of type one-to-many or 1:M.
The STUDENT is on the many side of the relationship and must be advised therefore, faculty is mandatory to student; FACULTY on the one side of the relationship may or may not have a student, therefore student is optional to faculty.