In Chapter 4, you saw the creation of the Tiny College database design. That design reflected such business rules as “a professor may advise many students” and “a professor may chair one department.” Modify the design shown in Figure 4.36 to include these business rules: An employee could be staff or a professor or an administrator. A professor may also be an administrator. Staff employees have a work level classification, such a Level I and Level II. Only professors can chair a department. A department is chaired by only one professor. Only professors can serve as the dean of a college. Each of the university’s colleges is served by one dean. A professor can teach many classes. Administrators have a position title. Given that information, create the complete ERD containing all primary keys, foreign keys, and main attributes.

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
icon
Related questions
Question
100%

In Chapter 4, you saw the creation of the Tiny College database design. That design reflected such business rules as “a professor may advise many students” and “a professor may chair one department.” Modify the design shown in Figure 4.36 to include these business rules:

  • An employee could be staff or a professor or an administrator.
  • A professor may also be an administrator.
  • Staff employees have a work level classification, such a Level I and Level II.
  • Only professors can chair a department. A department is chaired by only one professor.
  • Only professors can serve as the dean of a college. Each of the university’s colleges is served by one dean.
  • A professor can teach many classes.
  • Administrators have a position title.

Given that information, create the complete ERD containing all primary keys, foreign keys, and main attributes.

 

**Link to previous source acceptable

PROFESSOR
SCHOOL
PK
PROF NUM
is dean of
SCHOOL CODE
PK
FK1 DEPT_CODE
PROF SPECIALTY
PROF_RANK
PROF LNAME
PROF_FNAME
PROF_INITIAL
PROF_EMAIL
SCHOOL_NAME
FK1 PROF_NUM
opetates
DEPARTMENT
advses
employs
DEPT CODE
PK
has
-OH
----
DEPT_NAME
OHFK1 SCHOOL_CODE
FK2 PROF_NUM
chairs
teaches
offers
STUDENT
STU NUM
CLASS
COURSE
CLASS CODE
PK
PK
PK CRS CODE
HHFK1 DEPT_CODE
FK1 DEPT CODE
STU LNAME
STU_FNAME
STU_INITIAL
STU EMAIL
FK2 PROF_NUM
generates
CLASS_SECTION
CLASS_TIME
FK1 CRS_CODE
FK2 PROF_NUM
FK3 ROOM CODE
CRS TITLE
CRS DESCRIPTION
CRS CREDIT
is used for
is writen in
ROOM
PK ROOM CODE
ENROLL
is found in
ROOM_TYPE
FK1 BLDG CODE
PK,FK2 CLASS CODE
PK,FK1 STU NUM
BUILDING
PK BLDG CODE
ENROLL DATE
ENROLL_GRADE
i- contains --HH
BLDG_NAME
BLDG_LOCATION
Cengage leaming O 2015
Transcribed Image Text:PROFESSOR SCHOOL PK PROF NUM is dean of SCHOOL CODE PK FK1 DEPT_CODE PROF SPECIALTY PROF_RANK PROF LNAME PROF_FNAME PROF_INITIAL PROF_EMAIL SCHOOL_NAME FK1 PROF_NUM opetates DEPARTMENT advses employs DEPT CODE PK has -OH ---- DEPT_NAME OHFK1 SCHOOL_CODE FK2 PROF_NUM chairs teaches offers STUDENT STU NUM CLASS COURSE CLASS CODE PK PK PK CRS CODE HHFK1 DEPT_CODE FK1 DEPT CODE STU LNAME STU_FNAME STU_INITIAL STU EMAIL FK2 PROF_NUM generates CLASS_SECTION CLASS_TIME FK1 CRS_CODE FK2 PROF_NUM FK3 ROOM CODE CRS TITLE CRS DESCRIPTION CRS CREDIT is used for is writen in ROOM PK ROOM CODE ENROLL is found in ROOM_TYPE FK1 BLDG CODE PK,FK2 CLASS CODE PK,FK1 STU NUM BUILDING PK BLDG CODE ENROLL DATE ENROLL_GRADE i- contains --HH BLDG_NAME BLDG_LOCATION Cengage leaming O 2015
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education