Question 4: University Enrollment [7 marks] Construct an E/R diagram for the university enrollment system described below, which is a less simplified model than the one we have used during lectures. In particular, your model should treat all members of the university (students and staff) as similar entities, congruent to the system used at UVic. This question will be marked based on the correctness of the E/R diagram and the validity of any assumptions made while interpreting the requirements below. If you make any assumptions you may want to write them down and submit them with your answer. Remember to include primary keys for each entity in the diagram. You may add surrogate keys, but you will lose marks if you add surrogate keys in cases where they are unnecessary The model should contain entities for faculties (e.g. the Faculty of Engineering), departments (e.g. the Department of Computer Science), members (e.g. a student or staff member), courses (e.g. CSC 370) and course offerings (e.g. the Spring 2018 offering of CSC 370). Your solution may contain additional entities as necessary Students and staff are all considered to be 'members' of the university. Each member has a member to be both a student and a staff member A faculty (such as the Faculty of Engineering) has a name and a main office location. Each faculty has a dean, which will be a staff membeir . A department (such as the Department of Computer Science) has a name and a main office location, and is associated with exactly one faculty. Each department has a chair, which will be a staff member. A department must have exactly one chair. Each course has a name and a course code (which is unique across the university). Every course is also associated with exactly one department. A course offering has a term code (e.g. '201701') and section number (e.g. A01'). Each offering is associated with one particular course, but a course may have multiple associated offerings (even within the same term) Some members are students. Each student must be a member of a faculty. Students may also have declared a major (or two majors) with a department Students may enroll in one or more course offerings. Each enrollment has an associated grade Some members are staff members. Staff members must be employed by at least one depart ment. Staff members may be the instructor for one or more course offerings Courses may have multiple instructors, or no instructor at all (for cases where no instructor has been assigned yet)
