Oracle SQLPLUS: Please answer the following question. Thank you for your help! S

Question

Oracle SQLPLUS: Please answer the following question. Thank you for your help!

Show the results of the following Relational Algebra expressions:

A. P.name, T.name (PTPT)

B. P.name (P PT city="Dallas" or city="Houston" T)

C. (PP (1 playerid1, 2 draftyear1, 3 playerid2, 4 draftyear2) , ( playerid, draft_year P) × ( playerid, draft_year P))
( playerid P - playerid1 draftyear1 < draftyear2 PP) P

D. P.name (( no_of_games > 100 PT) T P )

PLAYER PlayerID Tane Birth dt Draft year TEAM TcanID City Nanc DIV ID Chanpionships 1204 Chris Paul 1392 1590 Josh Snith 1597 Tyson Chandler 0ct, 182 2005 1996 2004 2001 Nay, 185 Derck Fisher Au, 1974 5 LA Clippers Dec, 1985 11 HoustoRockets 6 23 Dallas lavericks PLAYER TEAM FlayerID TeanID tart date End dat o of ganes 1204 159T 1590 1597 ull 2011 null nul l 2011 234 23 2010 2014 2014 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)

Explanation / Answer

A.

Join of 3 tables, all Player names and Team names.

B.

Name of Players whose Team city is Dallas or Houston

C.

1597

1597

2001

2001

1204

1590

2005

2004

Self Join of table P for all Players whose draft year is less than draft year of other players

D.

NoOfGames > 100

P.name T.name Chris Paul Clippers Josh Smith Houston Tyson Chandler Dallas

Related Questions

Navigate

• Browse (All)
• Browse O
• Subjects

---

---

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