Question: i A Class has attributes: Clasle and EnrollmentLimit. o A Teacher teaches none, one or several Classes ofa Unit. 0 A Session is assigned to


i A Class has attributes: Clasle and EnrollmentLimit. o A Teacher teaches none, one or several Classes ofa Unit. 0 A Session is assigned to a Teacher. 0 A Schedule is created for each Year and Semester. A Schedule links Sessions, Rooms and corresponding Classes. 0 A Teacher uses none, one or several types of Media. Your assignment submission consists of two parts. Part 1. Conceptual Model 0 Identify Entities 0 Identify entity supertypes and subtypes and their types, inheritance, and discriminators. 0 Describe relationships between entities and their cardinalities 0 Identify entity primary keys 0 Draw a Conceptual Model Entity-Relationship diagram Part 2. Logical Model 0 Describe data attributes and their types for each entity 0 Redesign the Conceptual model removing many-to-many relationships {if any] 0 Identify primary, composite (if any) and foreign keys (if any) for each entity 0 if there are any one-to-one relationships then describe them 0 Draw a Logical Model diagram
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
