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

Where is iis express config?

685


How do I restart iis in windows 10?

689


How do I create a iis application?

688


How do I setup a web server in windows 10?

673


What is application pooling in iis?

705


Explain how to create web garden?

665


How do I create a virtual directory?

668


How do I reset iis in windows 10?

706


How do I run iis express?

795


What is iis used for?

699


What is iis worker process?

682


How do I add a project to iis?

694


How do I enable iis logs?

673


How do I find server logs?

699


What is the name of default application pool in iis?

637