Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Data Mining

Authors: Pang Ning Tan, Michael Steinbach, Vipin Kumar

1st Edition

321321367, 978-0321321367

More Books

Students also viewed these Databases questions

Question

=+Can your message work in another locale?

Answered: 1 week ago

Question

What is the relationship between diversity, inclusion, and equity?

Answered: 1 week ago