Consider the following schema and:Write relational algebra expression for the following queries. Draw the query tree for 3,6 and 10.1. Find the product code, product name and price of all the products.2. Find the total number of orders of each customer.3. Find the total number of orders placed by customer “David”.4. Find the customer numbers who have not placed any order.5. Find the order number that includes all the products.6. Find the customer name and check number of payments that are made between 1-2-2020 and 28-2-2020.7. Find the cities where there is an office and customer as well.8. Display the products name along with product description.9. Find the employees who work in city “NY”.10. Find the payment amount of orders that has status “confirmed”. 6. Find the customer name and check number of payments that are made between 1-2-2020 and28-2-2020.7. Find the cities where there is an office and customer as well.8. Display the products name along with product description.9. Find the employees who work in city "NY".10. Find the payment amount of orders that has status "confirmed". Q) Consider the following schema.productlinesproductsorderdetails* orderNumber* productCodequantityOrderedpriceEach* productLine* productCodetextDescriptionhtmlDescriptionimageproductNameproductLineproductScaleproductVendorproductDescriptionorderLineNumberquantitylnStockbuyPriceemployees* employeeNumberMSRPlastNamefirstNameextensionordersemailcustomersofficeCode* orderNumbercustomerNumberreportsTojobTitleorderDatecustomerNamerequiredDateнеcontactLastNameshippedDatecontactFirstNamestatusphoneaddressLine1commentsofficescustomerNumberofficeCodeaddressLine2citycityphonestatepostalCodecountrysalesRepEmployeeNumber H+addressLine 1paymentsaddressLine2customerNumberstate* checkNumbercreditLimitcountrypostalCodepaymentDateamountterritoryWrite relational algebra expression for the following queries. Draw the query tree for 3,6 and 10.1. Find the product code, product name and price of all the products.2. Find the total number of orders of each customer.3. Find the total number of orders placed by customer "David".4. Find the customer numbers who have not placed any order.5. Find the order number that includes all the products.

Since you have not provided the data present in the table, I am providing the query based on certain…

Answered: products * productCode productlines…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Consider the following schema and: Write relational algebra expression for the following queries. Draw the query tree for 3,6 and 10. 1. Find the product code, product name and price of all the products. 2. Find the total number of orders of each customer. 3. Find the total number of orders placed by customer “David”. 4. Find the customer numbers who have not placed any order. 5. Find the order number that includes all the products. 6. Find the customer name and check number of payments that are made between 1-2-2020 and 28-2-2020. 7. Find the cities where there is an office and customer as well. 8. Display the products name along with product description. 9. Find the employees who work in city “NY”. 10. Find the payment amount of orders that has status “confirmed”.