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
Mention what are different methods to trace the pl/sql code?
What is sql dialect?
What is trigger explain it?
how does a local variable is defined using t-sql? : Transact sql
How much does sql certification cost?
What is minus?
The in operator may be used if you know the exact value you want to return for at least one of the columns.
Which nosql database is best?
What is a pl/sql block?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
what are local and global variables and their differences? : Sql dba
What is view explain with example?
What is the purpose of the primary key?
What is primary key in db?
What is trigger in sql and its types?