Consider the following information about a university database: Professors have an SSN, a name, a rank, and a research specialty. Projects are identified by a project number, more than one sponsor name (e.g., NSF), a starting date, an ending date, and a budget. Graduate students have an SSN, a name, and a current degree program (e.g., M.S.or Ph.D.). Each project is managed by one professor, each project is worked on by one or more professors and each project is worked on by one or more graduate students. When graduate students work on a project, a professor must supervise their work on the project. Graduate students can work on multiple projects. Departments have a department number, a department name, and a main office. Departments have a professor (known as the chairman) who runs the department. Professor works in one or more departments and for each department that they work in, a time percentage is associated with their job. Design and draw an ER diagram that captures the information about the University. 60

Consider the following information about a university database: Professors have an SSN, a name, a rank, and a research specialty. Projects are identified by a project number, more than one sponsor name (e.g., NSF), a starting date, an ending date, and a budget. Graduate students have an SSN, a name, and a current degree program (e.g., M.S.or Ph.D.). Each project is managed by one professor, each project is worked on by one or more professors and each project is worked on by one or more graduate students. When graduate students work on a project, a professor must supervise their work on the project. Graduate students can work on multiple projects. Departments have a department number, a department name, and a main office. Departments have a professor (known as the chairman) who runs the department. Professor works in one or more departments and for each department that they work in, a time percentage is associated with their job. Design and draw an ER diagram that captures the information about the University. 60

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

WHAT ARE THE 2 MAJOR APPROACHES TO DESIGN A DATABASE
If you wish to rapidly access data in a centralized database, what design considerations are made differently than in a distributed database?
Explain a database's whole operation.
In what ways does using a database have its drawbacks?
Explain how object-oriented design and relational database design are similar and different.
Explain integral data types and indexes.
Give an explanation for each of the following terms: database
Outline the steps involved in query processing in a distributed database.
It is recommended that the following be covered in every training session for a new user of the school database:
So, what does it mean to "own" data?
What are the advantages of using a database rather than another method?
What exactly is the function of a database?