Answered step by step
Verified Expert Solution
Question
1 Approved Answer
3. [20 points] Draw an Entity Relationship (ER) diagram that captures the following information: - Professors have an SSN, a name, an age, a rank,
3. [20 points] Draw an Entity Relationship (ER) diagram that captures the following information: - 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. - Students have an SSN, a name, an age, and a degree program (e.g. B.S. or M.S.) - 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 investigators). - Professors can manage and/or work on multiple projects. - Each project is worked on by one or more students. - When a student works on a project, a professor must supervise their work on the project. Students can work on multiple projects; in which case they will have a (potentially different) supervisor for each one. - Department has a department number, a department name, and a main office. - Departments have a professor name (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. - Students have one major department in which they are working on their degree. - Each student has another, more senior student (known as a student advisor) who advises the student on what courses to take
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