Register
Dark Mode

Memory Based GATE DA 2024 | Question: 16

in Databases recategorized by
176 views
0 votes
0 votes
Consider a relation R:
\[
\begin{aligned}
& R(U, V, W, X, Y, Z) \\
& F=\left\{
\begin{array}{l}
    U \rightarrow V \\
    U \rightarrow W \\
    WX \rightarrow Y \\
    WX \rightarrow Z \\
    V \rightarrow X
\end{array}
\right.
\end{aligned}
\]
From the above set of functional dependencies, determine which additional functional dependency can be deduced. Which of the following options is correct?
  1. $VW \rightarrow U$
  2. $VW \rightarrow Y$
  3. $VW \rightarrow YZ$
  4. $WX \rightarrow YZ$
in Databases recategorized by
by
176 views

1 Answer

1 vote
1 vote
$(VW)^+ = (V , W , X ,Y, Z )$

$(WX)^+ = (W , X, Y, Z)$

So options B, C, D are correct.
by
← PreviousNext →
← Previous in categoryNext in category →

Related questions

Subscribe to GATE CSE 2024 Test Series

Subscribe to GO Classes for GATE CSE 2024

Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true

Subjects

64.3k questions

77.9k answers

244k comments

80.0k users

Developed by Chun
Link Copied!