|
Project Assignment |
Due Date |
|
Team Assignment |
Sep 13 |
|
Project Proposal |
Sep 25 |
|
EER Design |
Oct 16 |
|
Project Presentations 1 |
Oct 20/23 |
|
PHP and MySQL Project Demo |
Nov 29 |
|
Project Presentations 2 |
Dec 4-6 |
Organization and Data Proposal: (3 page, written). Teams
will design and implement in MS Access a database for a real or fictitious
organization. As a group, agree on an organization and describe its business,
size, and their competition (state whether it is real or fictitious). Sketch
the organization's data needs in a format similar to that handed out for the
Tiffany Electronics Retailer. Don't start on EER or Relational structure until
I give feedback.
Please read: Team Problems: Advice
on coping with "hitchhikers" and "couch potatoes."
EER Design: (2 pages, written) Summary of database requirements, Simplified EER diagram (excluding attributes) with at least 10 entities and 10 relationships.
Project Presentation 1: (oral presentation, 10 mins powerpoint). Description of Client, EER design, relational schema, and propose five "interesting" queries that would be both helpful to your client and demonstrate your skill with SQL (going beyond simple joins and conditional selects). (present these in plain English and justify, don't implement yet in algebra or SQL). The most interesting queries apply IEOR quantitative analysis methods, for example: computing Economic Order Quantity, Retailer Discount Values, Forecasting Demand, LeadTime, 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), displaying seasonal trends, computing correlations, setting warranty periods based on Mean Time Between Failures. Your Queries should demonstrate the 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!).
PHP and MySQL Project Demo: Select one or two of the relations from your Project and design a web-based interactive query using it. in MySQL, design the table(s) and insert 10 tuples of sample data. Design a web page with embedded PHP that will allow online visitors to enter data and execute a query on this data. For example, consider a 'Product' table with prices. Your page might allow a visitor to enter a maximum limit price in a form, and your solution would return all products with price under than that maximum. Write a short summary of your design, including the MySQL table description and the embedded PHP sections, and include the URL of the web page. Submit this in hardcopy on the due date.
Project Presentation 2: (oral, 10 min using Powerpoint). Quick summary of info from Presentation 1 and PHP and MySQL Project Demo. Describe a working Access implementation of a SUBSET of your database: use screencaptures of Relationship View showing 4-10 relations, results from two interesting queries based on realistic examples of data values (please don't use joke names or data). Interesting queries should be both helpful to your client and demonstrate skill with SQL (going beyond simple joins and conditional selects). The queries should apply IEOR quantitative analysis methods, for example: computing Economic Order Quantity, Retailer Discount Values, Forecasting Demand, LeadTime, 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), displaying seasonal trends, computing correlations, setting warranty periods based on Mean Time Between Failures. Your Queries should demonstrate the the power of your database to answer questions of value to your client. Each query should be justified in terms of organizational needs.