HELP with ER Modeling

Develop an 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 schools 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 CourseDescriptions 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 EnrollmentLimit.

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 DayOf Week, 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.