Databases and Innovative
Systems for the community
1
DESIGN REVIEW
DECEMBER 11, 2009
Team Overview
2
New Team
Formed Fall 2009
Mission
“To assist non-profit, educational, and service
agencies with their database and software problems and
provide these organizations with new or revised
innovative solutions so that they can meet their
community needs.”
Team Overview - Project - Project History - Decision Process - Project Process –Testing – Demonstration - Project Timeline
Project(s)
3
Judicial Database System (JDS)
Partner
Tippecanoe County Probation
Department
Requirements
Remote Access
Security
User Capacity
Users
Parolee Officers throughout
Tippecanoe County
Project History
4
2002
• Access Deliverable
2005
• New Idea Old Project
2009
• PRESENT
Decision Process
JDS
Front Back
Middle End
End End
common
SSL
C# for GUI platform SQL
Protocol
.NET
Proposed System in 2005
Front End Middle Back End
SOAP
SQL
HTTPS
ADO
.NET
Axis
Microsoft
Client
Internet C#
Information Web
JavaJDS Port ASP
Server
GUI Client 443 (IIS)
.NET Service SQL Server
Database
New System Proposal
7
Front End Middle Back End
SQL
SSL ADO
.NET
Microsoft
Internet C#
Information Web
JDS- C# Port ASP
Server
GUI Client 443 (IIS)
.NET Service
MySQL
Then vs. Now
8
2005 2009
VERSION VERSION
System Progress: Modules
9
Front • Raw GUI Complete
End • 3 Tabs Refined
Judicial • SSL Connection with
Front End
Database Middle • Programmed in C#
Systems End • Generates queries for
MySQL database
Back • MySQL Server
End Database Populated
System Progress: Testing
10
Black box Testing (Functional testing)
technique whereby the internal workings of the item being
tested are not known by the tester; the tester only knows
the inputs and what the expected outcomes should be
and not how the program arrives at those outputs.
http://www.webopedia.com/TERM/B/Black_Box_Testing.html
Test Criteria
Results & Solutions
INPUT OUTPUT
Demonstration
11
Opening Page (Login)
12
Entering Login
13
Search Page
14
Doing a Search
15
Results Page
16
Profile Tab of Kip Scott
17
Legal/Court Info Tab of Kip Scott
18
Case Notes Tab of Kip Scott
19
Project Timeline
20
Fall Semester
21
Current
November 16, 2009
December 4, 2009
December 11, 2009
October 31, 2009
Jan 2010 April 2010
Profile Tab Legal Tab Case Notes
Tab Complete
ALPHA
Complete Complete
RELEASE
Alpha Release
22
Deliverables:
First 3 Tabs-
Profile tab
Legal/Court Info Tab
Case Notes tab
Search Capabilities
To Be Delivered:
Via Web Server
Connection
Spring Semester
23
Beta Release
Refine raw tabs
Finish C#
Include modification capabilities
Manage Alpha Release findings
Overall Testing
Jan. 2010 Feb. 2010 March 2010 April 2010 May 2010
Reports &
Drug Screen & Reassessment Modifications,
Probation Deliver Beta
Assessment & Receipts Alpha Release
Terms and Release
Tab Tab findings and
Progress Tab Testing
Conclusion
24
Review
Questions