Question Details

Consider a relation R(A, B, C, D) and functional dependencies of X → Y. Which of the following statement are correct?

Options

A

If PQ → R, then P → R or Q → R.

B

If P → R and Q → S, then PQ → RS.

C

If P → R, then PQ → R.

D

If PQ → R and P → R, then Q → R.

Show Answer

Correct Answer :

Option B

If P → R and Q → S, then PQ → RS.

Option C

If P → R, then PQ → R.

Solution :

The correct statements are:
1. If P → R and Q → S, then PQ → RS.
2. If P → R, then PQ → R.

Let us analyze the correctness of each statement step-by-step using the formal inference rules for functional dependencies (also known as Armstrong's Axioms).

Statement 1: If PR and QS, then PQRS.
This statement is correct and is known as the Composition Rule. We can derive it using Armstrong's Axioms:
1. Given PR, by applying the augmentation rule (augmenting both sides with Q), we get:

PQRQ

2. Given QS, by applying the augmentation rule (augmenting both sides with R), we get:

RQRS (since RQ is same as QR)

3. By applying the transitivity rule to PQRQ and RQRS, we obtain:

PQRS

Thus, this statement is valid.

Statement 2: If PR, then PQR.
This statement is correct and is known as the Augmentation Rule (specifically, a direct consequence of it).
According to the augmentation rule, if PR holds, we can append any set of attributes Q to both the left and right sides to get:

PQRQ

Since RQR is a trivial functional dependency (decomposition rule), we can apply transitivity to get:

PQR

This means that adding extra attributes to the left-hand side of a functional dependency (which is called making the determinant super-key larger) does not invalidate the dependency. Thus, this statement is valid.

Let us also verify why the other statements are incorrect to complete the explanation:

Statement 3 (Incorrect): If PQR, then PR or QR.
This is incorrect because P and Q might jointly determine R, but neither of them can determine R individually. For example, in a relation R(A,B,C) where a customer A buys a product B at price C, the price C depends on both the customer and the product combined, but not on the customer alone or the product alone.

Statement 4 (Incorrect): If PQR and PR, then QR.
This is incorrect. Knowing that P independently determines R does not imply that Q also determines R. For example, if we have ABC and AC, it does not mean BC must hold. Here, B could be an entirely irrelevant attribute.

Unlock Our Free Library

Access expert-curated educational resources and study materials—completely free.

Ask AI Tutor
5 left
Q1 View Question & Options
AI Tutor is solving this question...
Reading question context & options...