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 logs located?

509


What is the shortcut to open iis manager?

555


What is a web server used for?

504


What is iis officer?

564


Where is appcmd?

490






What is the service name for iis?

496


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

487


Why do we need to recycle application pool?

490


What is the use of iis server in net?

497


roles of information system in a business organization?

1752


Does windows 10 come with iis?

517


What services use iis?

488


Explain the different security settings available in iis?

481


What is iis used for?

485


How do I create a iis application?

473