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
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