what is normalization?
what is denormalization?

Answer Posted / sarika desai

Normalization is a concept of Eliminating data redundancy,
Improve database performance & Index Improvement.

De-normalization is the process of attempting to optimize
the performance of a database by adding redundant data.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do I need to start working with sql studio? : sql server management studio

590


How can we use ConnectorJ JDBC Driver with MS SQL?

566


What is the stored procedure?

561


Sql server reporting services vs. Crystal reports.

96


What is the federation in sql azure?

79






While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

87


what is a live lock? : Sql server database administration

496


What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

606


Tell me about builtinadministrator?

562


How to create new tables with "select ... Into" statements in ms sql server?

510


How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

2113


Explain difference between cross join and full outer join?

561


What is the full form of dql?

512


Define a cross join?

594


Does order by actually change the order of the data in the tables or does it just change the output?

672