Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 unique ID number, a name, a netlink ID and a home address. It is possible for a particular 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 member
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started