The Gateway to Computer Science Excellence
0 votes

in Databases by (37 points)
retagged by | 178 views
800 I think
yes ,explanation please??
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 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.
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
108,161 users