Aspire's Library

A Place for Latest Exam wise Questions, Videos, Previous Year Papers,
Study Stuff for MCA Examinations - NIMCET

Previous Year Question (PYQs)



Match List I with List II:
List-IList-II
A. BCNFI. It removes multivalued dependency.
B. 3NFII. It is not always dependency preserving.
C. 2NFIII. It removes transitive transparency.
D. 4NFIV. It removes partial functional dependency.
Choose the correct answer from the options given below:





Solution

We have to match each normal form with the dependency that it removes or the property related to it.

First, consider $BCNF$.

$BCNF$ means Boyce-Codd Normal Form.

It is stronger than $3NF$.

A relation decomposed into $BCNF$ gives lossless decomposition, but it is not always dependency preserving.

So,

$A-(II)$

Now, consider $3NF$.

$3NF$ means Third Normal Form.

It removes transitive dependency.

In the question, it is written as transitive transparency, but the correct database term is transitive dependency.

So,

$B-(III)$

Now, consider $2NF$.

$2NF$ means Second Normal Form.

It removes partial functional dependency.

A relation is in $2NF$ when it is in $1NF$ and no non-prime attribute is partially dependent on a candidate key.

So,

$C-(IV)$

Now, consider $4NF$.

$4NF$ means Fourth Normal Form.

It removes multivalued dependency.

So,

$D-(I)$

Therefore, the correct matching is:

$(A)-(II), (B)-(III), (C)-(IV), (D)-(I)$


Online Test Series,
Information About Examination,
Syllabus, Notification
and More.

Click Here to
View More


Online Test Series,
Information About Examination,
Syllabus, Notification
and More.

Click Here to
View More

Ask Your Question or Put Your Review.

loading...