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.

FIGURE 4.36 The conceptual UML class diagram for Tiny College PROFESSOR SCHOOL is dean of heeded by operales SCHOOL CODE SCHOOL NAME PROF NUM DEPT CODE PROF SPECALTY PROF RANK PROF LNAME 0 PROF NUM 11 PROF FHAME chaira PROF INTIAL teachesPROF EMAIL D.1 is chaired by is employed by 0 Is advised by DEPARTMENT employs DEPT NAME DEPT CODE STUDENT 0.1 CHOOL CODE is operated by STU NUIM DEPT CODE maorsn PROF NUM STU UNAME STU FNAME STU INITIAL STU EMAIL -PROF NUM 1offers 0is taught by Tols is offered by CLASS COURSE has roll CRS CODE DEPT CODE -CRS TITLE -CRS DESCRIPTION CRS OREDIT a..* LASSSECTION CLASS TIME CRS CODE PROF NUM ROOM CODE is generated by generates - e. scheduled in used fer ROOM RCOM CODE RCOM TYPE BLDG CODE BUILDING BLEG CODE BLDG NAME Iccated in contains BLDG LOCATICN FIGURE 4.36 The conceptual UML class diagram for Tiny College PROFESSOR SCHOOL is dean of heeded by operales SCHOOL CODE SCHOOL NAME PROF NUM DEPT CODE PROF SPECALTY PROF RANK PROF LNAME 0 PROF NUM 11 PROF FHAME chaira PROF INTIAL teachesPROF EMAIL D.1 is chaired by is employed by 0 Is advised by DEPARTMENT employs DEPT NAME DEPT CODE STUDENT 0.1 CHOOL CODE is operated by STU NUIM DEPT CODE maorsn PROF NUM STU UNAME STU FNAME STU INITIAL STU EMAIL -PROF NUM 1offers 0is taught by Tols is offered by CLASS COURSE has roll CRS CODE DEPT CODE -CRS TITLE -CRS DESCRIPTION CRS OREDIT a..* LASSSECTION CLASS TIME CRS CODE PROF NUM ROOM CODE is generated by generates - e. scheduled in used fer ROOM RCOM CODE RCOM TYPE BLDG CODE BUILDING BLEG CODE BLDG NAME Iccated in contains BLDG LOCATICN