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
how to use DTS package in 2000,2005,2008 in sql server
What are database states in ms sql server?
How do I create a trace in sql server?
how would you improve etl (extract, transform, load) throughput?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
What happens if ntwdblib.dll is missing on your machine?
What is database dimension? : sql server analysis services, ssas
How to convert binary strings into integers in ms sql server?
How do I find information about the install locations for the various instances running on a computer?
What is the difference between grant and with grant while giving permissions to the user?
Explain forward - only cursors?
What are the drawbacks of reporting in ssrs?
What are pages and extents? : SQL Server Architecture
what's new in sql server 2016?
What is the difference between varchar and varchar(max) datatypes?