Please send me answer within 10 min!! I will rate you good for sure!! Please provide some explanation!! 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)
Please send me answer within 10 min!! I will rate you good for sure!! Please provide some explanation!!
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: Design an E-R diagram that covers the requirements above
Step by step
Solved in 2 steps with 2 images
