IST210 Proj #3: Due Apr. 28, 2:30PM

Part 1: Clean-Up & Data Population

Part 2: Scenarios & SQL Implementations

Part 3: Final Report & Presentation Slide (10 min)

Your final report should consist of the following:
  1. Cover page: List (1) project title, (2) project team name (i.e., Team A), and (3) member names
  2. Part 1: FINAL highlevel description of your project (1 paragraph)
  3. Part 2: FINAL E/R diagram
  4. Part 3: FINAL assumptions that you made
  5. Part 4: FINAL relational schema of all tables. If you didn't lose any points in Proj#2, just copy them over. Otherwise, fix them and mention what has been changed since Proj #2
  6. Part 4: THREE scenario descriptions
  7. Part 5: For each of three scenarios, show the implementation of each step in SQL and its results (i.e., screen-shot of both SQL and answers) after you run it in the Microsoft SQL Server 
  8. Part 6: Short description of WHO did WHAT role in your team (all members must participate in the project)
Your presentation slide should demonstrate what you did for Proj #1, #2, and #3 throughout the semester, including E/R, relational schema, data population, 10 queries, SQL implementation, and final scenarios. In past, students were very creative in doing the presentation (e.g., acting three scenarios with some costumes like a play while running SQL queries on the spot) !