Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database And Expert Systems Applications 24th International Conference Dexa 2013 Prague Czech Republic August 2013 Proceedings Part 2 Lncs 8056

Authors: Hendrik Decker ,Lenka Lhotska ,Sebastian Link ,Josef Basl ,A Min Tjoa

2013th Edition

3642401724, 978-3642401725

More Books

Students also viewed these Databases questions

Question

What is polarization? Describe it with examples.

Answered: 1 week ago

Question

recognise typical interviewer errors and explain how to avoid them

Answered: 1 week ago

Question

identify and evaluate a range of recruitment and selection methods

Answered: 1 week ago

Question

understand the role of competencies and a competency framework

Answered: 1 week ago