Question

(B) Consider the following schema PLAYER PlayerIlD Nane Birth dtDraft year TEAM TeanIDCityaneDIV ID Chanpionships 1204 Chris Paul 1392 Derek Fisher Aug, 1974 1590 Josh Snith Dec, 1985 1597 Tyson Chandler Oct, 198 2005 1996 2004 2001 ay, 1985 5 LA 11 Houston Rockets 23 Dallas Mavericks Clippers PLAYER TEAM PlayerIDTeanID Start date EnddateNo of ganes 1204 1597 1590 1597 2011 2010 2014 2014 null 2011 null 234 23 126 23 null 28 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) (iii) p (PP (1-playerid1, 2 -»draftyear1, 3-playerid2, 4-draftyear2) , (T playerid, draft year P) x (TT playerid, draft year (TT playerid P-TT playerid1c draftyear1s draftyear2 PP) (iv) ? name (P (o start-date< 2011 PT)) (V) IT Pname ((o o of T P.name (no of games 100 PT) T P) (vi) TT t.name. p.name (O championshipso T PT D4 P) (vii) TT name(m TP , ? teamid ? div#5T ) (viii) TT name (? championships <> 1 T) TP D P ( 2004 P D TP) T (x) TT name (TT playerid P - TT playerid TP) DA P playerid, teamid P ) ?X) TT name (O draft year<

Answer 1

1x) name r3 92 199 1204 1S1 23 1S90. 니 159 20 이 Nank Maven C x ) namplapd plata (TP) ひ! Name Dere Fisher