POSSIBLE HELPER BELOW: - MAY OR MAY NOT NEED (B) Consider the following schema P

Question

POSSIBLE HELPER BELOW: - MAY OR MAY NOT NEED

(B) Consider the following schema PLAYER PlayerID Birth dt Draft year TEAM TcanID City 1204ris Faul 1392Derek Fisher Aug, 197 1580 Josh snith Dec, 198 1597Tyson Charuller Oct, 1582 ay, 1 2009 LA 11ut Rockets 23 Dallas Vavericss 1996 Clippers 2001 PLAYER TEAM PlayerIDTeanID Start date End dateoo1 eaaes 1204 1597 1590 2011 2010 2014 null 2011 null 234 128 1597 2014 nul 1 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) ? P.name. T.name (PD Tp PT) (??) TT P.name (P PT Dd ? city."Dallas-or city."Houston. I (ii) p (PP (1-playerid1, 2-draftyear1, 3-> playerid2, 4 -» draftyear2), (TT playerid, draft_year playerid, draft year playerid P - T playerid1 ? draftyear1

Explanation / 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

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.