Computers and Technology
Computers and Technology, 05.12.2019 22:31, pado4776

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.

answer
Answers: 3

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 10:20, alcantar28eduin
Print "usernum1 is negative." if usernum1 is less than 0. end with newline. convert usernum2 to 0 if usernum2 is greater than 10. otherwise, print "usernum2 is less than or equal to 10.". end with newline
Answers: 3
image
Computers and Technology, 22.06.2019 22:30, MoneyMike42
Alex’s family members live in different parts of the world. they would like to discuss the wedding plans of one of their distant relatives. however, alex wants all the family members to talk to each other simultaneously so that they can make decisions quickly. which mode of internet communication should they use? a. blog b. email c. wiki d. message board e. instant messaging
Answers: 2
image
Computers and Technology, 23.06.2019 03:30, 890777
In vista and windows 7, the appearance and personalization option allows you to change the
Answers: 1
image
Computers and Technology, 23.06.2019 14:00, uday50
Select the correct answer. a company is currently focusing on creating specific management goals for itself. which level of maturity is the company demonstrating under the sse_ccm framework? a. performed informally b. planned and tracked c. quantitatively controlled d. well-defined e. continuously improving
Answers: 2
Do you know the correct answer?
Write relational algebra queries for the two specifications below using the relations also defined b...

Questions in other subjects:

Konu
Geography, 01.10.2019 20:00
Konu
Computers and Technology, 01.10.2019 20:00