1 / 8

National Election Database Project

This project proposal outlines the need for a National Election Database for Elections Canada to manage voter registration, ridings, candidates, and political parties in Canadian federal elections. The database must efficiently handle a large amount of data and accurately determine voter ridings based on postal codes. Recommendations include creating a new Entity Relationship Diagram (ERD) without recursive references to simplify the system. Elections Canada should consider hiring the team proposing this project for effective implementation.

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