Modeling and Normalizing
I've set out to learn to model and normalize databases. All the tutorials read and vids I watched were based on coffee shops or bookstores. As if those are the only two entities that need databases. While helpful they are not very challenging so I decided to model a database after an election. I would appreciate if someone could point out the strengths and weaknesses in this normalized model.
PK=Primary Key
FK=Foreign Key
This is the base from where I broke out the tables
STATE STATE ABBREVIATION DISTRICTCAND ID# INCUMBENT INDICATOR (I) CANDIDATE NAME (First) Candidate Name (Last) CANDIDATE NAME TOTAL VOTES PARTY PRIMARY PRIMARYRUNOFF GENERAL GENARALRUNOFF
Subject
Written By
Posted
Modeling and Normalizing
February 17, 2010 05:53PM
February 17, 2010 06:05PM
February 18, 2010 02:29PM
February 18, 2010 03:17PM
February 19, 2010 10:15AM
February 19, 2010 10:50AM
February 20, 2010 11:54AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.