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
Get step-by-step solutions from verified subject matter experts
