Answered step by step
Verified Expert Solution
Link Copied!

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. (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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Information Modeling And Relational Databases

Authors: Terry Halpin, Tony Morgan

2nd Edition

0123735688, 978-0123735683

More Books

Students also viewed these Databases questions

Question

What is Accounting?

Answered: 1 week ago

Question

Define organisation chart

Answered: 1 week ago

Question

What are the advantages of planning ?

Answered: 1 week ago

Question

Presentations Approaches to Conveying Information

Answered: 1 week ago