subject

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.

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 19:00
The fourth generation of computers emerged between 1970s and 1980s. which technological advancement brought about this generation of computers? which computer architecture was used most in this generation?
Answers: 3
question
Computers and Technology, 22.06.2019 19:30
Once the data center routes to the destination server that hosts the website, what's the next step in the internet process? user’s browser renders html code from destination server into web page request goes through router/model and isp request routed to nameserver and datacenter
Answers: 2
question
Computers and Technology, 23.06.2019 06:20
Which text function capitalizes the first letter in a string of text? question 10 options: upper capital first proper
Answers: 1
question
Computers and Technology, 23.06.2019 06:40
How many nibbles can be stored in a 16-bit word?
Answers: 1
You know the right answer?
Write relational algebra queries for the two specifications below using the relations also defined b...
Questions
question
Spanish, 24.10.2019 22:43
question
Social Studies, 24.10.2019 22:43
question
Biology, 24.10.2019 22:43
Questions on the website: 13722367