Computers and Technology
Computers and Technology, 24.12.2019 19:31, perez120

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: 2

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 11:00, paigesyring
How does a policy manual an organization? a. it boost productivity. b. it create awareness in employees about the organization’s values. c. it employees achieve targets. d. it safeguards the organization from liabilities.
Answers: 1
image
Computers and Technology, 23.06.2019 17:00, solizpaco7124
1. which of the following is not an example of an objective question? a. multiple choice. b. essay. c. true/false. d. matching 2. why is it important to recognize the key word in the essay question? a. it will provide the answer to the essay. b. it will show you a friend's answer. c. it will provide you time to look for the answer. d. it will guide you on which kind of answer is required.
Answers: 1
image
Computers and Technology, 24.06.2019 07:00, Dkhaurithompson
Selective is defined as paying attention to messages that are consistent with one’s attitudes and beliefs and ignoring messages that are inconsistent.
Answers: 1
image
Computers and Technology, 24.06.2019 07:20, stephanieyingepbtcf8
3pointsyou've found an image you want to insert into your slide presentation. youwant to make the image look more gray so that it looks like an older imagewhat would you need to adjust? 0.00o a. sizeo b. hueo c. contrasto d. tones
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: