$1.$ Sketch an EER diagram to represent a data model for Florida voting data

below. Make a note of any constraints that you cannot easily represent in

your model. $(5$ points$)$

$$ For political races, we keep track of position name and year $($e$.$g$.,$

Tampa mayor in $2019)$ and an optional associated district code.

There may be multiple races in the same year and multiple races

for the same position in different years, but only one race for the

same position in the same year.

$$ Citizens have a unique Voter Registration Number $($used for identifi$-$

cation$),$ name, and age, and $($possibly$)$ party affiliation. Candidates

may run in several races, though they generally only run in one race

per year.

$$ Candidates are citizens who are running for office in a race. In addi$-$

tion to their citizen information, we keep a short bio for each candi$-$

date.

$$ Citizens may own one or more addresses, though they designate one

as their primary residence. Addresses are identified by an extended

zip code, though they also have a latitude, longitude, street address,

$($optional$)$ apartment number, city, and state. Addresses are associ$-$

ated with any number of district codes.

$$ Citizens may cast votes in all of the races associated with districts

of their primary residence. We will imagine that citizens may cast

a vote for at most one candidate in these races, and we keep track

of who they voted for and when their vote was cast. $($Races and the

records being kept are much more complicated in practice, but this

is a reasonable simplification.$)$

$2.$ Convert your EER diagram in the previous question into a collection of

tables with constraints. $(5$ points$)$