Transcript Slide 1
Team Members: Advisors: Client: Andrew Bitterman CPRE Jennifer Sanders CPRE Dr. Mani Mina Chief Dan Losada Yin-Cheung Lo CPRE Royson Chong CPRE Dr. Tom Daniels Boone Police Department Abstract Evidence can be the key to convicting someone of a crime, or acquitting a person of charges brought against them. To make sure the evidence is carefully documented, we'll need to make a database application that will store all of the those options that evidence might have associated with it. The database application shall also be able to search for, report, and print information about any piece of evidence. The police department will be able to use this application via a network and search for information by storage location, victim's name, suspect's name, case number, date, or description. This will help out the police department by organizing the data and omitting some of the clutter paperwork may cause. INTRODUCTION Acknowledgement Technologies Considered Chief Dan Losada and Boone Police Department Database management software : Input hardware: • Digital signature pad Problem Statement • Structured Query Language (SQL) •Barcode Scanner Chain of custody for each evidence can determine if it is admissible in court. • Java Database Connectivity (JDBC) • Personal Digital Assistant (PDA) Boone police department needs to accurately keep track of this information. Fig. 1: Chain of Custody Testing Considerations The end product will be a database application that stores information about each evidence and officers will be able to update the item with each location is has been and who has handled it. No deletions will be allowed to insure records have not been modified. • Run tests on each module to ensure work function Operating Environment • Client shall test system with aid from team The application will run on a closed network on Windows XP platforms. • Test system upon adding any new modules • Test system upon complete integration ESTIMATED RESOURCES AND SCHEDULE Intended Users and Uses Personal Effort This application is intended for use by the Boone Police Department employees. Information will be printable for those outside the Department who need it. Jennifer Sanders Andrew Bitterman 149 hours 147 hours This application shall only be used for the tracking and inventory of evidence. Assumptions • Basic knowledge of Microsoft Windows XP. • Proper storage space for backup. • Only eight workstations running the program. Limitations • Compatible with Microsoft Windows XP. • Max response time must be less than ten seconds. • Must have backup and restore capability. Royson Chong Yin-Cheung Lo 153 hours 151 hours Financial Resources Poster, $50 End Product and Deliverables • Prototype • User manual • Application • Final program may be compatible with a signature pad and scanner PROJECT REQUIREMENTS Input Hardware, $285 Functional Requirements Measurable Milestones • Must be searchable be various fields stored • Project definition • End-product design • End-product implementation • End-product testing • End-product demonstration Design Objectives Design Constraints • Must be secure • Must be low cost. • Must be easy to use and maintain. • Must not require technical support. • Must be able to be backed up • Must be flexible in types of data Figure 2: Examples of Evidence Clockwise from top right: Cigarette butt, handgun, bullet. PROPOSED APPROACH AND CONSIDERATIONS Proposed Approach • Consult client to determine user requirement • Research current technologies • Develop system by separate modules • Run intensive tests on each level of integration CLOSING SUMMARY An effective and efficient evidence inventory and tracking system shall be developed for the Boone Police Department. It is our hope that this application greatly facilitates their work.