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

Another question on Computers and Technology

question
Computers and Technology, 23.06.2019 09:30
You have been supporting csm tech publishing's windows server 2016 server network for over a year. the office has two windows server 2016 servers running active directory and a number of other roles. management has informed you that a small sales office is opening in the same building three floors up. the sales manager wants to install a sales application on a server located in the sales office. this server will have limited physical security because there's no special room dedicated for it, which means it will be accessible to non-it personnel and visitors. you're considering installing windows server 2016 server core on the new server because accessing its console regularly probably won't be necessary, and this server will be managed from one of the other csm tech publishing servers. what are the benefits and drawbacks of using server core for this branch office? what are some things you should do to set up this server management environment?
Answers: 1
question
Computers and Technology, 23.06.2019 14:00
Select the correct answer. andre was recently hired by an organization to check for system vulnerabilities. he is supposed to exploit these vulnerabilities and create a report on the extent of damage to which the system was susceptible. what position does andre hold in this organization? a. information security analyst b. information assurance manager c. penetration tester d. network security engineer e. chief information security officer
Answers: 2
question
Computers and Technology, 24.06.2019 01:00
Me if you do then you get 10 points and brainliest
Answers: 1
question
Computers and Technology, 24.06.2019 04:30
Fall protection, confined space entry procedures, controlled noise levels, and protection from chemical hazards are some of the things that contribute to a safe what
Answers: 1
You know the right answer?
Write relational algebra queries for the two specifications below using the relations also defined b...
Questions
question
Mathematics, 20.11.2020 22:40
question
Mathematics, 20.11.2020 22:40
question
Geography, 20.11.2020 22:40
question
Mathematics, 20.11.2020 22:40
question
Biology, 20.11.2020 22:40
question
Biology, 20.11.2020 22:40
Questions on the website: 13722363