The Gateway to Computer Science Excellence
0 votes
115 views

in Databases by (37 points)
retagged by | 115 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,654 questions
56,166 answers
193,872 comments
94,261 users