CS3431

1
CS3431 Database Systems I

• Project Overview
• Elke A. Rundensteiner

2
One continuous course project

• Description Envision a database application, and
  implement it fully.
• Teaming Teams of 3 students each
• Grading Collect points over the phases

3
Phases

• Phase 0 Project Intent
• (due Thurs, Nov 1, midnight via mywpi)
• Decide on your team. Register your project via
  mywpi. Include (a) the people in team, (b)
  project title, and (c ) a description of 2 pages
  of your application requirements.
• Phase 1 Conceptual Design
• (due Wed, Nov 7th midnight via mywpi)
• Refine application requirements, represent as ER
  schema, note any constraints, discuss initial set
  of functions for users and administrators that
  will be supported.
• Phase 2 Refined Design
• (due Wed Nov 14th, midnight via mywpi )
• Represent refined ER schema, discuss refinements,
  translate the ER to relational, analyze the
  relational design using normalization theory,
  come up with DDL statements for the relational
  schema, test the DDL statements.
• Phase 3 Operational Design
• (due Wed Nov 28th, midnight via mywpi)
• Analyze the operations needed for your
  application, represent them in SQL DML, and test
  them using realistic data. Analyze interface
  requirements. Consider advanced technologies to
  improve your system, such as indexing or
  triggers.
• Phase 4 Proof-of-Concept
• (due Wed Dec 5th, midnight via mywpi and life
  demonstration)
• Create scaled-down single-table/query
  proof-of-concept system to prototype your chosen
  technology for connecting SQL backend with your
  frontend (GUI/webpage/command-line).
  Demonstration of your prototype to CS3431 staff.
• Phase 5 Complete Project
• (due Wed Dec 12th, midnight via mywpi plus life
  demonstration given on Thursday, Dec 13th)
• Complete the project, building of an interface
  for the end-user. Finalize final documentation
  and project report. Consider usage of additional
  technologies to improve your system, such as
  indexing, views, triggers, stored procedures.
  Demonstration of your project to CS3431 staff.

4
Phase 0 Getting Started

• Now
• Everyone t h i n k about PROJECT topic ! ! !
  ! ! ! !
• Solicit partners in class or on mywpi projects
  discussion board
• Subject PROJECT IDEA
• Member your interests and/or your skills
• Topic one-liner about a cool project topic you
  would like to find a partner for, any skills you
  would prefer your partner to have, etc.

5
Get Started Now

• Recruit project partners now (feel free to use
  mywpi to recruit partners)
• Jointly toss around ideas about winning project
  (make it one that interests you ! )