Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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. points
For political races, we keep track of position name and year eg
Tampa mayor in 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started