what is narmalization

Answer Posted / mithun

Normalization is a process of organizing data in databased, which includes creating tables and establishing relationship between them.
1st Normal Form - Do not use multiple fields to store same data.
Eliminate repeating groups in individual tables.
Create a separate table for each set of related data.
Identify each set of related data with a primary key.

2nd Normal Form - Records should not depend on anything other than a table's primary key.
Create separate tables for sets of values that apply to multiple records.
Relate these tables with a foreign key.

3rd Normal Form - Eliminate fields that do not depend on the key.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What permissions do asp.net applications posses by default?

648


benefits of migration from asp to asp.net hi frnds, i have to give presentation to a client about how useful would be migrating their project from asp to asp.net .plz give me some points which i should incorporate in my ppt thanks

1674


What is advantage of asp.net?

551


What is custom events? How to create it?

627


When was asp.net released?

577






Can we use MSSql as backend in asp.net...if yes then How.?

585


What is the difference between Classic ASP and ASP.Net?

537


Which library is used by the testers and developers to develop automated tests and create testing tools?

548


Explain the difference between authentication and authorization.

600


What's the ASP.Net Application life cycle?

566


What parameters can you pass in the url of the api?

664


What is base class of button control in .net?

531


What is sql data source control in asp.net?

573


What is http only cookie?

506


what is the difference between response.write() and response.output.write()?

702