Broadridge Interview Question

what are the types of normalization in relational database? Describe each.

Interview Answers

Anonymous

Jun 20, 2012

1NF,2NF, 3NF, BCNF and 4NF.

1

Anonymous

Oct 30, 2012

condition for 1NF:no two rows are identicaland each table entry is single valued. condition for 2NF:if it is in 1NF,& each key attribute is functionally dependent on entire key. condition for3NF:if it is in 2NF & every nonkey attribute is a non transitive dependent upon the primary key condition for BCNF:if it is in 3NF &no key is allowed to be functionally dependent on any non-key attributes condiitiion for 4NF:if it is in BCNF & no multivalued denpendency.