Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.

QUESTION

An international school of technology has hired you to create a database management system to assist in scheduling classes.

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. a. Room is identified by Building_ID and Room_No and also has a Capacity. A room can be either a lab or a classroom. If it is a classroom, it has an additional attribute called board_type.b. Media is identified by Mtypeid and has attributes of MediaType and Type Description. Please note: Here we are tracking type of media (such as VCR, projector, etc.), not the individual piece of equipment. Tracking of equipment is outside the scope of this project.c. Computer is identified by Ctypeid and has attributes ComputerType, TypeDescription, DiskCapacity, and ProcessorSpeed. Please note: As with Media Type, we are tracking only the type of computer, not an individual computer. You can think of this as a class of computers (e.g. Intel Centrino 3.0 GHz).d. Instructor has been identified by Emp_ID and has attributes Name, Rank, and Office_Phone.e. Timeslot has identifier TSIS and has attributes DayOfWeek, StartTime, and EndTime. Course has identifier CourseID and has attributes CourseDescription and Credits. Courses can have one, none or many prerequisites. Courses also have one or more sections.f. Section has identifier SectionID and attribute EnrolmentLimit.

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