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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
