Question: Write relational algebra queries for the two specifications below using the relations also defined below: a. Retrieve the names of customers who have ordered parts

Write relational algebra queries for the two specifications below using the relations also defined below: a. Retrieve the names of customers who have ordered parts costing less than $150.00. b. Retrieve the names of customers and the partname of orders with a qty greater than 10. PARTS(Pno, Pname, Qoh, Price, Olevel) CUSTOMERS(Cno, Cname, Street, Zip, Phone) EMPLOYEES(Eno, Ename, Zip, Hdate) ZIP_CODES(Zip, City, State) ORDERS(Ono, Cno, Eno, Received, Shipped) ODETAILS(Ono, Pno, Qty) Where Qoh stands for quantity on hand and Olevel stands for (re)order Level. The P, C, E and O single letter prefixes for attributes refer to the parts, customers, employees and orders relations, respectively. The other attribute names are self-explanatory.

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!

I want to write Relational algebra queries for the two questions below using the tables defined below: a. Retrieve the names of customers who have ordered parts costing less than $150.00. b. Retrieve...

Write the relational algebra (as well as the SQL query) for the specification below using the relations also defined below: Retrieve the names of customers and the part name of orders with a quantity...

Consider the following MAILORDER relational schema describing the data for a mail order company. PARTS(Pno, Pname, Qoh, Price, Olevel) CUSTOMERS(Cno, Cname, Street, Zip, Phone) EMPLOYEES(Eno, Ename,...

Relational Algebra Question Can you please solve the question c and d? I know there is a policy but if you can solve them all much appreciated :) Can you please solve them step by step and write your...

Given the following relations: PARTS(Pno, Pname, Qoh, Price, Olevel) CUSTOMERS(Cno, Cname, Street, Zip, Phone) EMPLOYEES(Eno, Ename, Zip, Hdate) ZIP_CODES(Zip, City, State) ORDERS(Ono, Cno, Eno,...

the following relational algebra questions based on tables S1 and S2 (below) Question 1 What is the output of S1 S2 ? The row identified by sid 22 The rows identified by sid 31 and 58 The row...

What is the difference between MouseListener and MouseAdapter? [3 marks] (b) Via suitable HTML, the compiled version of the following Java code is presented to the appletviewer application: import...

13-31. Consider the SUPPLIER, PART, and SHIPMENT rela- tions and distributed database mentioned in the section on query optimization in this chapter. a. Write a global SQL query (submitted in...

answer the question clearly You are building a flight-control system for which a convincing safety case must be made. Would you assign the tasks of safety requirements engineering, test case...

Toyota Motor Manufacturing, U.S.A., Inc. On the Friday before the running of the 118th Kentucky Derby, Doug Friesen, manager of assembly for Toyotas Georgetown, Kentucky, Plant, was approaching the...

Do you think credit cards should be counted in the money supply? Why or why not? Support your argument by using the definition of money.

Olson-Jackson Corp. (OJC) is considering replacing a machine that was purchased only two years ago because of dramatic improvements in new models. The old machine has been depreciated straight line...

Because bonds can normally be issued only by large corporations, they are also known as Group of answer choices common bonds corporate bonds mortgage bonds industrial bonds professional bonds

please help ASAP TIP: Although the purchases and sales are listed in chronological order, Scrappers determines the cost of goods sold after all of the purchases have occurred. Required: 1. Compute...

3. What specific steps can you take to highlight and reinforce the public service contributions of those around you, including your peers, your supervisor, and your employees?

1. What is the public service mission of your agency or organization (or the organization that you hope to work for)? How does the organization benefit the people it serves? Think of specific...

3. Implement the action steps. After a reasonable time period, assess the results. Has your motivation increased? Has your interest, satisfaction, or performance improved? What else might you do to...