4. 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 as 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 universitys 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.

FIGURE The conceptual UML class diagram for Tiny College 4.36 SCHOOL PROFESSOR is dean of 1..1 is headed by SCHOOL CODE operates PROF NUM SCHOOL NAME DEPT CODE 1..1 0.1 PROF NUM 1..1 -PROF SPECIALTY -PROF RANK PROF LNAME 1.1 PROF FNAME PROF INITIAL teaches PROF EMAIL 1..1 0..1 is chaired by is employed by 1. 1..1 DEPARTMENT 0.." is advised by employs DEPT CODE DEPT NAME STUDENT 0.1 -SCHOOL CODE is operated by STU NUM PROF NUM DEPT CODE -STU UNAME STU FNAME 1..1 offers STU INITIAL is taught by enrolls 0 is offered by STU EMAIL PROF NUM CLASS 1..1 COURSE CODE CODE 0... HCLASS SECTION s generated by generates DEPT CODE CLASS TIME -CRS TITLE CRS CODE -CRS DESCRIPTION -PROF NUM CRS CREDIT ROOM CODE scheduled in 1..1 used for ROOM BUILDING 1..1 ROOM CODE ROOM TYPE BLDG NAME located in contains BUDG LOCATION BLDG CODE FIGURE The conceptual UML class diagram for Tiny College 4.36 SCHOOL PROFESSOR is dean of 1..1 is headed by SCHOOL CODE operates PROF NUM SCHOOL NAME DEPT CODE 1..1 0.1 PROF NUM 1..1 -PROF SPECIALTY -PROF RANK PROF LNAME 1.1 PROF FNAME PROF INITIAL teaches PROF EMAIL 1..1 0..1 is chaired by is employed by 1. 1..1 DEPARTMENT 0.." is advised by employs DEPT CODE DEPT NAME STUDENT 0.1 -SCHOOL CODE is operated by STU NUM PROF NUM DEPT CODE -STU UNAME STU FNAME 1..1 offers STU INITIAL is taught by enrolls 0 is offered by STU EMAIL PROF NUM CLASS 1..1 COURSE CODE CODE 0... HCLASS SECTION s generated by generates DEPT CODE CLASS TIME -CRS TITLE CRS CODE -CRS DESCRIPTION -PROF NUM CRS CREDIT ROOM CODE scheduled in 1..1 used for ROOM BUILDING 1..1 ROOM CODE ROOM TYPE BLDG NAME located in contains BUDG LOCATION BLDG CODE