Problem 3 (50%): The following figure is part of a supermarket database, where amount is the dollar amount for each item. Specify the following queries in both relational algebra and SQL: 1)List the item names 2) List the item numbers, item names, and amount for each item that the customer “John Smith” as bought 3) List the names of all customers that have bought both “bread” and “milk” on the same day 4) For the customers who live in either Fullerton or Brea, count the number of customers in each city 5) List the names of all customers that have spent at least 300 dollars total es and quantity left for all items in the meat department CUSTOMER CNO FNAME ST ADDRESS LNAME CITY STATE ZIPCODE TRANSACTION C# ITEM# DATE AMOUNT ITEM ITEM NO INAME QUANTITY LEFT PRICE DEPARTMENT

"Get 15% discount on your first 3 orders with us"
Use the following coupon

Order Now