Database Management Systems, Quiz 2

January 2024 term, 24 Mar 2024, Set QDD2

Quiz Space

MusicOpen the study music controls.

CalculatorOpen the calculatorLearning mode

Question 1

+3−0Single correctInstructions

Let P and Q be two relations. Let D(P) be a decomposition of P based on a set M of functional dependencies. Let D(Q) be a decomposition of Q based on a set N of functional dependencies. It is known that one among D(P) and D(Q) is in 3NF and the other is in 2NF. In order to correctly classify D(P) and D(Q) as being in 3NF or 2NF,what is the MINIMAL test needed?

Select one option

• A.

  Test whether both are in 3NF

• B.

  Test whether both are in 2NF

• C.

  Test whether one of them is in 2NF

• D.

  Test whether one of them is in 3NF

Show answer

Report

Report a problem

Sign in to report a problem with this question.

Clear Response

PreviousNext

Submit this paper?

You cannot change your answers after submitting.

Answered

0

Not answered

1

Marked for review

0

Answered & marked for review

0

Not visited

2

Keep goingSubmit paper

Instructions

The palette shows the status of every question. Pick a number to go straight to it.

Answered

0

Not answered

1

Marked for review

0

Answered & marked for review

0

Not visited

2

• Save & Next moves to the next question. Answers are saved as you go.
• Mark for Review & Next flags the question to come back to. A flagged answer still counts.
• Clear Response removes your answer to the question on screen.
• The ← and → keys move to the previous and next question.

Let P and Q be two relations. Let D(P) be a decomposition of P based on a set M of functional dependencies. Let D(Q) be a decomposition of Q based on a set N of functional dependencies. It is known that one among D(P) and D(Q) is in 3NF and the other is in 2NF. In order to correctly classify D(P) and D(Q) as being in 3NF or 2NF,what is the MINIMAL test needed? Figure from the original question paper Figure from the original question paper