Question

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.36 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 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 that contains all primary keys, foreign keys, and main attributes.

Answer 1

Pls see the below image for answer,

ER diagram

PROF RANK ROF LNAM SCHOOL NAME ROF SPECIALIT PROF FNAM TITLE CHOOL_COD PROF NUM DEPT CODE PROF INITIA PROF NUM PROF NUM PROF EMAIL ADMINISTRATOR Has PROFESSOR SCHOOL dean of se STU INITIAL STU EMAIL employs Has Chairs STU FNAME PROF NUM STU LNAME STUDENT DEPT CODE DEPT CODE STU NUM ajors DEPARTMENT DEPT NAME in PROF NUM CHOOL COD enrolls CLASS PROF NUM PROF NUM CLASS_COD Gener ates chedule in LASS SECTIO CLASS TIME COURSE CRS CODE CRS CREDIT ate at BUILDING ROOM CRS CODE DEPT CODE CRS dESCRIPTION CRS TITLE BLDG CODE LDG_LOCATIO ROOM CODE BLDG CODE BLDG NAME ROOM TYPE

*************************END*******************PLS GIVE ME UPVOTE************************