MySQL Forums :: Database Design & Data Modelling :: Modeling and Normalizing


Advanced Search

Modeling and Normalizing
Posted by: Phillip Ballew SR. ()
Date: February 17, 2010 05:53PM

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

Options: ReplyQuote


Subject Written By Posted
Modeling and Normalizing Phillip Ballew SR. 02/17/2010 05:53PM
Re: Modeling and Normalizing Phillip Ballew SR. 02/17/2010 06:05PM
Re: Modeling and Normalizing Rick James 02/18/2010 02:29PM
Re: Modeling and Normalizing Phillip Ballew SR. 02/18/2010 03:17PM
Re: Modeling and Normalizing Rick James 02/19/2010 10:15AM
Re: Modeling and Normalizing Phillip Ballew SR. 02/19/2010 10:50AM
Re: Modeling and Normalizing Rick James 02/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.