Interested to Buy Any Domain ? << Click Here >> for more details...
What is normalization and types of normalization?
- 22 Answers
- 129215 Views
- Etisbew, F-TEC, Microsoft, TechProcess, I also Faced
- E-Mail Answers
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
What do you understand by pl/sql packages?
how can we know the count/number of elements of an array? : Sql dba
Does sql*plus also have a pl/sql engine?
How much does sql certification cost?
What are the disadvantages of not performing database normalization?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Does oracle roll back the transaction on an error?
What is exception? What are the types of exceptions?
How do I save a stored procedure?
what is the difference between myisam static and myisam dynamic? : Sql dba
What is sql query optimization?
what's the difference between a primary key and a unique key? : Sql dba
What is right join sql?
What is the difference between a primary key and a clustered index?
What is sql procedures and functions?
