Consider a “Digital Games” database with the following relations and attributes: Gamer: (UserID, Name, Age, Address, City, Favorite-Game, Rank) Game: (GameID, Name, Company, Release-Year, Version) Store: (StoreID, Name, Address, City) WhereToFind: (GameID, StoreID, Price) Category: (GameID, Category-Name) From the relational schemas illustrated above, use the different relational algebra operators and operations (ρ, σ, π, ⋂, ⋃, -, ⨝) discussed in class to build the following queries: 1. List -by name and ID- each gamer who lives in the city of Chicago, with a rank of 5, and is aged between 15 (included) and 30 (included). 2. List games -by name and release year- that are not in the “Action” category 3. Since each game can fall within several categories, list games -by name and release year- that are in the “Action” category and also in the “Role-Playing” category
Consider a “Digital Games”
Gamer: (UserID, Name, Age, Address, City, Favorite-Game, Rank)
Game: (GameID, Name, Company, Release-Year, Version)
Store: (StoreID, Name, Address, City)
WhereToFind: (GameID, StoreID, Price)
Category: (GameID, Category-Name)
From the relational schemas illustrated above, use the different relational algebra operators and operations (ρ, σ, π, ⋂, ⋃, -, ⨝) discussed in class to build the following queries:
1. List -by name and ID- each gamer who lives in the city of Chicago, with a rank of 5, and is aged between 15 (included) and 30 (included).
2. List games -by name and release year- that are not in the “Action” category
3. Since each game can fall within several categories, list games -by name and release year- that are in the “Action” category and also in the “Role-Playing” category
4. Display stores -by name- located in the city of Chicago or Seattle and sell a certain game with a game ID of 67782.
5. Display games -by name- that are sold by stores with a price range between 20$ (included) to 100$ (included).
6. List gamers -by name- whose favorite games are either “Call of Duty” or “FIFA”. Call of Duty and FIFA are names for games, not IDs
7. For each possible game, list the name and category of the game as well as the name and address of the store selling it. Name the result as “Full_Info”.
8. List stores -by name and address- that sell games from the “action” category, not from the
“sports” category.
9. Display stores -by name- that sell a game named “NBA” with a price of less than 80$ (included). NBA is the name of the game, not the game’s ID. Name the result as “WhereToFind_NBA”.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
