Final Project Information

Team Name ______

Team members:______

You will need to demonstrate your project to me

All group members must be present for the demonstration.

You should have your folder/notebook with you when you come for the demonstration so that I can see what is missing.

I will schedule an hour for each group but it may not take that long.

When you run your project

____ You will need to show working data entry forms that I can plug data into

____ You will need to produce a report which includes the data I added, modified or deleted

____ You will need to write (or run a previously written) query to read, insert, update or

delete data from your database (CRUD)

In addition to demonstrating the project, you must include the following in your folder or notebook all graded or ungraded work relating to the project ( list will be updated as needed)

____ March 21 project entities, attributes, input documents/forms, reports, model, assumptions

____ March 23 group members and project preference

____ Questions

____ April 4 data dictionary

____ April 6 cross reference chart

____ April 6 modified Semantic Object Model

____ Final Semantic Object Model

_____Printouts of the structure of your relations

_____Printout of the relationships in your database

_____Printouts of any SQL queries you used

_____Printouts of any VB, Java Script or other code used

_____Printouts of any Triggers or Stored Procedures you used

_____Sample printouts of the reports your database can produce

_____A User Manual - telling the client how to use the database

_____Test Plan -- showing how you tested (or how the client can test your database)

_____ A CD or Zip disk with a backup copy of the database on and directions for restoring it.

Please also include any scripts you use(d) to create the database, query it, produce reports from it or otherwise interface with it.


CS 474

Checklist for Team ______

Team Members ______

Possible Points / Tasks / Earned Points
20 / I was able to restore database from disk turned in
(15 directions given and it works; 10 difficult; 0 can't
20 / All 4 members present for the demo
20 / SQL database exists in back of front-end
20 / final SOM turned in corresponds to final database
20 / Database domains appropriate
20 / Table structures printed out
20 / SQL Server queries used printed out
20 / Description of front end used – including steps and/or code
20 / Appropriate reports can be produced
20 / Prior graded/commented work turned in
20 / Completed Evaluations
30 / Data entered in form was reflected in SQL server db
20 / User manual
20 / Test Plan
10 / Check list checked off
300

CS 474

Group Work Evaluation

Your Name

You worked as a team with several other people to create your semester group project in this class. This is your opportunity to evaluate the contributions of yourself and the others in your group, as well as to reflect on the group interaction. Put the names of your fellow team members below and fill out the chart as to the amount of contribution of each. Then complete the final section regarding the group dynamics. As stated in the assignment, this is your opportunity “to recognize or penalize other group members based upon their contribution to the group’s success.”

Individual Contributions

What was the level of contribution to the finished product, both report and presentation?


Group Dynamics

Place an X on the point where your group fell on each continuum:

worked well ------couldn’t work together at all

perfect accord ------didn’t get along at all

high productivity ------NO product possible

What was the BEST thing about this group experience?

What was the WORST thing about this group experience?


Abbreviated Summary of Project Requirements

Working SQL Server database which satisfies the client’s needs.

with tables

data

relationship diagram

Demonstrate ability to backup and restore a SQL server database

Front end which presents user with a helpful interface

Interface components

Forms

Reports

Description and code or screen captures of front end development (creation)

SQL Queries which work on the database

for insertion

for update

for retrieval

for deletion

User’s Manual

Test document

All graded/commented assignments relating to the project (see first page of this document)

Print out of the table structure

You want to have print outs (screen captures are fine) of the relationship diagram

Print out the queries that you have saved and included with the database

Print out any triggers and/or stored procedures that you have