Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Develop an EER model for the following situation using the traditional EER notation. The EER notation can be drawn by hand on paper or on

Develop an EER model for the following situation using the traditional EER notation. The EER notation can be drawn by hand on paper or on computer using word or other tools.
Assignment must be submitted on slate assignment drop box by the deadline.
You were hired to create a database management system for scheduling seminars at XYZ university. After interviews with the staff, you have come up with the following list of entities, attributes, and initial business rules:
Every room has a Building ID, Room No and also has a specific Capacity.
A room can be either a conference room or a classroom.
If the room is a classroom, it has an additional attribute called Board Type.
Computer has a CompType ID and has attributes Computer Type, Type Description, Disk Capacity, and Processor Speed.
Presenter has identifier Emp ID and has attributes Name, Rank.
Seminar has identifier Seminar ID and has attributes Seminar Description and Credits. Seminars can have one, none, or many prerequisites (knowledge from attending previous seminars).
Seminars also have one or more sessions (one session or a series of seminars).
A session has identifier session ID and attribute Enrollment Limit.
After some further discussions, you have come up with some additional business rules to help you
create the initial design:
A presenter could teach one, none, 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 of a 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 has one or more computer types. However, a classroom does not have any computers.
A room cannot be both a classroom and a conference room. There also are no other room types to be incorporated into the system.

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 Constraint Databases

Authors: Peter Revesz

1st Edition

1441931554, 978-1441931559

More Books

Students also viewed these Databases questions