🏛️ Prison Management System (PMS)

📌 Overview

The Prison Management System (PMS) is a web-based application developed to manage prison operations digitally. It helps maintain prisoner records, staff roles, task assignments, medical histories, and visitor information in a secure and organized manner.

This project is built as part of an academic requirement using PHP and MySQL, following proper database design principles.

✨ Key Features

🔐 Role-based authentication (Admin, Officer, Medical Staff) 👤 Prisoner & cell management 📝 Task creation and assignment 🏥 Medical record management 🧍 Visitor logging system 🗄️ Normalized relational database

🛠️ Technologies

Frontend: HTML, CSS, Bootstrap Backend: PHP Database: MySQL Server: Apache (XAMPP)

⚙️ Setup

1. Clone the repository
2. Move the project to htdocs
3. Create database pms and import the SQL file
4. Start Apache & MySQL
5. Run: http://localhost/PMS

🎓 Academic Scope

Demonstrates:

EER to relational schema design Database normalization PHP backend workflow SQL joins and constraints

👨‍💻 Author

Md. Samsul Arefin Jafran Orni Mathew Rodrigues Shahriar Kabir Ayon

CSE370 Course Project

📄 License

Educational use only. Credit required for reuse.