Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Every person has a name and an address. A person is uniquely identified by their name. There are two groups of persons, staff and students.

Every person has a name and an address. A person is uniquely identified by their name.

There are two groups of persons, staff and students. A person can be a student and staff at the same time

Every staff receives a salary, while every student pays a fee.

Among the staff, there is research and teaching staff. A staff can belong to both groups.

Among the teaching staff, there are lecturers and TAs. A TA works for several courses. (course does not need to be an entity, just add a courseID attribute to an entity TA) Every student is either a graduate student or an undergraduate student.

A graduate student has a thesis title, on which he/she is working.

An undergrad is in the final year if he/she is in his/her 4th year.

Every final year student is working on a project. Every final year student is supervised by a member of the teaching staff Your task:

Draw a E-R diagram that covers the requirements above on a piece of paper or use draw.io and post a screenshot.

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

Big Data, Mining, And Analytics Components Of Strategic Decision Making

Authors: Stephan Kudyba

1st Edition

1466568704, 9781466568709

More Books

Students also viewed these Databases questions