1 / 21

Judicial Database System Design Review Summary

Comprehensive overview of the DISC design review meeting on October 9th, 2011 for the innovative Judicial Database System project, detailing project progress, partner needs, design specifications, and future plans.

randi
Download Presentation

Judicial Database System Design Review Summary

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Database and Innovative Software in the Community (DISC) Design Review October 9th, 2011 ARMS 1098B 1

  2. Agenda • The How & Why of the Project • Our Team’s Progress • A Live Demo • Plans for Future Teams 2

  3. Our Project Partner • The Tippecanoe County Probation Office • Manages parolees in Tippecanoe county • Tracks parolees as they complete their sentence • Keeps records of current/past parolees 3

  4. Their Needs • An accessible way to store probation records • A simple way to create/update records • An easy way to print standard reports • A system that is highly secure 4

  5. Judicial Database Systems (JDS) 5

  6. Project Background • Project commissioned by Tippecanoe County Probation Department • Previous system was delivered in 2002 based on Microsoft Access • New version requested in 2005 • Current design proposed in 2009 6

  7. Design Requirements • Training requirements of parole officers require new system to be similar to the old system • Some requests made to improve business logic in specific ways • Must work with Probation Department’s software • Windows Server, ASP.NET, IIS, Microsoft SQL Server • Support Firefox 3 and up, as well as IE 7 and up 7

  8. JDS’s Current Design Front End Middle Back End SSL SQL ADO .NET Microsoft Internet Information Server (IIS) MySQL C# Web Service JDS- C# GUI Client Port 443 ASP .NET 8

  9. What was already done • Server backed mostly finished • Code already complete • 3 tabs mostly completed • Security • User authentication • SSL encryption 9

  10. Project Progress • All Tabs are now Functional • Completed every tab • Tabs account for most major functionality • Reporting is now working • Several Bugs have been fixed 10

  11. Drugscreen Tab • One of the most used tabs • One of the first we completed • Now Updates Correctly • Corrected the paging System 11

  12. Receipts Tab • Updated to Meet New Standards • New GUI was created • Functionality implemented • Field are now formated • Receipts is Now Linked to Profile Tab 12

  13. Probation & Terms Tab • Completely Redid the GUI • Functionality Completed 13

  14. Reports Tab • 19 Different Reports Now Printable • Prints in PDF format • Minor GUI Changes 14

  15. Mail Merge • Need to be Fixed at the Semester’s Start • One of the most commonly used/important features • Uses Database Fields to Create a Word Document 15

  16. Delete • Project Originally Had No Way to Delete Records • Delete does a hard Delete of Database Records • Requires Multiple Confirmations • Avoids unintentional deletion • Has Error Reporting in Case of Failure 16

  17. Minor Changes/Bug Fixes • Case Notes Changed to be More User Friendly • Search Now Checks All Fields • Power-User Privilege Removed 17

  18. Project Demo

  19. Discussion of future plans • Continue With Bug Fixes • Perform a test Delivery • Ensues smooth delivery process • Ensure the Project is Secure • Deliver to Project Partner • Maintain Project Through Beta 19

  20. Project Timeline • Week 1- 3, Final Prep • Bug Testing • Implement Error Report Tab • Week 4- 8, Planning/Delivery • Purchase SSL Certificate • Practice/Perform Delivery • Week 9-15, Service • Debug using partner feedback 20

  21. Questions? 21

More Related