Part 1: Use the following schema to answer the questions 1-3 below. This schema refers to a gamingorganization. There can be any number of players per game. Each game and each tournament has onewinner; if the game or tournament is ongoing, the winner is null. The gameWinner andtournamentWinner attributes are foreign keys for memberID.Member(memberID, member Name.joinDate)GamelgamelD, gameType, gameDate, gameWinner, tournamentName)-MemberGamel(memberID, gamelD)-Tournament(tournamentName, tournamentWinner)ww 1. Write SQL 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.ec. The names (no duplicates) of all players Abigail Baker beat in any game."d. Each tournament name with the number of games in that tournament won by thetournament winner.e. A list of game IDs and game types sorted by game type then game id.f. Alist of player IDs of all players who have played a game with the date of the first gameplayed by that player.

SQL query: Structured Query language is used doing operation in database such as insertion, deletion…

1. Write SQL 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." d. Each tournament name with the number of games in that tournament won by the tournament winner. e. Alist of game IDs and game types sorted by game type then game id. f. Alist of player IDs of all players who have played a game with the date of the first game played by that player.

1. Write SQL 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." d. Each tournament name with the number of games in that tournament won by the tournament winner. e. Alist of game IDs and game types sorted by game type then game id. f. Alist of player IDs of all players who have played a game with the date of the first game played by that player.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

A potential key exists for a composite primary key's property. How do you feel about this news?
Class field corruption must be prevented.
Create a class of any domain i.e. university, showroom, student, shop. Also mention attributes for them and initialize the values using constructor and show the values for each object using custom function (out side the class) hint: min no of objects 2
FD's BookID -> Title BookID > Author Title BookID Title -> Author Author -> Title Author -> BookID IS THIS 1NF? Yes this is 1NF. BECAUSE THERE IS SINGLE VALUE ATTRIBUTES.
Select the class relationship that best describes the following scenario: Class A can has a method that has no parameters. This method modifies an attribute of itself. Association (Reflexive) Association (Bidirectional) Association (Directed A to B) Association (Directed B to A) Composition (A as the whole and B as the part) Composition (B as the whole and A as the part) Aggregation (A as the whole and B as the part) Aggregation (B as the whole and A as the part) O Inheritance None of the given
Member m = new BoardMember(); Is this statement legal or illegal and widening or narrowing conversion.
In which of the following relationship, a bigger class contains the smaller parts classes? Aggregation Composition Communication Inheritance
Based on the following figure. The relationship on the MEMBER side indicates that: PK BOOKS ISBN TITLE o PRICE O a. A BOOKS may be borrowed by zero or one MEMBER only O b. A MEMBER may borrow one BOOKS O c. A BOOK may be borrowed by one or more MEMBER O d. A MEMBER may borrow zero or more BOOKS borrow O.N) (0,1) borrowed by PK MEMBER MEMBERID NAME * ADDRESS o PHONE o EMAIL
An Art Museum needs to keep track of its artwork and exhibitions. The museum has a collection of artwork. Each piece of art has a unique id [ArtID], an artist, year and title. Artwork is categorized by type. There are two types, paintings and sculptures. Paintings have a paintType and style. Sculptures have a material, height and weight. Artwork is frequently shown in exhibitions. Each exhibition has a unique name, startDate, endDate. A listing of the artwork displayed at an exhibition is also retained. Below is an E-R diagram for a database to help the Art Museum. Provide appropriate names for entities E1, E2, E3, E4 identifiers 11, 12, 13, 14 missing attributes and relationship cardinality RC1 and relationship type RT1. Start_date End_date E1 E1 11 RC1 PaintType Style E3 13 A1 Title Year A/ A A/ A/ A/ A/ A/ A/ A A/ A/ E2 12 A/ E2 E3 E4 11 12 13 14 A1 A2 RC1 RT1 RT1 A2 Height Weight E4 14 Activate Go to Settin
What are static members? Discuss various properties.
Which statement is true from the following: only protected elements can be inherited only private elements can be inherited only protected and public elements can be inherited all elements can be inherited
c++ language Create Class Student▪ Data Members: Name , ID and GPA.▪ Make the data members visibility to be private.▪ Use setter and getter method for each attribute.▪ In the main, set values for the student details using setter function, then retrieve the value using the getter function.▪ Print what you retrieve