Answer Happy

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.