What is normalization? Explain normalization types.

Answer Posted / guest

Database normalization is the process of organizing the
fields and tables of a relational database to minimize
redundancy and dependency. Normalization usually involves
dividing large tables into smaller (and less redundant)
tables and defining relationships between them. The
objective is to isolate data so that additions, deletions,
and modifications of a field can be made in just one table
and then propagated through the rest of the database via the
defined relationships.

1 NF:Normal Form
2 NF
3 NF
BCNF - Boyce Code Normal Form
5 NF
6NF : Impossible to achieve this level of normalization

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

IIS Migration ?

1876


What is a virtual directory in iis?

553


How do you uninstall iis apps?

521


How do I stop and start iis?

498


Why do you need iis?

509






Where is iis win7?

493


What is an iis application?

563


What is etw iis?

507


How do I setup an ssl certificate?

507


What is the hardware requirements for the iis server so that we can host a webpage?

497


What does restarting iis do?

504


How do I check the version of iis?

503


How do I create a virtual directory?

468


What is the default identity of iis6.0?

516


How do I edit web config in iis?

537