I am trying to create a database that can store information relating to the past 5 PRESIDENTIAL elections (including the most recent one) for the states of California, Texas, Ohio, New York, Iowa, and New Hampshire.
The information I have to store are the first and last names of the major party candidates (both Presidential and Vice Presidential), their popular and electoral votes in each state, and then the total electoral and popular votes of each state.
By the end, I'm going to have to generate queries and reports on who the winners were, who the losers were, and who ran multiple times and for which offices.
MY PROBLEM IS THAT I DON'T KNOW HOW TO GO ABOUT BREAKING THE INFORMATION INTO SEPARATE TABLES. E.G. HOW TO SEPARATE THE INFORMATION TO ITS MOST BASIC. I HAVE NO IDEA WHAT THE PRIMARY KEYS FOR EACH TABLE SHOULD BE, LET ALONE HOW MANY TABLES I SHOULD HAVE AND DIVIDED HOW.
IF SOMEONE COULD HELP ME CONCEPTUALIZE ALL THAT, I CAN PULL OFF THE REST ON MY OWN.
Any help would be appreciated more than you could possibly imagine. Please, please help.
The information I have to store are the first and last names of the major party candidates (both Presidential and Vice Presidential), their popular and electoral votes in each state, and then the total electoral and popular votes of each state.
By the end, I'm going to have to generate queries and reports on who the winners were, who the losers were, and who ran multiple times and for which offices.
MY PROBLEM IS THAT I DON'T KNOW HOW TO GO ABOUT BREAKING THE INFORMATION INTO SEPARATE TABLES. E.G. HOW TO SEPARATE THE INFORMATION TO ITS MOST BASIC. I HAVE NO IDEA WHAT THE PRIMARY KEYS FOR EACH TABLE SHOULD BE, LET ALONE HOW MANY TABLES I SHOULD HAVE AND DIVIDED HOW.
IF SOMEONE COULD HELP ME CONCEPTUALIZE ALL THAT, I CAN PULL OFF THE REST ON MY OWN.
Any help would be appreciated more than you could possibly imagine. Please, please help.