140 likes | 368 Views
Narcotics Database. Outline. Who am I? Issue Background Current Proposed System Market Competition Pros & Cons Questions Resources. Who am I?. CS Senior Naval Safety Center NROTC. Issue. Tracking narcotics transactions. Background. Need reports Allocate assets Safer streets
E N D
Outline • Who am I? • Issue • Background • Current • Proposed System • Market • Competition • Pros & Cons • Questions • Resources
Who am I? • CS Senior • Naval Safety Center • NROTC
Issue • Tracking narcotics transactions
Background • Need reports • Allocate assets • Safer streets • Fairfax County has approx 528 cases open • Case life • Couple of weeks to years
Background Cont’d • 3.5 g Cocaine $150 • Example Case • 5 months • 1st month • 7 g = $225 • 2nd month • 42 g = $1500 • 3rd month • 70 g = $2000 • 4th month • 73.5 g = $2600 • 5th month • 1 kilo = $28000 Grand Total = $34325
Current • Homemade using Microsoft Access • SLOW!!!! • One at a time
Proposed System • Database system • SQL? • Tracks cases • Generates Reports
Pros and Cons Pros Cons • Generates needed reports • Increase in efficiency • Contributes to reducing crime • Possibility of hacking • Another system to be updated
Market? • Currently Fairfax County Police Department • Eventually Police Departments around country
Competition • LEA Data Technologies • Offers many different types of systems • None specific to Narcotics • CrimeSoft • All inclusive system • Generates reports • Too general
Resources • Sgt. Lon Anthony, Fairfax County Police Department • http://www.narcoticnews.com/ • http://www.leadatatech.com/ • http://www.crimesoft.com/