Relational algebra 1.

1. Identify customers who have not made a purchase in the last year. Display the customer name and email.

2. Identify products not purchased today at the Forest Hills store. Display the product name.

3. Identify products not available today at the Forest Hills store. Display the product name.

4. Create a receipt for the customer Joe Smith who just made a purchase at the Forest Hills store. Display the customer name, store, product purchased, price and calories.

5. Identify staff assigned to the Forest Hills store today. Display the staff name.

6. Identify products with more than 300 calories at the Forest Hills store. Display the product name, calories, price and store.

7. Identify customers with a reward card dollar balance less than $5. Display the customer name, reward card number, email and balance.

8. Identify the total sales by store today. Display three columns and one row for each store. The three output columns are store location, number of products sold and total sales in dollars. Use an aggregate function and grouping operation to answer this question.

9. Identify the total revenue by customer this year. Display three columns and one row for each customer. The three output columns are customer name, customer email and total sales in dollars. Use an aggregate function and grouping operation to answer this question.

10. Identify the number of active customers. Display one row with the number of active customers.

Customers(email, CCity, CStreet, CZip, CFirst, CLast)

Payment Method(email, CCard#, CCExp, CardName, Cash, paypal, rewards)

Store(StoreID, ProID,EpyID, SCity, SStreet, SZip.ProAvailability)

Products(ProID, ProName, ProInformation, Proquantity, StoreID, ProPrice, ProAvailablilty)

Employee(EpyID, StoreID, EpyCity, EpyStreet, EpyZip, EpyFirst, EpyLast, Salary, EpyDoB)

Puchase(ProID, Email, OrderID, totalprice, PurchaseDay,Qty)

Rewards( Email, balance, reedeem, coupons, CCard #)