A university college decided to create a database to schedule classes. The database business rules are: The database stores information about each teaching Room with the following attributes: BuildingID, RoomID and Capacity. A Room can be one of two types: Lab and Classroom, and cannot be both simultaneously. Each Lab has an attribute LabType (Network, Web Design, Software Development etc.). Each Classroom has an attribute: BoradType (wall-mounted board, mobile whiteboard, glass board, chalkboard etc.) A Room can have none, one or several Media with the following attributes: MediaType (projector, microphone, online media stream, printer, TV etc.). A Lab has computers of one or several types. A Computer has the following attributes: ComputerType (Apple, Windows PC, Linux PC, Laptop, Tablet etc.), Description, MemorySize, ProcessorSpeed. A Teacher has the following attributes: ID, Name, Rank and Email. Each Session has the following attributes: DayOfWeek, StartTime and EndTime. Each course Unit has the following attributes: UnitID, UnitDescription and Credits. A Unit might have none, one or several prerequisites. A Unit can have one or several classes depending on a number of students. A Class has attributes: ClassID and EnrollmentLimit. A Teacher teaches none, one or several Classes of a Unit. A Session is assigned to a Teacher. A Schedule is created for each Year and Semester. A Schedule links Sessions, Rooms and corresponding Classes. A Teacher uses none, one or several types of Media. Your assignment submission consists of two parts. Part 1. Conceptual Model Identify Entities Identify entity supertypes and subtypes and their types, inheritance, and discriminators. Describe relationships between entities and their cardinalities Identify entity primary keys Draw a Conceptual Model Entity-Relationship diagram Part 2. Logical Model Describe data attributes and their types for each entity Redesign the Conceptual model removing many-to-many relationships (if any) Identify primary, composite (if any) and foreign keys (if any) for each entity if there are any one-to-one relationships then describe them Draw a Logical Model diagram.