Awesome q2a theme
0 votes
14 views
Suppose two FD’s are given
W ->X and W->Y

can we derive by replacing left hand side attribute?
Are X->Y and Y->X are also valid?
in Databases by (85 points) | 14 views

1 Answer

0 votes
W ->X and W->Y mean W can determine X uniquely and W can determine Y uniquely, respectively.

Closure set of W will be {W,X,Y}

Closure set of X will be {X}

Closure set of Y will be{Y}

Example:-

W ->X and W->Y means this:-

W   X   Y

a1 b1  c1

a2 b1  c2

a1 b1 c1

It doesnt satisfy X->Y
by (97 points)
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
Welcome to GATE CSE Doubts, where you can ask questions and receive answers from other members of the community.
8,647 questions
2,855 answers
13,739 comments
95,564 users