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

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

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