100 likes | 207 Vues
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.
E N D
National Election Database Project By Andy Chen, Mina Fard, Titus Gregory, Jamila Lau
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
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
Province • Riding • Riding_Office • Postal_Code • Polling_Place • Voter • Candidate • Party Entities
Entities should NOT have recursive referencing • Keep it simple • Elections Canada should hire us Recommendations