THESE ARE ALL UNDER ONE PROBLEM

This database schema is for a NBA basketball tournament and there are 4 relations in this schema, which are described below along with their integrity constraints. Columns in the primary key are underlined.

Player (playerID: integer, name, varchar(50), position: varchar(10), height : integer, weight : integer, team: varchar(30)). Each player is assigned a unique playerID. The position of a player can either be Guard, Center, or Forward. The height of a player is in inches while the weight is in pounds. Each player plays for only one team. The team field is a foreign key to Team.

Team: (name, varchar(30, city ; varchar(20))

Each team has a unique name associated with it. There can be multiple teams from the same city.

Game: (gameID: integer, homeTeam: varchar(30), awayTeam : varchar(30), homeScore : integer, awayScore, integer, Date)

Each game has a unique gameID. The fields homeTeam and awayTeam are foreign keys to Team. Two teams may play each other multiple times each season. We assume that homeTeam and awayTeam are different.

GameStats (playerID: integer, gameID: integer, points: integer, assists : integer, rebounds : integer) GameStats records the performance statistics of a player within a game. A player may not play in every game, in which case there will be no statistics of a player within a game. gameID is a foreign key to Game. playerID is a foreign key to Player.

Express the following queries in 1) Algebra (1 to 4), II) Calculus (2 and 4) and 3) SQL(ALL)

1. List the games played by Lebron James.

2. List the names of the Lakers players involved in at least 1 game against the Bulls.

3. List the names of the Lakers players who played only when the team is away.

4. Which of the players of the Lakers played all the games of the team?

5. List for every player along with his team, the number of games he played.

6. What was the last time the Lakers played the Bulls (Note that you are being asked to write a query that returns the answer)