Transcript Data Modeling using XML Schemas

CS3431 –
Database Systems I
Project Overview
Elke A. Rundensteiner
CS3431
1
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
CS3431
2

Phase 0: Project Intent






(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 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 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 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


Phases
(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.
CS3431
3
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.
CS3431
4
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 ! )
CS3431
5