Normalization and types of normalization, DOT NET Programming

What is normalization & what are the types of normalization?

Normalization is a set of rules that have been established to aid in the design of tables that are meant to be connected through relationships. This set of rules is termed as Normalization.

The advantages of normalizing your database will include following points:

  • Avoiding of the repetitive entries
  • Reducing the required storage space
  • Preventing the need to restructure existing tables to accommodate the new data.
  • To increased the flexibility of queries, speed and sorts, and summaries.

The three normal forms are illustrated below:-

1)First Normal Form :

For a table to be in the first normal form, the data must be broken up into the smallest possible units .In addition to breaking the data  into the smallest meaningful values, the tables in first normal form should not contain any repetitions groups of fields.

409_first normal form.png

Figure :- Repeating groups example

For this in the above example city1 & city2 are repeating.In order to show this table to be in First normal form you have to change the table structure as follows.Also note that the Customer Name is now broken down to first name and the last name (First normal form data must be broken down to smallest unit).

14_second normal form.png

2)Second Normal form:

The second normal form states that every field in a multiple field, primary keytable should be directly related to the whole primary key. Or in the other words, each non-key field must be a fact of about all the fields in the primary key. In the  table above of customer, the city is not linked to any primary field.

1809_second normal form1.png

Figure:- Normalized customer table.

2108_second normal form2.png

Figure :- City is now shifted to a different master table.

3)Third normal form:

The non-key field should not depend on other Non-key field. The field "Total" is dependent on the "Unit price" and the "qty".

930_thid normal form.png

Figure :- Fill third normal form

Posted Date: 9/24/2012 4:38:20 AM | Location : United States







Related Discussions:- Normalization and types of normalization, Assignment Help, Ask Question on Normalization and types of normalization, Get Answer, Expert's Help, Normalization and types of normalization Discussions

Write discussion on Normalization and types of normalization
Your posts are moderated
Related Questions
ASP Developer- We are needed to hire an ASP developer for some urgent work. He needs to add a new page to an already prepared site; the page is already completed in HTML. He jus

Project Description: We require.NET ( C#.Net or VB.Net ) application to send whatsapp message : - The application could be connected to SQL server database to fetch the conta

Advertizing Project Description: I am preparing a MLM business. I can need direct mailing and coupon books as a product in my website. Skills required are .NET, C# Program

What is pareto principle? The Pareto principle also paraphrased as 80/20 principle is simple effective problem tackling way in the management. It says that 20% of your problems

Requirements: 1.  Complete the following two exercises by developing working csharp projects. 2.  Write a report to explain csharp code written in the projects. 3.  Submi

I need C# Programmer Project Description: To help in the production of a C# module to provide a web service. We are based in Littlehampton, West Sussex. Skills required ar

The only difference is that I need the most new version. Things have changed a little since then (the key has), so I need this done freshly. I require the result in C#, sourceco

Describe the three levels of data abstraction? The are three levels of abstraction: Physical level: The lowest level of abstraction explains how data are stored.  Logical

What are indexes? The Indexes in the SQL Server are similar to the indexes in books. They help SQL Server to retrieve the data quickly.These are classified into clustered and n

We need customization of features in Silverlight component plugin I have bought a Silverlight charting component for stock markets. Source code is available in C# besides is wel