GENERAL INFORMATION
This database dubbed the Inmate Management Information System (IMIS) is necessary for the smooth and efficient management of the Two Thousand plus (2000+) criminal population incarcerated within five (5) locations managed by the Guyana Prison Service (GPS). The IMIS will replace the current inefficient paper based system that are prone to mistakes, and will provide faster reporting and information retrieval as well as more precise data management.
In order to experience The IMIS Application as we intended. You need to follow these Steps:
Ensure that your System have Apache, Mysql and PHP and "phpMyAdmin" installed:
-
Linux OS LAMP Server Installation then install phpMyAdmin
-
Windows OS WAMP Server Installation then install phpMyAdmin
-
Mac OS MAMP Installation then install phpMyAdmin
Install Git to complete the following tasks
Debian-based Distributions: Open Terminal and paste the Command
sudo apt update
sudo apt upgrade && apt dist-upgrade
sudo apt install gitclick here Git for Windows
click here Git for Mac
After installing Git Navigate to your MySQL Server's Default Data Folder
-
Linux OS File Path:
/var/www/html -
Windows OS File Path
c:\wamp\wwwORc:\wamp64\www -
Mac OS File path
/Applications/MAMP/htdocs
After success Ensure that you are in the MySQL Server's Default Data Folder for your Operating System. Then Install CSE2102--Sonderlude using git clone Command
Open "Terminal" with the "MySQL Server's Default Data File Path", and then copy & paste the Command
git clone https://github.com/seraph2girl/CSE2102--Sonderlude.gitOpen "Command Prompt (cmd)" with the "MySQL Server's Default Data File Path", and copy & paste the Command
git clone https://github.com/seraph2girl/CSE2102--Sonderlude.gitAfter installing "CSE2102--Sonderlude" successfully. Open the "CSE2102--Sonderlude" folder and Navigate to the data folder there you will see GPS_IMIS_Creation.sql:
Now open the "Command Prompt" or "Terminal" to access the mysql database
Type the following command to access MySQL Database. Provide User Name & Password
mysql -u username -p your_passwordNavigate to the "Notification Tray" and click on the WAMP icon
- Open the "GPS_IMIS_Creation.sql" file, then "Copy & Paste" the SQL syntax into the mySQL Console
After creating the "GPS_IMIS" Database follow steps:
- Open your "Web Browser" and type
localhost/CSE2102--Sonderlude/
- Navigate to connection.php and fill in your mySQL Credentials
- After providing your credentials. The Register Page for Administrator should only appear, because the Database is empty and Only a "Administrator" must first be present.
Optionally you can use our predefined GPS_IMIS: Users" to explore the GPS_IMIS Database with Different Privileges.
-
Navigate to file path
CSE2102--Sonderlude/data/GPS_IMIS_Characters.sql. Then Copy & Paste the SQL Code in the the MySQL Console
Our Database cannot survive in the real world if it was not Secure. Due to the demanding requirements The GPS_IMIS supports:
-
User Constraint: A User with 'Reception Privileges' cannot access the 'Administrator Page' to gain Administrator Privileges even if they know the 'file path'. Attempting to do so, the User will be redirected to their 'Initial Page with their Default Privileges'.
-
Password Encryption: All GPS_IMIS User's password will be Encrypted with a 'Hashed Password'.
The GPS_IMIS interface is "straight forward", hence no learning curve needed to use the GPS_IMIS.
By default the GPS_IMIS was created to utilize its resources 'locally', hence no 'Internet Connection is Needed' and that also play a role in 'Security'.
| Name | Position | Contact |
|---|---|---|
| Towana Wilson | Project Leader/ Database Administrator | https://github.com/seraph2girl |
| Kieron Abrigo | UI Developer | https://github.com/KieronShadow |
| Lo-Reese Cummings | QA Leader | https://github.com/Lo-ReeseCummings |
| Wilton Lawrence | Back-End Developer | https://github.com/Wilton2 |
| Jornel Yearwood | UI Developer | https://github.com/Jornelyearwood |