Develop an EER model for the following situation using the traditional EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by your instructor:
An international school of technology has hired you to create a database management system to assist in scheduling classes. After several interviews 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 a classroom. If it is a classroom, it has an additional attribute called Board Type.
• Media is identified by MType ID and has attributes of Media Type and Type Description. Note: Here we are tracking type of media (such as a VCR, projector, etc.), not the individual piece of equipment. Tracking of equipment is outside the scope of this project.
• Computer is identified by CType ID and has attributes Computer Type, Type Description, Disk Capacity, and Processor Speed. Please note: As with Media Type, we are tracking only the type of computer, not an individual computer. You can think of this as a class of computers (e.g., PHI 900MHZ).
• Instructor has identifier Emp ID and has attributes Name, Rank, and Office Phone.
• Timeslot has identifier TSIS and has attributes Day Of Week, Start Time, and End Time.
• Course has identifier Course ID and has attributes Course Description and Credits. Courses can have one, none, or many prerequisites. Courses also have one or more sections.
• Section has identifier Section 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:
• An instructor teaches one, none, or many sections of a course in a given semester.
• An instructor specifies preferred time slots.
• Scheduling data are kept for each semester, uniquely identified by semester and year.
• A room can be scheduled for one section or no section 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 time slot can participate in many schedules, one schedule, or no schedules; one section can participate in many schedules, one schedule, or no schedules. Hint: Can you associate this to anything that you have seen before?
• A room can have one type of media, several types of media, or no media.
• Instructors are trained to use one, none, or many types of media.
• 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. There also are no other room types to be incorporated into the system.