Database system class

Provide relational algebra EXERCISE queries CUSTOMER, Type, Firstname, Lastname, Address, City) INVENTORY(TD, ItemName, Type, MadeInStore, SupplierName, DailyAverageSold, Price) ORDERS, Customer-FI, Item-FK, Quantity, Delivery:Date) 1. Find the best and worst selling products Best products sell more than 30 units on average, daily Worst product sell 10 units or less on average, daily Show attributes: item id, item name, daily average sold Find average selling products , ordered by the average 2. number of units sold Average products sell between 10 and 30 units, inclusive, per day on average Show attributes: item id, item name, daily average sold