Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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:
- 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started