(B) Consider the following schema PLAYER PlaycrID Birth dt Draft ycar TEAM TeanI
ID: 3907530 • Letter: #
Question
(B) Consider the following schema PLAYER PlaycrID Birth dt Draft ycar TEAM TeanID City DIV ID Chanpiorshhips 1204Chris Faul 1392 Derek F1sher ug, 1974 1590 Josh Snith 159Tyson Chadler Dct, 182 2005 1996 2004 Nay, 185 LA lippers Dec, 1985 23 DallasHavericks PLAYER TEAM PlayerLD? TeanID | Start-date! End, date | No-of-ganes 1204 2011 null 234 1597 23 2010 2011 126 1590 2014 null 1597 2014 null PlayerlD is a key for Player (P) TeamlD is key for Team (T) (PlayerlD, TeamlD) is a composite key for Player Team (PT) Show the results of the following Relational Algebra expressions (20 points) (i) ? P.name. T.name (PrTwPT) (??) TT P.name (P p PT ? city="Dallas" or city="Houston. T) (iii) p (PP (1 draftyear1, 3 playerid2, 4-draftyear2), (TT playerid, draft year playerid1, 2 P) x (TT playerid, draft year (TT playerid P-TT playerid! ? draftyear1Explanation / Answer
If you have any doubts, please give me comment...
i)
P.name
T.name
Chris Paul
Clippers
Tyson Chandler
Dallas
Josh Smith
Rockets
ii)
P.name
Tyson Chandler
Josh Smith
iii)
PlayerID
Name
Birth_dt
Draft_year
1204
Chris Paul
May, 1965
2005
iv)
name
Tyson Chandler
v)
P.name
Chris Paul
Tyson Chandler
vi)
t.name
p.name
Mavericks
Tyson Chandler
Vii)
name
Chris Paul
Viii)
name
Chris Paul
Josh Smith
ix)
name
Mavericks
x)
name
Derek Fisher
Note: As per theory, RA queries always gives Unique tuples...
P.name
T.name
Chris Paul
Clippers
Tyson Chandler
Dallas
Josh Smith
Rockets
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.