Question of the Day One

For the next week, I will be on vacation and then when I return I have a big project that needs my full attention.  However, being dedicated to blogging daily I thought it might be an interesting little journey for remainder of the month of August would be to post a question of the day with the answer.  I am not trying to steal any thunder from the SQL Server Central QotD where you test your skills for points against the world.  This will be simply an exercise in SQL learning.

So let us begin with day one…

What is normalization?

In simplest terms it is the organizing of data in a relational database to reduce the duplication of data.  In order to accomplish this we would split one large record entity into smaller tables that are linked by their relationship.  For example, if you had a simple database that stored orders of widgets.  You would have a table that contained customer data and a table for order information.  You would not want to store customer contact information in each record of the order table.  There would be one customer record and then possibly multiple order records linked by a customer ID field to ensure a relationship and preventing you from redundant customer contact information in each order record.  However, to the user who receives an invoice that contains his order and his contact information the data seems to be one contiguous unit.

Just in case you did not know, this theory was pioneered by E. F. Codd in 1970.  Enjoy!

Advertisements

About SQLGator

Florida Gator and Microsoft Data Platform MVP, Star Wars fanatic and is there anything else...oh yeah PS4! I am a geek and SQL Server DBA who dabbles with VMWare, there are other technologies greater than these? Not so fast my friend! I also love to travel to new and exotic places.

Posted on August 3, 2012, in SQL Schoolhouse and tagged . Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: