Part 1: Use the following schema to answer the questions 1-3 below. This schema refers to a gaming organization. There can be any number of players per game. Each game and each tournament has one...


Part 1: Use the following schema to answer the questions 1-3 below. This schema refers to a gaming<br>organization. There can be any number of players per game. Each game and each tournament has one<br>winner; if the game or tournament is ongoing, the winner is null. The gameWinner and<br>tournamentWinner attributes are foreign keys for memberID.<br>Member (memberlD, memberName, joinDate)<br>Game (gamelD, gameType, gameDate, gameWinner, tournamentName)<br>MemberGame (memberlD, gamelD)<br>Tournament (tournamentName, tournamentWinner)<br>1. Write mySQL queries to generate the following tables:<br>a. The total number of ongoing tournaments.<br>b. The average number of players per game of type Power Grid.<br>c. The names (no duplicates) of all players Abigail Baker beat in any game.<br>

Extracted text: Part 1: Use the following schema to answer the questions 1-3 below. This schema refers to a gaming organization. There can be any number of players per game. Each game and each tournament has one winner; if the game or tournament is ongoing, the winner is null. The gameWinner and tournamentWinner attributes are foreign keys for memberID. Member (memberlD, memberName, joinDate) Game (gamelD, gameType, gameDate, gameWinner, tournamentName) MemberGame (memberlD, gamelD) Tournament (tournamentName, tournamentWinner) 1. Write mySQL queries to generate the following tables: a. The total number of ongoing tournaments. b. The average number of players per game of type Power Grid. c. The names (no duplicates) of all players Abigail Baker beat in any game.

Jun 01, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions ยป

Submit New Assignment

Copy and Paste Your Assignment Here