This Project mainly focuses on creating a DataBase for each prison in India. This DataBase holds data related to all the prisons and prisoners in it. We have 11 tables in this database which holds information of prisons, prisoners, deaths in prisons, staff, ipc sections, budgets etc.
Step 1: Install PgAdmin and open it in your Desktop.
Installation Guide https://www.pgadmin.org/
Step 2: Create a Database and right click you get restore option
Step 3: Unzip DataBase_backup3.tar file in Data Base BackUp File and upload it as shown below
Step 4: Your DataBase is Ready.
Step 1: Download Streamlit_Framework_Setup folder
Step 2: Open Command Prompt/Terminal in your desktop. Use command cd file-path(your file path)
Step 3: Next write the following command pip install -r requirements.txt
Step 4: Next open the connection.py file and change the credentials
Step 5: Run pip install streamlit
Step 6: Finally run the following command streamlit run main.py for mac py -m streamlit run main.py for windows
Step 7: Your Web Application is opened in a new chrome tab
Link to the Prison DataSet: https://www.kaggle.com/datasets/rajanand/prison-in-india?select=Jail+wise+population+of+prison+inmates.csv