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

Describe the different types of identity available in iis 6.0?

475


Explain how to create web garden?

508


How do I view iis certificates?

508


Where is the applicationhost config?

445


IIS Socket pooling

2914






How do I find iis settings?

482


What is iis on windows 10?

480


Define the different security settings available in iis?

468


What is App Pool in IIS?

608


How do I create a iis application?

471


How do I stop and start iis?

488


How to open iis configuration manager?

531


What is meant by application domain?

475


What is the difference between app pool and app domain in iis?

508


How do I access iis server?

493