Project for - CMP320 - Database Systems
Project Duration - October-December 2017
Collaborators - Gehad Aboarab, Ahmed Abou Bakr
A system built using the Java Swing library, and Oracle SQL as the database for the system.
Our application is suitable for police stations of various sizes, with functionalities for multiple departments within one police station. The database application also contains support for prisons within the law enforcement system, and also storage options for the criminals sent to prison.
Our application employed a 3-tiered architecture, consisting of the User Interface (/UIP) Application Logic (/ALP) and the Database System (/DSP) layers
People working in various positions within the agency. Examples include - Prison guards, Police cops, Clerical staff, etc.
Physical buildings where employees work. Consists of various departments that operate under it.
Areas where prisoners are stored. Consists cells of different types and sizes, and can store any number of prisoners.
People caught by the Law, and are staying in the prisons, until their sentenced period is over.
- Java 8
- Oracle SQL Server
- Any Java IDE (Netbeans 8.2 was used in this project)
- Clone the repo by using the following command
$ git clone https://github.com/hussu97/LawEnforcementSystem.git
$ cd LawEnforcementSystem- Open the project in your Java IDE
- Change the following details from the link in the OracleJDBCConnection.java file
public static String CONNECTION_STRING = "jdbc:oracle:thin:username/password@domainname:port:orcl";- Build and Run your project
- View, edit and remove employees
- View, edit and remove stations and sub-stations
- View, edit and remove prisons
- Add or discharge criminals from prisons, or move them to different cells
