***** PLEASE READ THE BOTTOM 2 LINES**********

4): In Chapter 4, you saw the creation of the Tiny College database design, which 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.35 to include these business rules: An employee could be staff, a professor, or an administrator. A professor may also be an administrator. Staff employees have a work-level classification, such as Level I or 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 col- leges is served by one dean. A professor can teach many classes. Administrators have a position title. Given that information, create the complete ERD that contains all primary keys, foreign keys, and main attributes.

A): Please Draw EERD using specialization hierarchy.

B): Transform the EERD into a relational diagram.