SQL Server Functions Question:
Download Questions PDF

Explain Steps of normalization?

Answer:

First Normal form
Entities of the table must have unique identifier or entity key.
Second Normal Form
All the attributes of the table must depend on the entity key for that entity.
Third Normal Form
All attributes that are not part of the key must not depend on any other non-key attributes.

Download MS SQL Server Functions Interview Questions And Answers PDF

Previous QuestionNext Question
Explain database Normalization?What is De-normalization?