Question: Team ( team name, points ) table [ [ team _ name,points ] , [ Boston , 3 5 ] , [ Montreal ,

Team(team name, points)
\table[[team_name,points],[Boston,35],[Montreal,41],[Minnesota,35],[New York,26],[Ottawa,32],[Toronto,47]]
PlayoffGame(home_team, away_team, winning_team)
\table[[home_team,away_team,winning_team],[Toronto,Minnesota,Toronto],[Montreal,Boston,Boston],[Minnesota,Toronto,Minnesota],[Toronto,Minnesota,Minnesota],[Minnesota,Boston,Minnesota],[Boston,Minnesota,Boston]]
(a) Translate the following query into English and give the answer returned from the query based on the data in the tables above:
(b) Express a FOL statement for the constraint that every team in the PlayoffGame table must be a listed team name in the Team table.
(c) Give a query that returns team names of playoff game winners with the least points in the league. In other words, we want all those who won a playoff game but have the least points within the set of all playoff winners.
You may use the binary predicates ,>, or = in your solution.
Your query should still work even if we add more rows to any table.
 Team(team name, points) \table[[team_name,points],[Boston,35],[Montreal,41],[Minnesota,35],[New York,26],[Ottawa,32],[Toronto,47]] PlayoffGame(home_team, away_team, winning_team) \table[[home_team,away_team,winning_team],[Toronto,Minnesota,Toronto],[Montreal,Boston,Boston],[Minnesota,Toronto,Minnesota],[Toronto,Minnesota,Minnesota],[Minnesota,Boston,Minnesota],[Boston,Minnesota,Boston]] (a) Translate

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!