Question: 16. Develop an EER model for the following situation using A After some further discussions, you have come up with the traditional EER notation, the

 16. Develop an EER model for the following situation using A

16. Develop an EER model for the following situation using A After some further discussions, you have come up with the traditional EER notation, the Visio notation, or the some additional business rules to help you create the subtypes inside supertypes notation, as specified by your initial design sections of An instructor teaches one, none, or many a course in a given semester . An international school of technology has hired you to create a database management system to assist in sched- An-instrueber speeifies-pre uling classes. After several interviews with the pres Scheduling dent, you have come up with the following list of entities, attributes, and initial business rules . Room is identified by Building ID and Room No data are kept for each semester and also has a Capacity. A room can be either a lab or a classroom. If it is a classroom, it has an addi- tional 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 of equipment is outside of the scope of this project Computer is identified by CType ?D and has attrib- utes Computer Type, Type Description, Disk . A room can be scheduled for one section or no section during-one-time-lat in a given semester of a given year. However, one room can participate in many schedules, ore schedule, oe no schedules; one time slot can participate in many schedules, one schedule, or no schedules; one section can participabe in many sched- ules, one schedule, or no schedules. Hint: Can you associabe this to anything that you have seen before ???. e equipment Tracking A room can have one type of media, several types of one, none, or many computer types. However, a media, or no media Instructors are trained to use types of media. . Capacity, and Processor Speed. Please note: As with Media Type, we are tracking only the type of A lab has one or more 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 computer, not an individual computer. You can think of this as a class of computers (eg. PII 900MH2) Instructor has identifier Emp ID and has attributes Name, Rank, and Office Phone. the system. Course has identifier Course ID and has attributes Course Description and Credits. Courses can have one, nane, or many prerequisites. Courses also have one or more sections. . . Section has identifier Section ID and attribute Enrollment Limit

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 Databases Questions!