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 need to match each normal form with its correct property.

BCNF:

BCNF is stronger than 3NF.

A decomposition into BCNF is not always dependency preserving.

So,

$(A)-(II)$

3NF:

3NF removes transitive dependency.

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

So,

$(B)-(III)$

2NF:

2NF removes partial functional dependency.

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

So,

$(C)-(IV)$

4NF:

4NF removes multivalued dependency.

It is used when a relation has non-trivial multivalued dependencies.

So,

$(D)-(I)$

Final 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...