(9) Give the relational algebra expressions for the queries formulated in step 2.This is my step 2: Queries in EnglishFind the name and city of all customersFind information of all orders placedFind orders of customer whose ID is 3Find reviews of all textbooksFind orders place by customer John DoeFind the name of customers whose order includes textbooks that exceed $20Find the customer ID of customers who ordered books written is Jane DoeFind the name of customers who have returned textbooksFind the city of customers who selected “FedEx” as the delivery methodFind the name of customers who have purchased and reviewed textbooks written by Jane DoeSELECT name, cityFROM customers;SELECT *FROM order_items;SELECT *FROM ordersWHERE CustomerID = 3;SELECT *FROM Book_Reviews;SELECT Orders.OrderID, Orders.Amount, Orders.DateFROM Customers, OrdersWHERE Customer.Name = ‘John Doe’AND Customers.CustomerID = Orders.CustomerID;SELECT Customers.nameFROM Customers, OrdersWHERE Customers.CustomerID = Orders.CustomerIDAND Orders.Amount > 20;SELECT Customers.CustomerIDFROM Customers, Orders, Order_Items, booksWHERE Orders.OrderID = Order_Items.OrderIDAND Customers.CustomerID = Orders.CustomerIDAND Order_Items.ISBN = Books.ISBNAND Books.Author like ‘%Doe%’;SELECT Customers.NameFROM Customers, Orders, Return_ItemsWHERE Customers.CustomerID = Orders.CustomerIDAND Orders.OrderID = Return_Items.OrderID;SELECT Customers.CityFROM Customers, Orders, DeliveryWHERE Orders.OrderID = Delivery.OrderIDAND Customers.CustomerID = Orders.CustomerIDAND Delivery.Method like ‘%FedEx%’;SELECT Customers.NameFROM Customers, Books, Book_Reviews, Order_Items, OrdersWHERE Customers.CustomerID = Orders.CustomerIDAND Orders.OrderID = Order_Items.OrderIDAND Book_Reviews.ISBN = Order_Items.ISBNAND Book_Reviews.ISBN = Books.ISBNAND Books.Author like ‘%Doe%’
Order a plagiarism free paper now. We do not use AI. Use the code SAVE15 to get a 15% Discount
Looking for help with your ASSIGNMENT? Our paper writing service can help you achieve higher grades and meet your deadlines.
Why order from us
We offer plagiarism-free content
We don’t use AI
Confidentiality is guaranteed
We guarantee A+ quality
We offer unlimited revisions