Database system class Provide relational algebra EXERCISE queries CUSTOMER, Type

Question

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

Explanation / Answer

1. Find the best and worst selling products

2. Find average selling products, ordered by the average number of units sold

  

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.