Normalization and types of normalization, DOT NET Programming

Assignment Help:

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


Related Discussions:- Normalization and types of normalization

Android to pc communications via bluetooth, Project Description: I am lo...

Project Description: I am looking an app that mimics this app presently available here [justremotephone.com]. It has a nice set of features but also lacks a lot when it comes to

Explain the concept of constructor, Explain the concept of constructor? ...

Explain the concept of constructor? Constructor is a special method of a class, which is called automatically when the instance of a class is formed. It is created with the sam

This is a project specifically made for shirohime, This is a project specif...

This is a project specifically made for shirohime. Skills required: .NET, Fashion Design, Virtual Assistant

Namespace-difference between namespace & assembly, NameSpace Namespace co...

NameSpace Namespace consists of 2  main basic functionality :- NameSpace Logically types group , ex. System.Web.UI logically groups our UI related features. In Object O

I want c# routines for website back end, I want C# routines for website bac...

I want C# routines for website back end Project Description: We want some routines written in C# (.NET) to: * Parse some RESTful APIs to transform and push data to RabbitM

I need a pos like openbravo, I need a POS like openbravo Project Descrip...

I need a POS like openbravo Project Description: i want a POS like openbravo in .net with sql azure and c#. Must be designed also for touch screen.  Web platform Also m

Metrics followed in project management, What are the metrics followed in pr...

What are the metrics followed in project management? The most metric sets deal with a variation of these attributes and are chosen to help the project managers gain insight int

Multi-tasking, What is Multi-tasking? It is a feature of the modern ope...

What is Multi-tasking? It is a feature of the modern operating system with which we can run multiple programs at the same time for example Word, Excel etc.

Xml validating reader class, What does Xml Validating Reader class do? ...

What does Xml Validating Reader class do? The XmlTextReader class does not validate the contents of an XML source against a schema. The correctness of the XML documents can be

Six sigma implementation, What is Six Sigma implementation? To attain S...

What is Six Sigma implementation? To attain Six Sigma is a team effort and cannot be attained individually. Driving the Six Sigma itself in an organization is vast project as i

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd