What is database normalization?

Answers were Sorted based on User's Feedback



What is database normalization?..

Answer / koti-khammam

It is the process of removing redundancy(repeated data) by
splitting the tables into smaller tables.

Is This Answer Correct ?    37 Yes 3 No

What is database normalization?..

Answer / anirudh

Normalization is breaking the database into different
tables and defining a relationship between them.
Objective is to isolate the data so that additions and
deletions can be made in one table and propagated to other
tables through relationships.

Is This Answer Correct ?    20 Yes 1 No

What is database normalization?..

Answer / shruti

Normalization is the process of breaking tables of a
database into smaller tables and defining relations between
them to make them more flexible, efficient and to remove the
modification anamolies from the database.

Is This Answer Correct ?    15 Yes 1 No

What is database normalization?..

Answer / kranthi

Normalization is the process of structuring relational
database schema such that most ambiguity is removed. The
stages of normalization are referred to as normal forms and
progress from the least restrictive (First Normal Form)
through the most restrictive (Fifth Normal Form).

Is This Answer Correct ?    8 Yes 1 No

What is database normalization?..

Answer / dr. tawfik khattab

Normalization is the process of efficiently organizing data
in a database.
The goals of the normalization process asfollows:
1- Eliminating redundant data
2- Ensuring data total dependence on the Pk or on the
Composite PK

Is This Answer Correct ?    6 Yes 1 No

What is database normalization?..

Answer / padmapriya

Noramalization is process of breaking the information into
well defined tables which should follow some rules. There
are 5 Normal forms available. Each one having a separate
rule.
1NF-Avoid redundant data
2NF-All coulms except primary key column should be related
to the primary key column
3NF,4NF and 5NF - I'dont remember , if any one knows please
reply

Is This Answer Correct ?    3 Yes 2 No

What is database normalization?..

Answer / maskfriend

Normalize the data from the detabase.It reduces by the
normalisation rule like(there are 4 normalization rule and
BCNF)

Is This Answer Correct ?    10 Yes 11 No

Post New Answer

More SQL Server Interview Questions

What is after dml trigger?

0 Answers  


how to overcome kernel isssues

0 Answers   Fortune,


A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

0 Answers  


how to do partition in sqlserver

0 Answers   TCS,


What is database replicaion? What are the different types of replication you can set up in SQL Server?

3 Answers  






I am learning Testing, so i want to learn SQL also because SQL is important for Testing. I want to know which is best Institute in Ameerpet or SR Nagar or any other place in Hyd? Please help me.

7 Answers  


What are locks in sql?

0 Answers  


How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

0 Answers  


When I delete any data from a table, does the sql server reduce the size of that table?

0 Answers  


What are the encryption mechanisms in sql server?

0 Answers  


What is deploy, process and build? : sql server analysis services, ssas

0 Answers  


Which system table contains information on constraints on all the tables created?

2 Answers  


Categories