Normalization and denormalization

Answer Posted / pragyan

database normalization is a data design and organization process applied to data structures based on rules that help building ralational databases.and usually it involves dividing a database into two or more tables and defining relationships between the tables.

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

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why is normalisation important?

671


What is 3nf normalization form?

760


What does it mean if @@cursor_row returns a negative number?

717


How to configure and test odbc dsn settings?

797


how can u get last observation in an unknown dataset ?

2179






Name few endpoints exposed by ssrs 2012?

330


What is subreport?

112


can you instantiate a com object by using t-sql? : Sql server database administration

713


in the physical file layout, where should the transaction log be stored in relation to the data file?

720


How to Sync Two SQL Azure Databases?

111


How to find the list of fixed hard drive and free space on server?

782


How to check parameter value in stored procedure sql server?

656


What is a data source file?

678


Why variables called the most powerful component of ssis?

796


explain different types of cursors? : Sql server database administration

751