What is normalization and types of normalization?

Answer Posted / udhaya kumar

Normal forms in SQL are given below.

First Normal form (1NF): A relation is said to be in 1NF if
it has only single valued attributes, neither repeating nor
arrays are permitted.

Second Normal Form (2NF): A relation is said to be in 2NF if
it is in 1NF and every non key attribute is fully functional
dependent on the primary
key.

Third Normal Form (3NF): We say that a relation is in 3NF if
it is in 2NF and has no transitive dependencies.

Boyce-Codd Normal Form (BCNF): A relation is said to be in
BCNF if and only if every determinant in the relation is a
candidate key.

Fourth Normal Form (4NF): A relation is said to be in 4NF if
it is in BCNF and contains no multi valued attributes.

Fifth Normal Form (5NF): A relation is said to be in 5NF if
and only if every join dependency in relation is implied by
the candidate keys of relation.

Domain-Key Normal Form (DKNF): We say that a relation is in
DKNF if it is free of all modification anomalies. Insertion,
Deletion, and update anomalies come under modification
anomalies.
--- *********************---

Is This Answer Correct ?    115 Yes 21 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are records give examples?

795


How to order siblings in oracle hierarchy queries?

811


What is data type in sql?

773


How do you create a db file?

756


Which is better join or inner query?

752


What found sql?

737


How does left join work in sql?

748


What are the advantages of normalization?

846


Which are sql * plus commands?

764


What is a delimiter in sas?

775


Does varchar need length?

750


What is pivot query?

866


Can we use pl sql in sql server?

785


mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

818


what is the difference between a local and a global temporary table? : Sql dba

796