Question

Using the sports database containing two relations (TEAM, MATCH_DETAILS), answer the following relational algebra queries.
a) Retrieve the MatchID of all those matches where both the teams have scored >70.
b) Retrieve the MatchID of all those matches where FirstTeam has scored < 70 but SecondTeam has scored >70.
c) Find out the MatchID and date of matches playedby Team 1 and won byit.
d)Find out the MatchID of matches played by Team 2 and not won byit.
e) In the TEAM relation, change the name of the relation to T_DATA. Also change the attributes TeamID and TeamName to T_ID and T_NAME respectively.

Answer 1

Explanation:

$\huge\color{orange}\star\:\tt\pink{Answer}\:\star$

:)

.......$HEARTLESS BoY♡$

Answer 2

Answer:

refer the above answer...................