1.

What Is Normalisation?

Answer»

Normalisation is the process of organising the tables to remove the redundancy.There are mainly 5 Normalisation RULES.

  • 1 Normal Form :: A table is SAID to be in 1st Normal Form when the attributes are ATOMIC.
  • 2 Normal Form :: A table is said to be in 2nd Normal Form when all the candidate keys are dependant on the primary key.
  • 3rd Normal Form :: A table is said to be third Normal form when it is not dependant transitively.

Normalisation is the process of organising the tables to remove the redundancy.There are mainly 5 Normalisation rules.


Discussion

No Comment Found

Related InterviewSolutions