Part $1$:

A$.$ Description of the mini$-$world $($write$-$up$).$

B$.$ Enhanced entity$-$relationship $($EER$)$ diagram with specified cardinality ratio and participation constraints.

$$ Minimum of five $(5)$ strong entities.

o At least one $(1)$ multivalued attribute.

o At least one $(1)$ composite attribute.

$$ Minimum of one $(1)$ weak entity.

$$ Minimum of three $(3)$ relationships.

o At least one $(1)$ ternary relationship.

$$ Minimum of one $(1)$ specialization.

C$.$ Description of EER to relational data model mapping process $($write$-$up$).$

D$.$ Relational schema diagram in MySQL Workbench Models format $(.$mwb$).$

$$ Relations & attributes.

$$ Constraints.

o Define domains of attributes.

o Specify primary keys.

o Specify foreign keys and referential integrity constraints.

Upload compressed folder that contains:

$-$ Write$-$up of the mini$-$world $($A$).$

$-$ EER diagram $($B$).$

$-$ Write$-$up of the EER$-$to$-$relational mapping $($C$).$

$-$ Relational schema diagram $($D$).$

DUE DATE $$ July $9.$