wht is normalization?can u explain me in detail?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How each E-R model constructs can be mapped to the relational model?

566


What do you understand by triggers and mention the different types of it?

496


How can I change procedure name in sql server?

551


How to add a new column to an existing table with "alter table ... Add" in ms sql server?

585


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

515






How to create prepared statements using odbc_prepare()?

577


What is table-valued sub query?

577


How to join two tables in a single query in ms sql server?

557


How you can get the list of largest tables in a database?

539


What is difference between table aliases and column aliases? Do they affect performance?

516


What is sql server transaction log file?

530


How to override dml statements with triggers?

593


Explain transaction server auto commit?

553


List the different types of joins?

576


What is difference between joins and subqueries?

548