Morgan Stanley Interview Question

database: describe the 1NF, 2NF and 3NF.

Interview Answers

Anonymous

Jun 2, 2018

Normallization is done to reduce data redundancy During Insertion,Updation,Deletion 1N is staircase to reach 2N and 3N 1) 1N Single Valued Attributes Attributes should not change Unique name for attribute Column Order doesn't matter 2)2N Table should be in 1N form Their should not be any partial dependency 3)3N Table should be in 2N form Their should not be any Transitive dependency

Anonymous

Nov 3, 2014

the answer is on google.