Answered: Given the information below, create the…

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

Related questions

Concept explainers

Question

100%

Given the information below, create the fully labeled Crow's Foot ERD using a specialization hierarchy where appropriate (use Visio). The ERD must contain all primary keys, foreign keys, and main attributes. Business rules are defined as follows:

A large university consists of several schools. Each school is chaired by one employee. An employee may be the dean of one and only one school. All employees are classified into three categories: Professors, Administrators, and Staff. A professor may also be an administrator.The university wants to record the following data for all employees: ID, full name, and address. In addition, the university wants to include data that are peculiar to each category. The list of such attributes includes but is not limited to the following: the highest degree earned by a professor, the title of an administrator, and hourly rate for staff.Each professor is assigned to either teaching or research position but not both. For professors teaching classes, the university wants to keep track of the number of classes taught and the average rating. For professors working on research, the total amount of grant money received must be included.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions