Question: Draw an EER diagram (EERD) for the following problem using EER notation covered in this class (i.e., Visio notation). An international school of technology has

Draw an EER diagram (EERD) for the following problem using EER notation covered in this class (i.e., Visio notation). An international school of technology has hired you to create a database management system to assist in scheduling classes. After several interview with the president, you have come up with the following list of entities, attributes, and initial business rules:

Room is identified by Building ID and Room No and also has a Capacity. A room can be either a lab or classroom. If it is a classroom, it has an additional attribute called Board type. A lab has one or more computer types. However, a classroom does not have any computers.

A room cannot be both a classroom and a lab. These also are no other room types to be incorporated into the system.

Computer is identified by ComputerModel ID (please note: There are numerous computers with each computer model.) and has attributes Computer Type, Type Description, Disk Capacity, and Processor Speed. (Therefore, computer entity and lab entity have many-to-many relationship, which requires associative entity. Let's call the associative entity "Contain").

Course has identifier Course ID and has attributes Course Description and Credits. Courses also have one or more sections

Section has identifier Section ID and attribute Enrollment Limit. Section has attributes Semester and Year.

Scheduling data are kept for each semester, uniquely identified by schedule ID.

A room can participate in many schedules, one schedule, or no schedules; one section can participate in many schedules, one schedule, or no schedules.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!