March 01, 1999 07:01 PM

SQL by Design: Why You Need Database Normalization

Rating: (0)
SQL Server Magazine
InstantDoc ID #4887
Use this technique to improve system performance and accuracy
Database normalization, or data normalization, is a technique to organize the contents of the tables for transactional databases and data warehouses. Normalization is part of successful database design; without normalization, database systems can be inaccurate, slow, and inefficient, and they might not produce the data you expect.

Fol...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

Good article about a basic concept. Please, do rate your articles so we can choose to skip the basic ones.

Take Care!

Marcos6/25/2009 1:26:23 PM


nbnm

Anonymous User 7/28/2005 12:03:07 AM


thanks...i can finish my assignment...thanks for the useful info....really....its availablity makes me really interesting in SQL Server....

Anonymous User 7/25/2005 5:53:42 AM


Very useful information was given. This will help many people in the world.



Anonymous User 5/4/2005 10:56:03 PM


i am so gland when i get it.i make my assingment from this so it is so help full from me. thanks who make that notes.

ABDUL REHMAN 3/25/2004 1:32:36 PM


Great Article! I would recommend Michelle present an article in the SQL Server Magazine each month about a different Database Design. To many people use the Customer/Orders Database Design as an example.

Steve3/3/2004 5:19:03 PM


It amazes me that after all this data normalization, city and state remain in the address table, when they're dependent on the zip code.

Wil Cooley 12/8/2002 12:16:55 AM


I like the meat of the article. The author has something to say. For me, I'm always looking at defining normalization in it's simplest terms to myself and others in the business world. What did detract from the article was that 1NF, 2NF, and 3NF figures and screens did not display primary key and the text was ambiguous as to the primary key for many of the illustrations. Primary keys are a pivotal point of normalization. Confuse the reader here and you've lost them for the rest of the article. Consider updating this article for clarity. It has good content.

Mark Solomon 11/6/2001 7:48:23 AM


You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS