what is normalization?
what is denormalization?

Answer Posted / chethan sy

Normalization is a process of removing redundancy from the
tables.

De-normalization is introducing redundancy.

Is This Answer Correct ?    41 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to define the name and server for a new dsn?

548


What samples and sample databases are provided by microsoft?

574


What are difference between Cluster index and Non-Cluster index?

610


What does it mean to normalize a database and why would you do it?

529


What is the architecture of ms sql reporting service?

529






Explain transaction server implicit?

521


What are the tools available in market as an alternative to sql server reporting services?

88


What is the difference between delete and truncate statements?

568


as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

537


Can two tables share a primary key?

516


what is normalization? : Sql server database administration

531


What is table valued function and scalar valued functions?

496


What are sql dirty pages?

556


Can you explain what are various ways to enhance the ssrs report?

581


you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation

538