What is database normalization?

Answer Posted / padmapriya

Noramalization is process of breaking the information into
well defined tables which should follow some rules. There
are 5 Normal forms available. Each one having a separate
rule.
1NF-Avoid redundant data
2NF-All coulms except primary key column should be related
to the primary key column
3NF,4NF and 5NF - I'dont remember , if any one knows please
reply

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How connect excel to sql server?

514


How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

564


Explain isolation levels that sql server supports?

582


How we create SQL Server 2005 Reporting Services ? Give me Sample

1581


Can we use where clause with group by?

526






Explain about builtinadministrator?

612


List out different types of normalizations in sql server and explain each of them?

563


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

515


How to configure and test odbc dsn settings?

583


How to select all columns of all rows from a table with a select statement in ms sql server?

582


Explain the use of containers in ssis?

538


Determine when an index is appropriate?

571


Define synonym?

733


What is awe?

577


What is transaction server consistency?

560