Home

Our “MiniWorld” Our project proposal is to create a database that tracks political data related to the U.S. Presidential nomination process during 2016.

Tables state: state_id, name, abbrev contest_event: contest_event__id, date candidate: candidate_id, fname, lname, party party: party_id, name contest_type: contest_type_id, name

Relationships State has a 1:N relationship with contest_event (each state can have multiple events where voting or delegates are contest_event has a N:M relationship with candidates contest_candidate_votes: a table between contests and candidates which creates the N:M relationship and has a few of its own attributes. Contest_candidate_vote_id, vote_count, delegates contest_event has an N:1 relationship with contest_type (each contest will be a associated with a single type of event like a caucus or a primary contest_event will have a N:1 relationship with party (each contest is for one party) Candidate has an N:1 relationship with party (each candidate is associated with 1 party, but each party can have N candidates)