1 / 8

National Election Database Project

National Election Database Project. By Andy Chen, Mina Fard , Titus Gregory, Jamila Lau. Elections Canada is responsible for administering Canadian federal elections

mika
Télécharger la présentation

National Election Database Project

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. National Election Database Project By Andy Chen, Mina Fard, Titus Gregory, Jamila Lau

  2. Elections Canada is responsible for administering Canadian federal elections • Canada is divided into geographical districts called ridings. Canadian citizens who live in a riding elect one person to represent them in Parliament. • Elections Canada needs to manage large amounts of data: • Voters • Ridings • Candidates • Political Parties Problem

  3. The database must manage the voter registration system. • The database must be able to determine a voter’s riding based on the voter’s postal code. • The database must manage ridings, candidates, and political parties. • On election day, the database must receive vote totals, calculate the winner of each riding, and determine which political party won the election. Requirements

  4. Province • Riding • Riding_Office • Postal_Code • Polling_Place • Voter • Candidate • Party Entities

  5. Old ER Diagram

  6. Problem

  7. New ER Diagram

  8. Entities should NOT have recursive referencing • Keep it simple • Elections Canada should hire us  Recommendations

More Related