Question: database management Q1. Draw an entity relationship diagram for the following situation: PSUT university depends on several types of persons for its successful operation: The

database management database management Q1. Draw an entity
database management Q1. Draw an entity
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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!