Answered You can hire a professional tutor to get the answer.

QUESTION

Can you assist me with this Develop an EER model for the following situation usingthe traditional EER notation, the Visio notation, or thesubtypes

Can you assist me with this 

Develop an EER model for the following situation usingthe traditional EER notation, the Visio notation, or thesubtypes inside supertypes notation, as specified by yourinstructor:An international school of technology has hired you tocreate a database management system to assist in schedulingclasses. After several interviews with the president,you have come up with the following list ofentities, attributes, and initial business rules:• Room is identified by Building ID and Room Noand also has a Capacity. A room can be either a labor a classroom. If it is a classroom, it has an additionalattribute called Board Type.• Media is identified by MType ID and has attributesof Media Type and Type Description. Note: Here weare tracking type of media (such as a VCR, projector,etc.), not the individual piece of equipment. Trackingof equipment is outside of the scope of this project.• Computer is identified by CType ID and has attributesComputer Type, Type Description, DiskCapacity, and Processor Speed. Please note: As withMedia Type, we are tracking only the type ofcomputer, not an individual computer. You can thinkof this as a class of computers (e.g., PIII 900MHZ).• Instructor has identifier Emp ID and has attributesName, Rank, and Office Phone.• Timeslot has identifier TSIS and has attributes DayOf Week, Start Time, and End Time.• Course has identifier Course ID and has attributesCourse Description and Credits. Courses can haveone, none, or many prerequisites. Courses also haveone or more sections.• Section has identifier Section ID and attributeEnrollment Limit.After some further discussions, you have come up withsome additional business rules to help you create theinitial design:• An instructor teaches one, none, or many sections ofa 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 sectionduring one time slot in a given semester of a givenyear. However, one room can participate in manyschedules, one schedule, or no schedules; one time slotcan participate in many schedules, one schedule, or noschedules; one section can participate in many schedules,one schedule, or no schedules. Hint: Can youassociate this to anything that you have seen before?• A room can have one type of media, several types ofmedia, or no media.• Instructors are trained to use one, none, or manytypes of media.• A lab has one or more computer types. However, aclassroom does not have any computers.• A room cannot be both a classroom and a lab. Therealso are no other room types to be incorporated intothe system.

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question