Re: Modeling and Normalizing

[Phillip Ballew SR.]

Here is the rest of my post. I am used to using tabs and other keys and posted before I was finished. Sorry 'bout that
Here is the tables I've modeled out of the headings from the post above.
tbl_Candidate
PK=cand_ID cand_Name_Title cand_Name_First cand_Name_Last cand_Name_MI cand_Name_Full cand_Name_Salutation

tbl_Party
PK(auto) FK=cand_ID party_ID party_Name

tbl_Incumbent
PK(auto) FK=cand_ID inc_Indicator

tbl_State_Dist
PK(auto) FK=cand_ID state_Name state_ID state_Dist(datatype issue here:district indecated by number if HOR election and S if Senate)

tbl_Primary_Elect
PK(auto) FK=cand_ID count_Primary_votes count_Runnoff_Primary_Votes

tbl_General_Elect
PK(auto) FK=cand_ID count_GE_Votes count_GE_Runnoff_Votes

Thanks in advance for giving this a look