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 are SSL and TSL protocols?

577


Explain SSRS Architecture?

139


List the data types available in mssql?

521


Explain about the command-line tool SQLCMD?

548


What is difference between count (*) and count 1?

514






What is database dimension? : sql server analysis services, ssas

618


Is it possible for a stored procedure to call itself or recursive stored procedure?

502


How to change the password of a login name in ms sql server?

557


How do you debug a procedure in sql server?

492


What do you do in data exploration

560


What is the significance of master, tempdb and model databases?

523


Explain indexed views?

555


Can you explain about buffer cash and log cache in sql server?

498


Explain different types of collation sensitivity?

529


Tell me what is log shipping?

564