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, 21.06.2019 22:50
Before you enter an intersection on a green light make sure
Answers: 2
question
Computers and Technology, 24.06.2019 12:00
An npn transistor is correctly biased and turned on if the a. base is negative. b. collector is negative. c. collector is positive with respect to the emitter and negative with respect to the base. d. collector is the most positive lead followed by the base.
Answers: 1
question
Computers and Technology, 24.06.2019 13:30
In the rgb model, which color is formed by combining the constituent colors? a) black b) brown c) yellow d) white e) blue
Answers: 1
question
Computers and Technology, 24.06.2019 19:20
Which command suppresses the visibility of a particular row or column in a worksheet?
Answers: 1
You know the right answer?
Write relational algebra queries for the two specifications below using the relations also defined b...
Questions
question
Chemistry, 03.04.2020 17:29
Questions on the website: 13722363