Question: Q2. ER Model Develop n ERD for the following case: A school of technology has hired you to create a database to assist in scheduling

 Q2. ER Model Develop n ERD for the following case: A

Q2. ER Model Develop n ERD for the following case: A school of technology has hired you to create a database to assist in scheduling classes. After several interviews with the users, you have come up with the following data requirements and business rules. Based on them, create an ER Model for the school's database. BUILDING has many rooms. Each room is located in a building. The attributes for BUILDING are BuildingNo, BuildingName and Location. ROOM is always identified in association with BUILDING (BuildingNo). The attributes for ROOM include RoomNo and Capacity. There are two types of room. A room can be either LAB or CLASSROOM. If it is a lab, it has an additional attribute called LabHours. If it is a classroom, it has an additional attribute called ZoomEnabled? COURSE has identifier CourseID and has attributes Course Descriptions and Credits. A course may (or may not) have more than one section. Each section is always identified in association with COURSE (CourseID). SECTION has attributes SectionNo and Enrollment Limit. INSTRUCTOR has identifier EmpID and has attributes FirstName, LastName, Rank, and Office Phone. Each instructor teaches more than one sections. Each section is taught by one instructor. TIMESLOT has identifier TSIS and has attributes DayOfWeek, StartTime and EndTime. An instructor is assigned to more than one time slot (i.e., many) Each time slot is assigned more than one instructor (i.e., many). Scheduling data for each instructor are kept for each semester. After some further discussions, you have come up with additional business rules. A classroom is scheduled for one time slot at any given time. However, each time slot involves more than one classroom. A course may or may not) have more than one (i.e., many) prerequisites

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 Databases Questions!