This problem is concerned with modeling of a database that contains information about employees of academic institutions. A employee can either be a professor or a lecturer. _ For each employee, his/her id, name and year of birth. _ For each institution, its name, country, and inauguration year. _ For each institution, the names of its schools (e.g. School of Business, School of Computer Science,. . .). A school belongs to exactly one institution. _ Information about authorships, i.e., which employee have authored a research paper. The titles, ids of research papers should also be stored. _ For each employee, information on his/her highest degree (BSc, MSc or PhD), including who was the main supervisor (must be a professor), and at what school. _ For each lecturer, information on the total number of courses he/she has taught. _ For each professor, information on his/her title and research projects (title, start date, end date and the amount of grant money) in which he/she is a principal investigator. Assuming that there is one but only one principal investigator for each project. 1. Draw an E/R diagram for the relations described above. Your diagram should not contain redundant entity sets, relationships, or attributes. Also, use relationships whenever appropriate
This problem is concerned with modeling of a
_ For each employee, his/her id, name and year of birth.
_ For each institution, its name, country, and inauguration year.
_ For each institution, the names of its schools (e.g. School of Business, School of Computer Science,. . .). A school belongs to exactly one institution.
_ Information about authorships, i.e., which employee have authored a research paper.
The titles, ids of research papers should also be stored.
_ For each employee, information on his/her highest degree (BSc, MSc or PhD), including
who was the main supervisor (must be a professor), and at what school.
_ For each lecturer, information on the total number of courses he/she has taught.
_ For each professor, information on his/her title and research projects (title, start date, end date and the amount of grant money) in which he/she is a principal investigator.
Assuming that there is one but only one principal investigator for each project.
1. Draw an E/R diagram for the relations described above. Your diagram should not
contain redundant entity sets, relationships, or attributes. Also, use relationships
whenever appropriate
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
