Question
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
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