66) What is Fourth (4th) Normal Form (4NF)?
Answer: Fourth normal form eliminates independent many-to-one relationships between columns. To be in Fourth Normal Form:
- A relation must first be in Boyce-Codd Normal Form.
- A given relation may not contain more than one Multi-valued attribute.
4NF is defined as a relation that is in Boyce-Codd Normal Form and contains no nontrivial multi-valued dependencies.
67) What is Fifth (5th) Normal Form (5NF)?
Answer: A relation decomposes into two relations must have the lossless-join property, which ensures that no spurious tuples are generated when relations are reunited through a natural join operation.
However, there are requirements to decompose a relation into more than two relations. Although rare, these cases are managed by join dependency and fifth normal form (5NF).
ALSO CHECK THE BELOW FAQ's:
68) What Are The Lossless Inference Rules For Functional Dependencies (FD's) Or State The Armstrong's Axioms?
69) What Is Domain-Key Normal Form (DKNF)?
70) Define Transaction? Explain Different States Of Transaction?
71) Describe The ACID Properties Of A Transaction?
72) What Is Schedule & What Is The Importance Of Schedule?
73) What Do You Mean By Serializability In Transaction Processing?
74) What Are The Two Methods That Guarantee Serializability?
75) What Is Locking? What Are The Types Of Locking?
... Return To DBMS FAQ's Main Page.
... Return To HR Interview Questions With Answers Main Page.