Draw an ERD for the following situation 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 BuildingID and RoomNo and also has a Capacity A room can be either a lab or classroom If it is a classroom, it has an additional attribute called BoardType Media is identified by Mtypeid and has attributes of MediaType and TypeDescription 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 Ctypeid and has attributes ComputerType, TypeDescription, DiskCapacity, and ProcessorSpeed Please note As with MediaType, we are tracking the type of computer, not an individual computer You can think of this as a class of computers (e g 3 2 Ghz Dual Core AMD) Instructor is identified by EmpID and has attributes Name, Rank, and OfficePhone Timeslot has identifier TSIS and has attributes DayofWeek, StartTime, and EndTim Course had identifier CourseID and has attributes CourseDescription and Credits Courses can have one, none, or many prerequisites Courses also have one or more sections Section has identifier SectionID and attribute EnrollmentLimit An instructor teaches one, none, or many sections of a course in a given semester An instructor specifies preferred timeslots 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 timeslot in a given semester of a given year However, one room can participate in many schedules, one schedule, or no schedules one timeslot can participate in many schedules, one schedule, or no schedules one section can participate in many schedules, one schedule, or no schedules 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

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 21, 2024

Draw an ERD for the following situation: An international school of technology has hired you to create a database management system to assist in scheduling

Draw an ERD for the following situation: 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:
1. Room is identified by BuildingID and RoomNo and also has a Capacity. A room can be either a lab or classroom. If it is a classroom, it has an additional attribute called BoardType.
2. Media is identified by Mtypeid and has attributes of MediaType and TypeDescription. 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.
3. Computer is identified by Ctypeid and has attributes ComputerType, TypeDescription, DiskCapacity, and ProcessorSpeed. Please note: As with MediaType, we are tracking the type of computer, not an individual computer. You can think of this as a class of computers (e.g. 3.2 Ghz Dual-Core AMD).
4. Instructor is identified by EmpID and has attributes Name, Rank, and OfficePhone.
5. Timeslot has identifier TSIS and has attributes DayofWeek, StartTime, and EndTim
6. Course had identifier CourseID and has attributes CourseDescription and Credits. Courses can have one, none, or many prerequisites. Courses also have one or more sections.
7. Section has identifier SectionID and attribute EnrollmentLimit.
8. An instructor teaches one, none, or many sections of a course in a given semester.
9. An instructor specifies preferred timeslots.
10. Scheduling data are kept for each semester, uniquely identified by semester and year.
11. A room can be scheduled for one section or no section during one timeslot in a given semester of a given year. However, one room can participate in many schedules, one schedule, or no schedules; one timeslot can participate in many schedules, one schedule, or no schedules; one section can participate in many schedules, one schedule, or no schedules.
12. A room can have one type of media, several types of media, or no media.
13. Instructors are trained to use one, none, or many types of media.
14. A lab has one or more computer types. However, a classroom does not have any computers.
15. A room cannot be both a classroom and a lab. There also are no other room types to be incorporated into the system