Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Forum
What is Normalization?
August 06, 2008
Please help me understand normalization.
Posted Date: August 06, 2008 Points: 5
By definition Normalization is a technique for designing relational database tables to minimize duplication of information.
Posted Date: August 26, 2008 Points: 5
It also can said like filtering the repeated datas
Posted Date: December 13, 2009 Points: 5
We use normalization to less the number of duplication in our table. It helps in reducing redundancy.
Posted Date: January 29, 2010 Points: 5
The process of removing redundant data by creating relations between tables is known as Normalization. Normalization process uses formal methods to design the database in interrelated tables.
It is possible to start creating the database at this point. It's just a question of creating a new table for every entity identified in the diagram. We'll be using MS-Access to do that shortly. But how do you code the relationships?
There is a formal process to do that in database modeling. It's called normalization. It means applying a set of rules to the data so that you group the attributes in such a way that the relationships work. It's not really that complicated but it is a formula approach. If you prefer to use that approach, get any good book on databases, look-up "normalization" and follow the steps.
We'll do normalization using the intuitive approach - work with the data until it "feels" OK. This could also be called prototyping - create a working model of the database that is close to what you want and keep improving it until it works perfectly, then put it into production.
However, whatever the approach taken, there are some basic rules that have to be adhered to. The rules apply to any relational database and cannot be broken. They can't even be stretched. Think of them as the Prime directives. The rules are:
1. Every table must have a primary key - an attribute or combination of attributes that uniquely identifies every occurence in the table.
2. The primary key can never contain an empty or Null value. That makes sense - if you had 2 that were empty, they wouldn't be unique anymore.
3. Every attribute of every occurence in the table can contain only one value. Think of the Employee table as a grid. Every occurence, or line, represents one employee and every column is an attribute. So, every employee can only have one ID and one First-name and one Last-name, and so on.
Please Check my answer if you help....
Posted Date: November 23, 2010 Points: 5
Normalization: is a process of organizing data and minimizing redundancy of database.
Posted Date: July 20, 2011 Points: 20
Check this link
Regards, Lakshmi Naraayanan.S
Posted Date: August 24, 2012 Points: 20
Just Go through this....
To post reply
Related Questions Related Questions
Latest Forum Questions From The Same Category
Help to get SQL output
how to restore my sql database from my hosting provider?
SQL query to update date range
Add allowance to employee table is wrong or true according to my case
how to remove trailing zeroes in a decimal in sql server
Required Union All Result in two different column
Sql Multiple table data retrival
Table Translation records
How select huge Data from sql without take long time?
Passing using parameter in store procedure get the top3 record from the table
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more
Quick Links For Forum Categories:
Hall of Fame
Terms of Service
Tell A Friend