query_hw.docx
Describe at least 5 "interesting'' queries in plain English. Note: do not implement these queries in SQL at this stage. Describe in detail what each query will return (include mathematical notation if relevant) and justify each query: how will it be useful for your client? Interesting queries should be both helpful to your client and demonstrate skill with SQL (going beyond basic conditional selects). Ideally, queries should apply management theories and/or methods, for example: computing Economic Order Quantity, Retailer Discount Values, Forecasting Demand, Lead Time, Profit, Inventory using Exponential Smoothing, Ranking employees by a productivity metric, Ranking products by profitability, fitting stochastic models for expected demand, scheduling employees or transportation, locating events (to minimize travel time), ranking advertisements based on return on investment, displaying seasonal trends, computing correlations, setting warranty periods based on Mean Time Between Failures. etc. Your queries should demonstrate the power of your database to answer questions of value to your client. Each query must be justified in terms of organizational needs and described in plain text (not SQL yet!).
kevin
0
