Instructions for Task 2 Assessment/ .Murks Weight Duration deliverable Tas 2 30 / 10n s. usk 2: Start during Sess' _n 28 and complete after Session 33. E..tit, Relationship viagram (ERD) Deline or explain the foil_' ing termino.ogies in cluss' Refer to yo i database textbook .r nuernet and esearch terms such as "Composite, Simple Single- value, Multivalued and Derived attributes", "Connectivity", "Cardinality "ve_ree , existence dependence and independence", "Weak Entity Optional and Mandatory participation", "Unary elationship Jinary relationship . lernary relationship . "Bridge or linking entities", "Recursive or terative "elationships" 2. Using the CHEN model draw an ERD for the following scenarios. Indicate all Primary keys (-K) and Foreign keys (rK). 2.1. A CAR entity with attributes CAR(Car_vin, Mou_Code, Car_Year, Car_Colour) where Car_ Vin is the PK and Car . Colour may be multiple colours for t. at car. 2.2. One Professor teaches many classes. A class may be taught wy a minimum of one professor and maximum of four ; rofessors, but a Professor may only teach minimum and maxin.um one class. 2... An Employee may have many Dependents. Dependent is optional to Employee, but any Dependent will have one Em., loyee associate with it for medical aid purposes. 2 .4. A Student may enrol for many Subjects or Modules, but a Module or Subject may have many students. A Class is optional to Student and a Student is optional to Class. Simply this many too many relationships and indicate the cardinalities using C. JEN model. 3. Recursive Relationships: 3.1. A Person may play the role of husband or wife, but a husband may only have one wife and vice versa. 3.2. An Employee may act as supervisor over many Employees. 3.3. A Part consists of sub parts. A Part may play the role of Main part or sub part. E.g. A Car consists of parts such as a gearbox and a gearbox can be broken down into sub-gears. The inder indent Institute - Education (Pty) Ltd 2021 Page J _f 2