What is normalization and its forms?

Answer Posted / srinivas

Normalization is the process of splitting the table into
multiple subtables based on their functional dependency.

Forms are First normal form, Second normal form, and Third
normal form.

Is This Answer Correct ?    10 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the advantages of using cte?

561


I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

690


What is the difference between Clustered and Non-Clustered Index?

612


What is row_number function?

596


How will you decide the active and passive nodes?

651






Define full outer join in sql server joins?

509


What is advantage data architect?

523


How do I perform an unattended install of sql server 2000?

609


What stored by the master? : sql server database administration

589


Can coalesce return null?

559


What is an expensive query?

543


What are the difference between “where” and “having” clause in sql server?

593


Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

78


What are “unrepeatable reads”?

751


Write a program using SQL queries to find a unique entry in a table.

552