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 to use DTS package in 2000,2005,2008 in sql server

1611


What are database states in ms sql server?

828


How do I create a trace in sql server?

692


how would you improve etl (extract, transform, load) throughput?

760


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

2032






What happens if ntwdblib.dll is missing on your machine?

861


What is database dimension? : sql server analysis services, ssas

832


How to convert binary strings into integers in ms sql server?

723


How do I find information about the install locations for the various instances running on a computer?

752


What is the difference between grant and with grant while giving permissions to the user?

728


Explain forward - only cursors?

703


What are the drawbacks of reporting in ssrs?

122


What are pages and extents? : SQL Server Architecture

710


what's new in sql server 2016?

725


What is the difference between varchar and varchar(max) datatypes?

761