in Databases
675 views
0 votes
0 votes

Consider the relation R with the following information (A,B,C,D) :-

A B C D
a b z 1
e b r 1
a d z 1
e d r 1
a f z 2
e f r 2

find the total number of FD in above relation (ignore the self FD’s X->X,Y->Y,XY->X,XY->Y etc).

i am getting only 10, but it is wrong;

is there any faster and appropriate technique for this?

in Databases
675 views

13 Comments

which est series it is ?
0
0
raman classes

u must haven't heard the name!

they must have copied this question from somewhere!

answer given is 12 btw!!
0
0
actually there are more number, i mean a huge difference,

I want to see their explanation !
0
0

By the way, these images may help you !

1
1

I want to see their explanation !

they dont provide explanation, just answers 

0
0
ok...
0
0
If ignoring reflexivity fd's,  then given answer is right
0
0
yes,they have asked to ignore them!

then should i follow same procedure as u have showed in uploaded image?

or to see each FD satisfied in the table given in ques!
0
0

yes,they have asked to ignore them!

it is saying only avoid self but not reflexive !

 

then should i follow same procedure as u have showed in uploaded image?

or to see each FD satisfied in the table given in ques!

first form the FD's from Data

A --> C

C --> A

B ---> D

AB ---> CD

then follow the procedure !

1
1
ok,thanks
0
0

@Shaik Masthan 

sir is there any trick to find no. of super keys also like u showed for FDs

. if u have some image for that, then pls share!

0
0

Everyone follows same method,

if you want check this, it may helpful ( pages are damaged, but you can get what there written )

1
1
thanku so much for sharing!!
0
0

Please log in or register to answer this question.

Related questions