databace

Q1. Draw an entity relationship diagram for the following situation: PSUT university depends on several types of persons for its successful operation: The university is interested in the following attributes of all persons: SSN, Name, Address, City/State/Zip, and Telephones. Three persons are of greatest interest: professors, students, and clerks. Clerks have date hired and salary attributes, and students have hobbies, major, and GPA attributes. Professors may teach up to 5 courses during the semester and a course is assigned to only one professor. Each course has unique number, capacity, and duration. There are persons other than professors, students, and clerks who are of interest to the university so that a person need not belong to any of these groups. On the other hand, at a given time a person may belong to two or more of these groups. Clerks have a hierarchy of reporting relationships: some of them have supervisory responsibilities in addition to their administrative role and have multiple other clerks report to them. Q2. State the business rules for the following ER diagram