Consider the following schema for a movie database: Player (pID, pName, nationality) Game (gID, gName, price,...

 

Transcribed Image Text:

Consider the following schema for a movie database: Player (pID, pName, nationality) Game (gID, gName, price, platform) Genre (gID, genre) Play (pID, gID, duration) Your task: write the relational algebra expressions for the following queries: 1) Find the names of the games that are in the role-playing genre and have prices lower than $200. (2 marks) 2) Find the names of the players who have played more than 5 games where duration of each is more than 3 hours. Only consider the games that are on the Windows Platform. (2 marks) 3) Find the names of the games that are in both Adventure and Action genres at the same time and have been played by German players. (3 marks) 4) Find the names of the Italian players who have only played games that are on the PSP platform and have never played any game that are in the Fighting genre. (3 marks) Note: Attributes that are not part of the primary key are not unique. Please keep to the operators/notations taught in the lecture. Consider the following schema for a movie database: Player (pID, pName, nationality) Game (gID, gName, price, platform) Genre (gID, genre) Play (pID, gID, duration) Your task: write the relational algebra expressions for the following queries: 1) Find the names of the games that are in the role-playing genre and have prices lower than $200. (2 marks) 2) Find the names of the players who have played more than 5 games where duration of each is more than 3 hours. Only consider the games that are on the Windows Platform. (2 marks) 3) Find the names of the games that are in both Adventure and Action genres at the same time and have been played by German players. (3 marks) 4) Find the names of the Italian players who have only played games that are on the PSP platform and have never played any game that are in the Fighting genre. (3 marks) Note: Attributes that are not part of the primary key are not unique. Please keep to the operators/notations taught in the lecture.