Women's Day Special

Today, on Women's Day I got a bunch of Beautiful flower, Chocolate and a Sweet Gift from Inforica. It was a Good Surprise for me when I reached office and saw a bunch of flower, chocolate and a gift already kept on my desk, Thank you so much Sudeep for making every Women feel special today, in Inforica.

Today, I Solved some online Sample papers of IBPS Exam just for practice since I  have applied for that Examination and the exam day is coming closer. Apart from this I am doing the Updations that Sudeep told me to do in my GetJob Project. I am done with adding Master page and linking it with the Content pages so that the Title and Menu Control will appear in each page. Now left with some validation part. Will probably complete today.

Normailization in SQL Server

Normalization is a process of minimizing data redundancy with a series of steps called as normal forms.

The total normalization process includes the following normal forms.

• First Normal Form (1NF)
• Second Normal Form (2NF)
• Third Normal Form (3NF)
• Boyce Codded Normal Form (BCNF)
• Fourth Normal Form (4NF)
• Fifth Normal Form (5NF)
• Restrict Union Normal Form (RUNF)
• Project Join Normal Form (PJNF)
• Sixth Normal Form (6NF)

First Normal Form (1NF):  A table is said to be in 1NF if and only if a primary key is defined for that table and the table does not contain any multivalued columns.

Second Normal Form (2NF): A table is said to be in 2NF if and only if the table is in 1NF and no partial dependencies exist in the table.

Third Normal Form (3NF): A table is said to be in 3NF if and only if the table is in 2NF and no transient dependencies exist in the table.