What are the answers for all of number 3 please? Thank you in advance (B) Consid

Question

What are the answers for all of number 3 please? Thank you in advance

(B) Consider the following schema PLAYER PlaycrID anc Birth dt Draft year TEAM TeanID CityNaneDIV ID Chaapionships 1204 Chris Paul 1392 Dere: Fisheru, 1974 1590Josh Saith Dec, 1985 1597 Tyson Chandler Oct, 1982 2005 1996 2004 2001 Tay, 1985 5 LA 11 Houston Rockets 23 Dallas Navericks Clippers PLAYER TEAM PlayeriDTeD Start date Enddate No of_saaes 1204 1597 1590 1597 2011 2010 2014 2014 null 2011 null nul1 234 23 126 23 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) (i) P.name. T.name (PXT 1PT) (ii) P.name (P PTpq city-"Dallas" or city-.'Houston" T) (iii) (PP (1 playerid1, 2 draftyearl, 3 playerid2, 4 draftyear2) , ( playerid, draft-year P) × ( playerid, draft-year P)) (n playerid P- playerid 1 draftyear1 100 PT) DAT P )

Explanation / Answer

Solution:

i)

ii)

iii)

iv)

I hope this helps, please let me know in case of any doubt. Thumbs up if this helped.

Player Name Player Team Chris Paul Clippers Josh Smith Rockets Tyson Chandler Navericks

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---