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

Difference between factory and abstract factory patterns, What is the diffe...

What is the difference between Factory and Abstract Factory Patterns? The main basic difference between factory and Abstract factory is factory method uses the  inheritance to

Need experienced dot net and php programmers, Need Experienced dot Net and ...

Need Experienced dot Net and PHP Programmers Project Description: Need Experienced dot Net., JSP, PHP, Java Programmers Skilled professional and command in Programming eit

What is common type system, What is "Common Type System" (CTS)?  CTS de...

What is "Common Type System" (CTS)?  CTS define all of the basic types that can be used  in the .NET Framework and the operations performed on those type. All this time we have

C# api to grab option price from cboe web site, C# API to grab option price...

C# API to grab option price from CBOE web site Project Description: On the web page below, user will download option prices of Stock or Index. For example, if you put "VXX" i

Various ways of authentication techniques in asp.net, What are the various ...

What are the various ways of authentication techniques in ASP.NET? The Selection of  an authentication provider is as simple as making an entry in  the web.config file of  the

What is the difference between sub-procedure and function, What is the main...

What is the main difference between sub-procedure and function? The sub-procedure is a block of multiple visual basic statements within Sub and End Sub statements. It is used t

How i increment my new file if the file is already present, I have the pro...

I have the project that takes screen shots and saves in the specific folder.(eg.Screen0001) but the problem is that if i close application and run it again then it replace the exis

What are queues and stacks, What are queues and stacks? Stacks refer to...

What are queues and stacks? Stacks refer to a list in which all items are accessed and processed on the Last-In-First-Out (LIFO) basis. In a stack, elements are inserted (push

What is the difference between vb.net and c#?, Difference between VB.NET an...

Difference between VB.NET and C# This is the main debatable issue in .NET community and everyone treat their languages like religion. It is a very important matter which lan

We need of an expert web developer, Web Developer Project Description: ...

Web Developer Project Description: We need of an expert web developer for long term association, please apply with models if you have the subsequent skills: ASP.NET MVC 3

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