DEVFYI - Developer Resource - FYI

What is Normalisation

ORACLE Interview Questions and Answers (Part 4)


(Continued from previous question...)

623. What is Normalisation

Normalisation is the process of organising the tables to remove the redundancy.There are mainly 5 Normalisation rules.
a) 1 Normal Form :: A table is said to be in 1st Normal Form when the attributes are atomic
b) 2 Normal Form :: A table is said to be in 2nd Normal Form when all the candidate keys are dependant on the primary key
c) 3rd Normal Form :: A table is said to be third Normal form when it is not dependant transitively

(Continued on next question...)

Other Interview Questions