Question: You have been tasked with creating a database management system for scheduling seminars at aCanadian University. After conducting interviews with the staff, you have gathered

You have been tasked with creating a database management system for scheduling seminars at aCanadian University. After conducting interviews with the staff, you have gathered the followinginformation about the entities, attributes, and initial business rules:- Every room is identified by a Building ID, Room No, and has a specific Capacity.- A room can be classified as either a conference room or a classroom.- If the room is a classroom, it has an additional attribute called Board Type.- Computers are identified by a CompType ID and have attributes such as Computer Type, TypeDescription, Disk Capacity, and Processor Speed.- Presenters are identified by an Emp ID and have attributes such as Name and Rank.- Seminars are identified by a Seminar ID and have attributes such as Seminar Description andCredits. Seminars can have zero or more prerequisites (knowledge from attending previousseminars) and can have one or more sessions.- Each session is identified by a session ID and has an attribute called Enrollment Limit.Additionally, you have come up with some additional business rules to aid in the initial design:- A presenter can teach zero or many sessions of a seminar in a given semester.- A presenter specifies preferred time slots for scheduling.- A room can be scheduled for one session or no session during one time slot in a given semester ofa given year. However, one room can participate in many schedules, one schedule, or no schedules;one session can participate in many schedules, one schedule, or no schedules.- A conference room can have one or more computer types, while a classroom does not have anycomputers.- A room cannot be both a classroom and a conference room. There are no other room types to beincorporated into the system. Make an 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 Databases Questions!