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

Is ssrs support other database except ms sql server?

96


What are the differences between triggers and stored procedures?

533


What is mscorsvw.exe - process - microsoft .net framework ngen?

525


what are constraints? : Sql server database administration

517


Can a database be shrunk with users active?

601






Scalability, Availability, Integration with internet, etc.)?

2433


What is the Disadvantage of indexed sequential file.

616


Do you know the capabilities of cursors?

533


How many types of the database links?

600


Explain a join?

611


what is a transaction? : Sql server database administration

471


What is RMS migrations?

1698


Is INSTEAD OF trigger directly applicable to Table ?

571


Can you name a few encryption mechanisms in sql server?

541


What is a scheduled job or what is a scheduled task?

535