wht is normalization?can u explain me in detail?

Answers were Sorted based on User's Feedback



wht is normalization?can u explain me in detail?..

Answer / ramesh l.v.

Normalization is the process of efficiently organizing data
in a database. There are two goals of the normalization
process: eliminating redundant data and ensuring data
dependencies make sense

Is This Answer Correct ?    17 Yes 1 No

wht is normalization?can u explain me in detail?..

Answer / nesa4180

The process of separating data into distinct, unique sets
is called normalization.

Is This Answer Correct ?    7 Yes 3 No

wht is normalization?can u explain me in detail?..

Answer / koti

It is the process of removing redundancy data by splitting
the the tables into smaller tables in order to improve the
performance of the data retrieval.

Is This Answer Correct ?    3 Yes 2 No

wht is normalization?can u explain me in detail?..

Answer / granto

The process
of deciding what tables to create and what relationships
exist between them is known as
normalisation.

Is This Answer Correct ?    1 Yes 0 No

wht is normalization?can u explain me in detail?..

Answer / guest

Normalisation is when you reduce redundancy of data in
tables & increase performance

Is This Answer Correct ?    6 Yes 6 No

wht is normalization?can u explain me in detail?..

Answer / md.abdul azeez

Normalization is the process of efficiently organizing data
in a database. There are two goals of the normalization
process: eliminating redundant data and ensuring data
dependencies make sense
0 Ramesh L.v.


Re: wht is normalization?can u explain me in detail?
Answer
# 2 Normalisation is when you reduce redundancy of data in
tables & increase performance
0 Guest






Re: wht is normalization?can u explain me in detail?
Answer
# 3 The process of separating data into distinct, unique
sets
is called normalization.
3 Nesa4180


Re: wht is normalization?can u explain me in detail?
Answer
# 4 It is the process of removing redundancy data by
splitting
the the tables into smaller tables in order to improve the
performance of the data retrieval.

Is This Answer Correct ?    2 Yes 2 No

wht is normalization?can u explain me in detail?..

Answer / anil rajwadi

the task for database design is to structure in way that
eliminated unnecessary duptication and provide rapId path
search to all necessary information.the process of refining
table,column,key and relationship to create efficent
database is call normalization

Is This Answer Correct ?    0 Yes 0 No

wht is normalization?can u explain me in detail?..

Answer / shiva

Normalisation is the bottom up approach to design the database.Normalisation is the process of organising data in a table to reduce reduncy and to improve performance.Normalisation is a set of rules and each rule is called one normalform.

Is This Answer Correct ?    0 Yes 0 No

wht is normalization?can u explain me in detail?..

Answer / hari

Normalization is the process of designing the datamodel and
effocientely store the data in database.to reduce the
redundancy.
1Normal form: Elimanate the repeating groups for individual
table
-Create sepeare table for each set of related data
-identify the each set of related data with a primary key
2nd normal form : create separate table for set of values
that apply the multipule records.
--Releate these tables with a forgign key
3rd Normal Form : Eliminate fields that do not depend on
the key

Is This Answer Correct ?    0 Yes 5 No

Post New Answer

More SQL Server Interview Questions

What is the difference between IN and EXISTS operators in SQL Server?

9 Answers   ASD Lab, CSC, Intelligroup,


What is nonclustered index with included columns ?

0 Answers  


What is the sql case statement used for?

0 Answers  


Can you roll back the ddl statement in a trigger?

0 Answers  


What do you mean by data integrity?

0 Answers  






Why is the need for data conversion transformations?

0 Answers  


In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

0 Answers  


What is the difference between varchar and nvarchar datatypes?

0 Answers  


An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest salaries(there are 4-5 people having the same salary which happens to be the highest).

9 Answers   ADP,


What is indexed views? plz explain with example?

2 Answers  


What are the main control-of-flow T-SQL constructs?

1 Answers  


Does any body please help me what question's have asked for SSRS in the interview?

0 Answers  


Categories