What is normalization?

Answers were Sorted based on User's Feedback



What is normalization?..

Answer / anjana

Normalization is the process of efficiently organizing data
in a database. There are two goals of the normalization
process: eliminating redundant data (for example, storing
the same data in more than one table) and ensuring data
dependencies make sense (only storing related data in a
table). Both of these are worthy goals as they reduce the
amount of space a database consumes and ensure that data is
logically stored.

Is This Answer Correct ?    5 Yes 0 No

What is normalization?..

Answer / ghous

well normalization is a broader concept and couldbe called
the back bone of RDBMS..
it involves multiple steps and levels ranginf grom 1-5
that removes dependencies repetition etc...

Is This Answer Correct ?    2 Yes 0 No

What is normalization?..

Answer / raj

It is the process of deciding which attributed has to
grouped to avoid data redundancy.

Is This Answer Correct ?    2 Yes 0 No

What is normalization?..

Answer / jerry joseph

Normalization is the process of removing redundant data and
preventing anomalies during database updates.

we have 1st degree, 2nd degree 3rd degree etc..

3rd degree normalization is commonly used.

Is This Answer Correct ?    1 Yes 0 No

What is normalization?..

Answer / jai

It is the process of desiging narrow tables from the
collection of data to avoid repition of data

Is This Answer Correct ?    2 Yes 1 No

What is normalization?..

Answer / guest

Well a relational database is basically composed of tables
that contain related data. So the Process of organizing this
data into tables is actually referred to as normalization.

Is This Answer Correct ?    1 Yes 1 No

What is normalization?..

Answer / suhail qaiser

normalization is a design process for representing data in
tabular format.the five normal forms are progressive rules
to represent the data with minial redundancy

Is This Answer Correct ?    1 Yes 1 No

What is normalization?..

Answer / ricky

relational database is composed of related data. so method
to combine these table together is known as normalisation.

Is This Answer Correct ?    0 Yes 0 No

What is normalization?..

Answer / maheswar reddy s

Normalization is database scheema design technique.by which an existing database modified to minimize the redundency and dependency of data

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What are the approximate numeric data types?

0 Answers  


What is a View ? Can we insert, Update and delete a view?

0 Answers   Arigo Infotech,


What are the different types of subquery?

0 Answers  


Suggest a method of joining two tables.

0 Answers   Ernst Young, Thomson Reuters,


What do you mean by the term 'normalization'?

0 Answers   Tech Mahindra,






Explain trigger and its types?

0 Answers  


What happens if the update subquery returns multiple rows in ms sql server?

0 Answers  


Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

0 Answers  


what is difference between nchar and char in Sql server ?

3 Answers  


What is difference between createstatement and preparedstatement?

0 Answers  


What is difference between materialized view and view?

0 Answers  


how we can use a database with php.

2 Answers   HCL, IT Solution,


Categories