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)

Operations Research : Applications and Algorithms
4th Edition
ISBN:9780534380588
Author:Wayne L. Winston
Publisher:Wayne L. Winston
Chapter19: Probabilistic Dynamic Programming
Section19.4: Further Examples Of Probabilistic Dynamic Programming Formulations
Problem 7P
icon
Related questions
Question

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

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 courselD 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
Transcribed Image Text: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 courselD 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
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Public key encryption
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Operations Research : Applications and Algorithms
Operations Research : Applications and Algorithms
Computer Science
ISBN:
9780534380588
Author:
Wayne L. Winston
Publisher:
Brooks Cole