|
|
| Customer |
|
Fulton County Sheriff's
Department, Jail Division (Atlanta, GA) |
|
|
| Project
Description: |
The Jail staff records
all activities that occur on a daily basis at any one of various
locations throughout the jail in a Log Book. There is a log
book used for each of 85-90 locations. Some examples of how
log books are used follows:
- Each time a visitor enters the jail, their name and
purpose of visit is recorded in a log book that is kept
in the lobby
- When shipments are received at the loading docks, all
pertinent information is recorded in a log book
- A log book is used to record an inmate's personal possessions
at the time they are booked in.
When a log book is full, it is filed away in a systematic
way and a new log book is started for that area. Areas may
keep log books for as little as 2 weeks or for up to several
years, depending on the use within that area. The jail keeps
log books on hand for a period of seven (7) years. The jail
has a current inventory of more than 1200 log books, with
150-200 being added each year.
|
| |
|
| Issues
with the previous system: |
When any situation
arises that requires the use of a filed log book, someone
must find the log book that pertains to that specific area
and the dates given. For example, a request for all visitors
to the administration offices on July 1, 1998 will require
the administrative sergeant (who is in charge of log books)
to manually look through all log books until he finds one
that matches the criteria.
If Sgt. Black needs to find a log book containing information
for all visitors to the administration area for July 1,
1998, he has to look at each log book to determine the area
that log book pertains to. When he finds a log book pertaining
to administration visitors logs, he must then look to see
if the start and end dates of the log book are relevant
to the dates given.
With more than 1200 books currently on hand, and many more
being added each year, it could take a lengthy amount of
time to investigate a situation like the one described above.
In addition, there is no logistical information pertaining
to the log books, such as how many log books belong to the
administration area, or how many books cover the date of
July 1.1998.
|
|
|
| My
Roles: |
As the only developer
for this application, I played all roles involved with the
development, including database developer, application
developer, Project Manager, Testing and Quality
Assurance. |
|
|
| What
I did: |
I modeled the
Sheriff's Department's current business processes involving
Log Book Tracking into a relational database schema. Using
SQL Server 2000, we then created a database using the working
relational model.
I created a console application using Visual Basic 6 that
would allow deputies and administrators to add, delete and
modify information stored in the database pertaining to
Log Books. When a deputy adds a log book to the system,
he indexes in on the binder of the book, and stores it on
a bookshelf.
In addition, I created a web application us Active Server
Pages (ASP) that allows deputies and administrators to search
for log books using the Fulton County Intranet.
|
|
|
| Skills
Needed |
- Relational Database Architecture
- Business Process Re-engineering
- SQL Server 2000
- Visual Basic 6 Application Development
- Visual Basic 6 Database Programming
- Active Server Pages (ASP)
- SQL, database programming
|
|
|
|
