Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started