Question: Consider the following schema for a movie database: Player (pID, pName, nationality) Game (gID, gName, price, platform) Genre (gID, genre) Play (pID, gID, duration)

Consider the following schema for a movie database: Player (pID, pName, nationality)

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.

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!

Following is the current asset section from the Ralph Lauren Corporation balance sheet: The 2018 allowance consists of $202.5 for returns and $19.7 for uncollectible accounts. The amounts tor 2017...

Dhillon v. Zions First National Bank , 462 Fed. Appx. 880, 2012 WL 715273 (11th Cir. 2012) 1. Explain why there was no electronic formation of a contract, that is, email. 2. What exceptions does...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

1. Suppose X1, X2, . . ., X, is a sample from a Normal distribution N (, o) and Y, Y2,..., Y is a sample from a Normal distribution N(, 2). The distributions have the same means but different...

3. Consider the following schema for a movie database (the primary keys of the tables are underlined). Foreign key constraints are also listed under the schema of each table. Person (ID, FirstName,...

( 2 0 pts ) Consider the following schema for a movie database ( the primary keys of the tables are underlined ) . Foreign key constraints are also listed under the schema of each table. Person ( ID...

Please make sure you submit the homework via D 2 L . Submit your written solution in PDF format and the source files of your program as requested. 1 . ( 2 0 pts ) Consider the following schema for a...

A company reported total stockholders equity of $580,000 on its Dec 31, 2018, balance sheet. The following information is available for the year ended 12/21/2019: No dividends were paid in 2019....

3. Consider the following schema for a movie database (the primary keys of e tables are underlined). Foreign key constraints are also listed under the schema of each table. th Person (ID, FirstName,...

A firms macro environment contains elements that can impact the firm but are generally beyond its direct control. These elements are characteristics of the world at large and are factors that all...

Form elements will be used to accept user input which will be assigned to variables. These variable values will make up the content of a new Web page that will be generated when a form button is...

How does the presence of diversity, equity, and inclusion impact the dynamics of team-based communications? Your response should be a minimum of 150 words.

A growing number of organizations have been the target of hacking attacks, or cyberattacks, in recent years. High-profile examples in the U.S. include Target Corp., Home Depot Inc., the Internal...

Walter is both a real estate developer and the owner and manager of residential rental real estate. Walter is retiring and is going to sell both the land he is holding for future development and the...

Two years ago, Micro Corporation granted its employee, Alisa, 20,000 incentive stock options with an exercise price of $15 per share. The stock is currently trading at $40 per share, but Alisa...

John is about to start on the audit of Bourdain Restaurants, a local restaurant chain. In reviewing last years work papers, John discovers that Bourdain Restaurants uses an outside service provider...

Mario's Foods produces frozen meals, which it sells for $8 each. The company uses the FIFO inventory costing method, and it computes a new monthly fixed manufacturing overhead rate based on the...

Rewrite in simple english on an in not more than 350 words In simple terms and lame man language the meaning of findings refers to the specific results or outcomes of a study, while conclusions...

Taxing Goods versus Lump Sum Taxes: I have finally convinced my local congressman that my wifes taste for grits are nuts and that the world should be protected from too much grits consumption. As a...

Suppose two people want to see if they could benefit from trading with one another in a 2-good world. A: In each of the following cases, determine whether trade might benefit the two individuals: (a)...

Trade Barriers against Unfair Competition: Some countries subsidize some of their industries heavily which leads U.S. producers to lobby for tariffs against products from such industries. It is...

Let X be the total medical expenses (in 1000s of dollars) incurred by a particular individual during a given year. Y 5 aX 1 b 1.8m | 1 32 m | Y 5 1.8X 1 32 8F 8C E(Xn ) k 5 2 V(X) 5 ku2(k 2 1)22 (k 2...

The current in a certain circuit as measured by an ammeter is a continuous random variable X with the following density function: a. Graph the pdf and verify that the total area under the density...

2.37. A recent GSS asked subjects if they supported legalizing abortion in each of seven different circumstances. The percentage who supported legalization varied between 45% (if the woman wants it...