what is normalization?
what is denormalization?

Answer Posted / koti

In relational database design, the process of organizing
data to minimize redundancy. Normalization usually involves
dividing a database into two or more tables and defining
relationships between the tables. The objective is to
isolate data so that additions, deletions, and modifications
of a field can be made in just one table and then propagated
through the rest of the database via the defined relationships.

De-normalization is introducing redundancy.

Is This Answer Correct ?    12 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of builtinadministrators group in sql server? : sql server security

716


Please explain what is “asynchronous” communication in sql server service broker?

695


How do I install sql server?

621


What is the difference between a function and a stored procedure?

751


what kind of lan types do you know? : Sql server database administration

702






What does dml stand for?

685


Why do we use stored procedures in sql server?

677


What is difference statement and preparedstatement?

719


What are different types of raid configurations? : SQL Server Architecture

730


Can I run multiple instances of sql server 2000 at the same time on one computer?

797


What is correlated subquery in sql server?

743


Explain the microsoft sql server delete command? : SQL Server Architecture

776


What is meant by indexing?

663


Tell me the phases a transaction has to undergo?

712


What is TDS(Tabular Data Stream) Gateway?

115