Answered step by step
Verified Expert Solution
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
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