$(25$ points total$)$

Given the E$-$R diagram $($ERD$)$ shown below, provide answers for $($a$)-($c$).$

$($a$)(7$ points$)$ Add attributes that are required by the ER model $($and some optional

attributes$)$

$($b$)(7$ points$)$ Write the explicit cardinalities $($i$.$e$.,$ one or many$-$to$-$many, partial and

total participation$)$ indicated by the notations used in the ERD.

$($c$)(6$ points$)$ List $5$ of the business rules reflected by this ERD.

$($d$)(5$ points$)$ If we assume that DEPENDENT is a weak entity, describe the

composition of its primary key.