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 (e.g., NSF), a starting date, an ending date, and a budget. Graduate students have an SSN, a name, an age, and a degree program (e.g., M.S. or PhD.). 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 co￾investigators). 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 theirdegree. Each graduate student has another, more senior graduate student (known as a student advisor) who advises him or her on what courses to take.Design and draw an ER diagram that captures the information about the university.

Question
Asked Oct 8, 2019
366 views

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 (e.g., NSF), a starting date, an ending
date, and a budget.
 Graduate students have an SSN, a name, an age, and a degree program (e.g., M.S. or
PhD.).
 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 co￾investigators).
 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.
 Each graduate student has another, more senior graduate student (known as a student
advisor) who advises him or her on what courses to take.
Design and draw an ER diagram that captures the information about the university.

check_circle

Expert Answer

Step 1

Below is the ER Diagram based on the information g...

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in

Engineering

Computer Science

Databases

Related Computer Science Q&A

Find answers to questions asked by student like you

Show more Q&A add
question_answer

Q: Consider a program that declares global integer variables x, y[10]. Thesevariables are allocated sta...

A: Explanation of the code: lw $s1, 0($gp) #load value in base address to $s1addi $s1, $s1, 25 #increme...

question_answer

Q: In C++ programming. Below is the UAH_sample.txt The University of Alabama in Huntsville was founded ...

A: Since the program is quite complex we are answering only the first part due to lack of space, it is ...

question_answer

Q: create a file in c++. In this lab, you will replace the existing functions with more flexible ones, ...

A: Program Instructions:Define the necessary constants and header files.Use displayMessage() function t...

question_answer

Q: m2 separated by a distance d is given by:F = Gm1m2d 2where G is the universal gravitational constant...

A: A C++  program to display the gravitational force between two objects is given below;Program code://...

question_answer

Q: Discuss whether barcodes are more or less secure than magnetic stripe cards

A: A barcode is square or rectangular lines that consists of black lines and white spaces of different ...

question_answer

Q: Below is code which defines and creates an Array, myList: int [] myList = new int [5]; //define and ...

A: Writing a java program with class name XXX_Lab75. This class consists of two methods:First method is...

question_answer

Q: Twin primes are two primes that differ by 2 (e.g., 3 and 5, 101 and 103). Write a c++ program that o...

A: Twin primes are two primes that differ by 2 (e.g., 3 and 5, 101 and 103).Comment are the not readabl...

question_answer

Q: Write a program in Java Eclipse that does the following:a) create a 2D Ragged array with columns and...

A: Create a Main class and all required methods to print Ragged array elements. And create all methods ...

question_answer

Q: 1. What technique is used to model the situation that Student may have multiple addresses? A) Associ...

A: The answer is option B - Weak entitiesBecause the addresses belong to that student and cannot exist ...