Question: Draw a class diagram, showing the relevant classes, attributes, operations, and relationships for the following situation: An international school of technology has hired you to

Draw a class diagram, showing the relevant classes, attributes, operations, and relationships for the following situation: An international school of technology has hired you to create a database management system in order to assist in scheduling classes. After several interviews with the president, you have come up with the following list of classes, attributes, and initial business rules:

Room Attributes: buildingID, roomNo, capacity Room is identified by buildingID and roomNo.

A room can be either a lab or a classroom. If it is a classroom, it has an additional attribute called board type.

Media Type Attributes: mTypeID (identifying attribute), typeDescription Please note: We are tracking the type of media (such as a VCR, projector, etc.), not individual pieces of equipment. Tracking of equipment is outside of the scope of this project.
Computer Type Attributes: cTypeID (identifying attribute), typeDescription, diskCapacity, processorSpeed Please note: As with Media Type, we are tracking only the type of computer, not individual computers.
You can think of this as a class of computers (e.g., those based on a 3.0 GHZ Intel Core i7 processor).
Instructor Attributes: empID (identifying attribute), name, rank, officePhone Time Slot Attributes: tsID (identifying attribute), dayofWeek, startTime, endTime Course Attributes: courseID (identifying attribute), courseDescription, credits Courses can have one, none, or many prerequisites.
Courses also have one or more sections. Section has the following attributes: sectionID, enrollmentLimit After some further discussions, you have come up with some additional business rules to help 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 is 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 with anything 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, no, 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 in the system.

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 Database Management Systems Questions!