Question: Using the NBA schema that you have already created answer the questions that follow: team team ID tnamc rank city championships INTEGER INTEGER VARCHAR(15) INTEGER

 Using the NBA schema that you have already created answer the

Using the NBA schema that you have already created answer the questions that follow: team team ID tnamc rank city championships INTEGER INTEGER VARCHAR(15) INTEGER VARCHAR(20) team player_arena player player ID name position draft year INTEGER retire year INTEGER education VARCHAR(30) team ID INTEGER player ID INTEGER arena ID INTEGER points INTEGER INTEGER VARCHAR(30) VARCHAR(20 arena arena_ID INTEGER aname VARCHAR(20) city VARCHAR(20) The team table has a team id primary key The player table has a player_id primary key The arena table has an arena id primary key The teamplav arena table has a (team id, plaver id, arena id) composite primary key The teamplav arena table has a team id foreign key column that references the team table The team play arena table has a plaver id foreign key column that references the player table The team_play_arena table has a arena_id foreign key column that references the arena table Write and run the following queries. Do not show duplicates (50 points) 1. Print the names of players who joined after 2005 and played for the Hornets 2. Print the names of players that belong to team that comes from a city that begins with 'Ch' and were drafted in 2007 3. Print the names of the teams that played a home game 4. Print the points and name of the player with the highest score 5. Print the names of the teams that played in all arenas

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!