faqts : Computers : Databases : Microsoft SQL Server

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

11 of 15 people (73%) answered Yes
Recently 7 of 10 people (70%) answered Yes

Entry

Database: Relational: Normalization: What is normalization?

Apr 17th, 2008 23:34
Taksh Verdhan, Knud van Eeden, Deepak Bansal, Rachit Bagda,


----------------------------------------------------------------------
--- Knud van Eeden --- 01 January 2004 - 07:34 pm --------------------
Database: Relational: Normalization: What is normalization?
---
Normalization is the process of separating repeated information into
separate tables.
---
---
In the simplest case you have one table with all your information in
it.
---
But this will soon lead to duplication of data, so making it
possibly more error prone and involved to change the same data
in different places.
---
So soon you might start to separate that information into
seperate tables.
---
So you have in general a tree hierarchy of tables.
---
For example: a tree of employee tables
                            employee
                                |
            +-------------------+----------+
            |                              |
        jobhistory                       offspring
            |
       salaryhistory
---
For example: a tree of customer and order tables
        Customers
            |
          Orders
            |
       OrderDetails
---
To know which table corresponds with the others, you create links
between the different tables. Here this links are called keys.
A simple way of doing this is to use just numbers
(similar to pointers and indirection).
So for example, you might add an extra column to a table, with unique
numbers.
In the other tables, you can then use this unique number to reference
to that row position in the table.
---
Now here normalization is a systematic method to split this information
(especially the unique keys) into its subtables through this tree
hierarchy.
---
---
Internet: see also:
---
Database: Relational: Normalization: Simple: How to do normalization?
http://www.faqts.com/knowledge_base/view.phtml/aid/27720/fid/147
---
Book: Wrox: Beginning ASP.NET 1.1 with VB .NET 2003
http://www.wrox.com/books/sample-chapters/samplechapter_0764557076.pdf
http://www.zecco.in/
http://www.newsvine.in/
http://www.freecodereference.com
http://www.autoaccessoryshipping.com
http://www.autopartsdirectory.info
http://www.cssbunch.com
http://www.freesharewarez.info
http://www.freewebsitesubmission.info
http://www.gamecheatsdome.com
http://www.gamesgeeks.com
http://www.metaldetectorprices.info
http://www.onlinenewsletterarticles.com
http://www.reversecellphonedirectory7.info
http://www.webcodirectory.com
http://www.webdesignsmagazine.com
http://www.wordpressthemesbox.com
http://www.templateremix.com
http://www.websitedevelopmentcompany7.com/
http://www.carautoaccessories7.com/
http://www.beautysupply7.com/
http://www.templatemixture.com/
http://www.rajasthantour7.com/
http://setmax.co.cc/
http://www.seoservicesinc.com/
http://automotivedir.mylinea.com/
http://allwebdirectory.mylinea.com/
http://healthdir.mylinea.com/
http://www.autoaccessoryshipping.com/auto-accessories/
http://www.carautoaccessories7.com/car-accessories/
http://www.templateremix.com/free-powerpoint-templates/
----------------------------------------------------------------------