The Gateway to Computer Science Excellence
0 votes
178 views

in Databases by (37 points)
retagged by | 178 views
0
800 I think
0
yes ,explanation please??
0
When you will naturally join S and T both have E as common. As for S E is simple candidate key and will have unique values and in T E can take same values as it not simple. So,maximum we can get by joining is 80 tuples. Now, Joining with table R.as A is candidate key it will have unique value and in previous S join T there aslo A will have unique value, So, maximum tuple we will get will be 80. Now,Joining these three R,S,T with U common attribute will be D,G both are non-key so,maximum we get when both D,G are same for every table. So,80*10=800.
0
got it,thank u..

Please log in or register to answer this question.

Related questions

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
50,833 questions
57,750 answers
199,479 comments
108,161 users