Normalization

Normalization is the process of applying a standardized organizational technique to your database and is a goal of database design.  The normal form is the resulting structure of the information in the database.  The goals of normalization are: Eliminate redundant data (storing the same data in multiple tables) Ensure data dependencies make sense (only storing related […]

Read More

Primary Keys

I briefly described primary keys in the Halloween 2015 Trick or Treaters Part 1: MySQL Database post (here).  Primary keys are a big subject in database design so I wanted to delve a little deeper into them. In case you missed the first post, every table in a database should have a primary key column.  This column […]

Read More