Question

What is normalization? What are its types?

Answer 1

Your web browser (Samsung Internet 3.5) is out of date. Update your browser for more security, speed and the best experience on this site.Update browser Ignore

Toggle navigation

TopicsWebinarsDownloadsDictionaryTutorialsQ & ATrendingMore

Home  Dictionary  Tags  Enterprise  Databases 

Normalization

Definition - What does Normalizationmean?

Normalization is the process of reorganizing data in a database so that it meets two basic requirements: (1) There is no redundancy of data (all data is stored in only one place), and (2) data dependencies are logical (all related data items are stored together). Normalization is important for many reasons, but chiefly because it allows databases to take up as little disk space as possible, resulting in increased performance.

Normalization is also known as data normalization.

The normal forms (from least normalized to most normalized) are:

UNF: Unnormalized form.1NF: First normal form.2NF: Second normal form.3NF: Third normal form.EKNF: Elementary key normal form.BCNF: Boyce–Codd normal form.4NF: Fourth normal form.ETNF: Essential tuple normal form.

hope it will help you