Pergunta de entrevista da empresa Broadridge

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

Respostas da entrevista

Sigiloso

20 de jun. de 2012

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

1

Sigiloso

30 de out. de 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.