Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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.

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
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
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

SEE SOLUTIONCheck out a sample Q&A here
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
SEE MORE TEXTBOOKS