Semester Project

Team Project	During the first few weeks of class, you will be assigned to a team. Your assignment is to select a problem that can be solved using a database approach. This may be a real problem, or you may use ideas from the text book to create your own problem to solve.
Due Date & Time	During the last week of class, at the time of your presentation
Individual or Team	Click here for guidelines to teamwork.
Content	1) Executive Overview including description of organization, problem your system solves, current status of project, and next steps. Click here for an example. 2) Diagrams:  E-R Diagram (or Class Diagram) – First draft 2.5) Critique ER - individually 3) Relational Schema with keys indicated 3.5) Critique Relational Schema - individually 4) Data Dictionary  If Datawarehouse, DD must include the mapping of the destination to the source as well as the time interval that data will be extracted. List containing description of each Form (program) CRUD Matrix  (Forms versus Tables Matrix) 5) Complete listing of populated tables    Print out of Forms and Reports (with Data entered) and a narrative of each (similar to a simple User Guide)     Queries (at least one using 2+ tables) plus narrative describing the purpose of each query Appendices: Minutes of Meetings, GANTT and/or PERT chart printed in MS-Project (reduced to 1 page) Additional items you wish to include.
Format	Cover page containing all team member names Table of contents with page number references Each page numbered, Tabs for each section Consistent document format, including font, font size and paragraph style, References Guidelines for Oral Presentation
Evaluation Form	Peer Evaluation (for other groups),   Self Evaluation (for yourself and your teammates)

 DUE DATES (Fall/09):  1) August 28 2)  August 30  2.5) September 2 3) September 10, 3.5) September 17 4)  September 31, 5)  End of Semester

Note that all assignments are to be done in group and posted on Moodle’s discussion Forum (one per group) except for 2.5 and 3.5