An important component of this course is
the design and development of a database application of your choosing as
part of a team.
Implementation steps include (a) select an application topic and
then analyze the requirements
of your application and represent them using a conceptual model (ER model), (b)
translate the ER schema into a relational schema, (c) analyze the relational
schema using normalization theory, (d) represent the relational schema in SQL
DDL, and test the SQL DDL statements against a database such as Oracle/mySQL
for correctnes,s (e) analyze the operations you would like to support for your
application, (f) represent these operations in SQL DML for correctness, and
(g) build an interface for the end-user to use the database.
You will receive additional points
by investigating and applying advanced
SQL aspects like triggers, stored procedures, views, etc.
The project will be evaluated based on (a) creativity of envisioning a
database application (b) your mastery of the course materials (c) your
comprehsensive testing of your system, and (d) your focus in investigating
additional topics outside of class. Additional points will be given for
investigating topics outside of class, and/or adding advanced features to your
system.
The project will be done in teams of three, and will be submitted in
several phases.
The overall plan, including description of phases,
is given below.
Phase 0: Project Intent:
Phase 1: Conceptual Design :
INSTRUCTIONS
Phase 2: Final Design: Conceptual+Logical:
INSTRUCTIONS
Phase 3: Operational Design:
INSTRUCTIONS
Phase 4: Proof-of-Concept:
INSTRUCTIONS
Phase 5: Full Application:
INSTRUCTIONS
Precise dates may still be adjusted
as announced in class:
E-copy submission Via MyWPI Due Fri, Nov. 2nd BEFORE class time via mywpi.
Follow details as discussed in class and noted on MyWPI.
If there are team reassignments that affect your team, please talk to CS3431 staff.
E-copy submission Via MyWPI Due thursday, Nov 8th, 2012 at 3pm.
Hardcopy submission Due in class on Thursday, Nov 8th, 2012.
E-copy submission Via MyWPI Due Thursday, Nov. 15th, 2012 at 3pm.
Hardcopy submission Due in class on Thursday, Nov. 15th, 2012 at 3pm.
Hardcopy submission Due in class on Friday, Nov. 30th, 2012 at 3pm.
E-copy submission Via MyWPI Due Friday, Nov. 30th, 2012 at 3pm.
No E-copy submission Via MyWPI is required for this phase.
Instead come to the TA office hour during week of 3rd - 7th of Dec, 2012,
or make an appointment with the TA.
And, bring hardcopy submission with you to your life demonstration,
to get it checked off !
E-copy submission Via MyWPI Due Thursday, Dec 13th, 2012 at 3pm.
You will give your life project demonstration on
Thursday, Dec 13th, 2012.
Bring hardcopy submission of Full Project Report
to instructor at the start of your CS3431 demonstration.