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
B If P → R and Q → S, then PQ → RS.
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 P→R and Q→S, then PQ→RS.
This statement is correct and is known as the Composition Rule. We can derive it using Armstrong's Axioms:
1. Given P→R, by applying the augmentation rule (augmenting both sides with Q), we get:

PQ→RQ

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

RQ→RS (since RQ is same as QR)

3. By applying the transitivity rule to PQ→RQ and RQ→RS, we obtain:

PQ→RS

Thus, this statement is valid.

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

PQ→RQ

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

PQ→R

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 PQ→R, then P→R or Q→R.
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 PQ→R and P→R, then Q→R.
This is incorrect. Knowing that P independently determines R does not imply that Q also determines R. For example, if we have AB→C and A→C, it does not mean B→C must hold. Here, B could be an entirely irrelevant attribute.

Transparent Access on Mindyard

Built for Learners & Educators Alike

Completely free for students. Educators & coaching institutes get 2 months free Pro trial to create tests.

FREE FOR STUDENTS

Practice & Learn Free for Students

Access unlimited practice questions, detailed step-by-step solutions, and exam study materials — completely free for students.

  • Unlimited mock tests & question bank practice
  • Full access to curated study library & formula notes
  • 100% free for students • No credit card required
2 MONTHS FREE TRIAL

Educators & Coaching Institutes

Create and conduct professional online assessments with AI question generation, tab proctoring, and comprehensive batch management.

  • AI question uploader & rapid test generator
  • Anti-cheating tab proctoring & performance reports
  • Full Pro access free for 60 days • No upfront commitment
Discover more resources

You may also like

Mock Tests

View All
  • CUET UG
  • intermediate
  • 1 hour

A comprehensive CUET UG Mathematics Question Paper with Solutions – 2 June 2023 (Shift 3) designed to help students practice and understand the actual CUET exam pattern. This paper covers important topics from Algebra, Calculus, Coordinate Geometry, Probability, Statistics, Matrices, Determinants, and Vectors, featuring a balanced mix of conceptual, numerical, and application-based questions. Detailed solutions are provided to strengthen problem-solving skills, improve conceptual clarity, and enhance calculation accuracy. Based on the CUET syllabus and previous year exam trends, this paper is ideal for practice, revision, self-assessment, time management, previous year analysis, and final preparation for upcoming CUET UG Mathematics examinations.

  • CUET UG
  • intermediate
  • 1 hour

A comprehensive CUET Accountancy Question Paper – 20 June 2023 (Shift 2) designed to help students practice and analyze previous year exam patterns for effective CUET preparation. This paper covers important topics including Accounting for Partnership Firms, Company Accounts, Financial Statements Analysis, Cash Flow Statements, Accounting Ratios, and Fundamental Accounting Principles. It features a balanced mix of conceptual, numerical, and application-based questions to strengthen accounting concepts, improve calculation accuracy, and enhance problem-solving skills. Based on the CUET exam structure and syllabus, this paper is ideal for practice, revision, self-assessment, time management, previous year analysis, and final preparation for upcoming CUET Accountancy examinations.

Ask AI Tutor
5 left
Q1 View Question & Options
AI Tutor is solving this question...
Reading question context & options...
Ask your own doubt or choose a quick prompt: