Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Understanding Oracle APEX 5 Application Development

Authors: Edward Sciore

2nd Edition

1484209893, 9781484209899