Relational Data Base

A relational database is a collection of organized data that is usually saved on a server. The information that is needed is entered into tables produced by the program or application then the input data is stored in a centralized location. The Graphical User Interface or GUI organizes the information into tables that make it easy to read and input.   In the case of using a relational data base the GUI format allows point and click procedures that are located in common menu selection such as race, hair color, eye color, driver license state and so on. This type of database makes entering information easier than regular mainframe databases because of the ease of the interface.  The user s ability to click on tabs that bring down menus make entering data a systematic process and cuts down on possible mistakes.

The basic police headquarters computer stores such information on the network as, complete records, photographs, names, side and front mug shoot views, social security numbers, height , weight, ethnic back ground, eye color, date of arrest, date of birth and address. The information located on the local police server, state, FBI and CIA all provide a brief description of the crime they committed with details such as charges, court date, and complete description of the crime with previous criminal history including convictions. Updated products programmed to query, find, and display large amounts of information in a report format exceedingly advance these police databases. 

The scalability of the police reporting/tracking systems is very large. Some of the benefits of having a computerize reporting /tracking system are the capabilities of being portable using a laptop for patrol cars, remote access from places other than the office, and serviceability you can update records at any time. The modules located on most police reporting/tracking systems include arrest & booking, biographical information, arrest information, supplemental information, inmate medical screening, inmate property, inmate visiting tracking, inmate cash accounting, automated line ups, criminal warrants, photographs of subject, automated checks A&B for outstanding warrants, and automatic print outs.

References:

Foster, Raymond E.(2005) Prentice Hall. Pearson Education, Inc, Police Technology

National Crime Justice Reference Service source :www.NCJRS.gov