Below are 10 statements describing the relational algebra query to be written using the pizza schema,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Below are 10 statements describing the relational algebra query to be written using the pizza schema, which is reproduced (without the data) here for your reference. The pizza schema: Person( name, age, gender) Frequents( name, pizzeria) Eats( name, pizza ) Serves( pizzeria, pizza, price ) 1.) List all of the pizzas that Amy eats 2.) List the count of pizzas Amy eats 3.) List the count of pizzas all persons eat 4.) List the name and pizzas eaten by people less than 20 years old 5.) List the names of people who eat supreme or cheese pizza 6.) List the names of people who eat supreme and cheese pizza 7.) List the names of all people who eat at least one pizza served by Dominos but who do not frequent Dominos 8.) List all of the pizzerias and pizzas that have a price as much as the most expensive pizza served 9.) List all of the female persons along with the pizzas they eat and how much those pizzas cost at Chicago Pizza 10.) List all pizzas that are eaten only by people younger than 24, or that cost less than $10 everywhere they're served Part 2: Below are 10 statements describing the relational algebra query to be written using the company schema, which is reproduced (without the data) here for your reference. The company schema: EMPLOYEE( Fname, Minit, Lname, Ssn, Bdate, Address, Sex, Salary, Super_ssn, Dno ) DEPENDENT ( Essn, Dependent_name, Sex, Bdate, Relationship ) DEPARTMENT (Dname, Dnumber, Mger_ssn, Mger_start_date ) PROJECT( Pname, Pnumber, Plocation, Dnum ) DEPT LOCATIONS ( Dnumber, Dlocation ) WORKS ON Essn, Pno, Hours ) 11.) List the first and last names of all employees who work in a department that is located in Houston 12.) List the first and last names of all employees who have a dependent with the same first name as themselves 13.) List the first and last names of all employees who have a spouse dependent but not a son dependent 14.) List the first and last names, along with the department they manage and when they began managing that department for all employees who manage a department 15.) List the first and last names of all employees who either work 0 hours total on all projects or more than 40 hours total on all projects 16.) List the first and last names of all employees and include, if they have a spouse, the first name of their spouse 17.) List the first and last names of all employees who are department managers but have no dependents 18.) List the first and last names of all employees who work on at least one project located in Houston but whose department has no location in Houston 19.) List the first and last names of all employees who do not work on any project 20.) List the first and last names of all employees who work on every project Below are 10 statements describing the relational algebra query to be written using the pizza schema, which is reproduced (without the data) here for your reference. The pizza schema: Person( name, age, gender) Frequents( name, pizzeria) Eats( name, pizza ) Serves( pizzeria, pizza, price ) 1.) List all of the pizzas that Amy eats 2.) List the count of pizzas Amy eats 3.) List the count of pizzas all persons eat 4.) List the name and pizzas eaten by people less than 20 years old 5.) List the names of people who eat supreme or cheese pizza 6.) List the names of people who eat supreme and cheese pizza 7.) List the names of all people who eat at least one pizza served by Dominos but who do not frequent Dominos 8.) List all of the pizzerias and pizzas that have a price as much as the most expensive pizza served 9.) List all of the female persons along with the pizzas they eat and how much those pizzas cost at Chicago Pizza 10.) List all pizzas that are eaten only by people younger than 24, or that cost less than $10 everywhere they're served Part 2: Below are 10 statements describing the relational algebra query to be written using the company schema, which is reproduced (without the data) here for your reference. The company schema: EMPLOYEE( Fname, Minit, Lname, Ssn, Bdate, Address, Sex, Salary, Super_ssn, Dno ) DEPENDENT ( Essn, Dependent_name, Sex, Bdate, Relationship ) DEPARTMENT (Dname, Dnumber, Mger_ssn, Mger_start_date ) PROJECT( Pname, Pnumber, Plocation, Dnum ) DEPT LOCATIONS ( Dnumber, Dlocation ) WORKS ON Essn, Pno, Hours ) 11.) List the first and last names of all employees who work in a department that is located in Houston 12.) List the first and last names of all employees who have a dependent with the same first name as themselves 13.) List the first and last names of all employees who have a spouse dependent but not a son dependent 14.) List the first and last names, along with the department they manage and when they began managing that department for all employees who manage a department 15.) List the first and last names of all employees who either work 0 hours total on all projects or more than 40 hours total on all projects 16.) List the first and last names of all employees and include, if they have a spouse, the first name of their spouse 17.) List the first and last names of all employees who are department managers but have no dependents 18.) List the first and last names of all employees who work on at least one project located in Houston but whose department has no location in Houston 19.) List the first and last names of all employees who do not work on any project 20.) List the first and last names of all employees who work on every project
Expert Answer:
Answer rating: 100% (QA)
Step 11 choose a pizzeria from the chemicals that a person joins using name when age 18 b choose a d... View the full answer
Related Book For
Posted Date:
Students also viewed these computer engineering questions
-
Perform a sensitivity analysis of the Midwestern Hardware scenario (Problem 15). Find the optimal order quantity and optimal expected profit for probabilities of a harsh winter ranging from 0.2 to...
-
How do you perform a sensitivity analysis of an investment proposal, and what is its purpose? Contrast the use of scenario analysis with that of simulation analysis.
-
Using a data table in Excel, perform a sensitivity analysis on the example in Simple Decision Problem.xlsx. Specifically, keep the probabilities in row 10 (for D2) as they are, but vary the...
-
What are the key issues associated with managing an international assignment?
-
How do auditors and management relate to each other in determining the financial statements?
-
The transactions on page 345 occurred in April and were related to the general journal and petty cash fund of Merry Co. of Lennoxville: The chart of accounts includes Cash, 100; Petty Cash, 120;...
-
Taylor is engaged to audit Rex Wholesaling for the year ended December 31, 1999. Taylor considered internal controls over purchasing, receiving, trade accounts payable, and cash disbursement and has...
-
Mary is considering opening a new grocery store in town. She is evaluating three sites: downtown, the mall, and out at the busy traffic circle. Mary calculated the value of successful stores at these...
-
Define Geographic Information Systems (GIS) mapping technology, why and how it can be used namely to select an appropriate site for a business. elaborate with examples that you might meet while...
-
Magna Charter is a new corporation formed by Agnes Magna to provide an executive flying service for the southeastern United States. The founder thinks there will be a ready demand from businesses...
-
Given the points P1(5, 2, 1), P2(1, 5, 2) and P3(10, 2,0). Find the vector that is orthogonal (perpendicular) to the vector P P
-
What information must be provided in a corporations annual financial statements?
-
When is it necessary for a partnership to be registered?
-
Describe the requirements for a party to be considered a holder in due course.
-
What is meant when one says that a minority shareholder is (a) locked in and (b) frozen out?
-
Why is it important to distinguish between partnership property and the personal property of the individual partners?
-
Two capacitors (C1 = 4.2F, C2 = 16.6F) are charged individually to (V = 19.2V, V = 5.1V). The two capacitors are then connected together in parallel with the positive plates together and the negative...
-
Why is it important to understand the macro-environment when making decisions about an international retail venture?
-
During the Asian crisis in 1998, there were rumors that China would weaken its currency (the yuan) against the U.S. dollar and many European currencies. This caused investors to sell stocks in Asian...
-
Purdue Co. (based in the United States) exports cable wire to Australian manufacturers. It invoices its product in U.S. dollars and will not change its price over the next year. There is intense...
-
Akron Co. needs dollars. Assume that the local one-year loan rate is 15 percent, while a one-year loan rate on euros is 7 percent. By how much must the euro appreciate to cause the loan in euros to...
-
With reference to Example 13, repeat the analysis after combining the categories below average and average in the training program and the categories poor and average in success. Comment on the form...
-
Mechanical engineers, testing a new arc-welding technique, classified welds both with respect to appearance and an X-ray inspection. Test for independence using \(\alpha=0.05\) and find the...
-
As discussed in Example 6.7, the following stream at \(100^{\circ} \mathrm{F}\) and 484 psia is to be separated by two distillation columns into the Products \(1-3\) in the following table. Two...
Study smarter with the SolutionInn App