ER Diagram $90$ points

$1.$ Identify $4$ different entity types

a$.$ Identify any additional entities types you think are important.

$2.$ List the $3$ relationships amoung $4$ entity types including cardinality ratios $3$ of them

a$.$ Identify any additional relationships you think are important including cardinality ratios. $3$ of them

$3.$ Identify the correct attributes for each entity type $($including primary key$).$ Make sure all entity types have IDs as primary key. $(2$ pts each primary key and $1$ pts for each non key attributes, max $20$ pts

a$)$ there is no downside to having more attributes however max points avalible is $20.$

$4.$ Make sure your diagram follows the normalization rules $($no mult$-$valued attributes, no composite attributes $)(6$pts$)$

$5.$ Make sure you converted many to many relationships to composite entity types $(5$pts$)$

part$2.$ Relational schema$(20$points$)$

Once you finish your ERD then convert your ERD into relational schema use both mapped and stable methods $($create two relational schema one with mapped and one with stable$).$ Make sure your design is enforcing one to many relationships $(10$points$).$