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

How do I turn off iis?

733


What are the properties of application pool in iis?

675


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

720


Explain the different types of identity available in iis 6.0?

693


What scripts ship with iis 6.0?

707


What is meant by application domain?

682


Where is the iis config file?

709


Is iis server free?

765


How do I setup a web server in windows 10?

697


How do I add a project to iis?

719


How does iis work?

700


What services use iis?

662


What secure authentication and encryption mechanisms are supported by iis 6.0?

899


how we can change a PSD file in a clipart to use in word or power point ?

1938


How do you stop iis service?

705