Consider the following information about a university database: • Professors have an SSN, a name, an age, a rank, and a research specialty. • Projects have a project number, a sponsor name, a starting date, an ending date, and a budget. • Graduate students have SSN, a name, an age, and a degree program (e.g., M.S. or Ph.D.). • Each project is managed by one professor (known as the project’s principal investigator). • Each project is worked on by one or more professors (known as the project’s coinvestigators). • Professors can manage and/or work on multiple projects. • Each project is worked on by one or more graduate students (known as the project’s research assistants). • When graduate students work on a project, a professor must supervise their work on the project. Graduate students can work on multiple projects, in which case they will have a (potentially different) supervisor for each one. • Departments have a department number, a department name, and a main office. • Departments have a professor (known as the chairman) who runs the department. • Professors work in one or more departments, and for each department that they work in, a time percentage is associated with their job. • Graduate students have one major department in which they are working on their degree. Create an ER/EER diagram that fulfils the above requirements and motivate your suggestions. The exercise will be assessed both according to correct ER/EER syntax and whether you have made a good design

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Consider the following information about a university database: • Professors have an SSN, a name, an age, a rank, and a research specialty. • Projects have a project number, a sponsor name, a starting date, an ending date, and a budget. • Graduate students have SSN, a name, an age, and a degree program (e.g., M.S. or Ph.D.). • Each project is managed by one professor (known as the project’s principal investigator). • Each project is worked on by one or more professors (known as the project’s coinvestigators). • Professors can manage and/or work on multiple projects. • Each project is worked on by one or more graduate students (known as the project’s research assistants). • When graduate students work on a project, a professor must supervise their work on the project. Graduate students can work on multiple projects, in which case they will have a (potentially different) supervisor for each one. • Departments have a department number, a department name, and a main office. • Departments have a professor (known as the chairman) who runs the department. • Professors work in one or more departments, and for each department that they work in, a time percentage is associated with their job. • Graduate students have one major department in which they are working on their degree. Create an ER/EER diagram that fulfils the above requirements and motivate your suggestions. The exercise will be assessed both according to correct ER/EER syntax and whether you have made a good design.