Question: ( 1 - 6 ) [ 1 5 points ] A university database system is designed to keep track of students, professors, and courses. The
points
A university database system is designed to keep track of students, professors, and courses. The system should capture the relationships between these entities, with a particular focus on course enrollment and teaching assignments. Draw an EER diagram for each of the following scenarios, taking into account any additional constraints mentioned.
points Students can enroll in multiple courses, and their enrollment history needs to be recorded, including the semester and year of enrollment for each course.
points Professors can teach multiple courses, but for this database, only the courses currently being taught by each professor are recorded.
points Each student must be enrolled in at least three courses every semester.
points Each professor must teach exactly one course each semester no more, no less
points Every course must have at least one student enrolled, and every student must be enrolled in at least one course.
points Modify the model to accommodate the scenario where a course can be cotaught by a team of professors. In this case, introduce any necessary entity sets and relationship sets. Assume that for each course, only the professors currently teaching it are recorded.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
