National Election Database Project

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