Crime Management System DBMS

A Crime Management System project developed using PHP and MySQL. This system is designed to streamline the process of registering, assigning, and managing crime cases within law enforcement agencies. The system includes three types of users — Admin, NCO (Non-Commissioned Officer), and CID (Crime Investigation Department) — each with distinct roles and permissions. The project demonstrates the use of a database management system (DBMS) to organize and manage crime cases in an efficient, structured way.

Table of Contents

• Project Overview
• Features
• Technologies Used
• Database Structure
• Usage
• Screenshots
• Future Enhancements

Project Overview

The Crime Management System allows different types of users to interact with crime cases as per their assigned roles:

• Admin: Manages users and the overall system configuration.
• NCO: Registers crime cases and assigns them to CID officers.
• CID: Views and updates progress on the cases assigned to them.

This project is built to support law enforcement agencies in managing and tracking criminal cases from registration through investigation, providing a structured way to handle sensitive data and case information.

Features

User Roles and Permissions

• Admin:
  • Can add, edit, and remove users (NCOs and CIDs).
  • Manages system-wide configurations and reports.
• NCO (Non-Commissioned Officer):
  • Registers new crime cases with essential case details.
  • Assigns cases to CID officers based on their availability and expertise.
• CID (Crime Investigation Department):
  • Views the cases assigned to them.
  • Updates the status and progress of each assigned case.

Case Management

• Record case details, including date, type, description, and involved parties.
• Assign and track case progress with case status updates.

Reports and Statistics

• Generate reports to review the status of cases by category, date, or officer assignment.
• Monitor case resolution rates and other performance metrics.

Technologies Used

• Frontend: HTML, CSS, JavaScript
• Backend: PHP
• Database: MySQL

Database Structure

The database is structured with tables to handle:

• Users: Stores information for admins, NCOs, and CID officers with role-based access.
• Cases: Stores case information, including case type, description, date, and status.
• Assignments: Manages case assignments between NCOs and CIDs, tracking case progress and updates.

For detailed information on each table and its columns, refer to the /db_schema.sql file or the documentation folder.

Usage

1. Admin Login: Log in as Admin to manage users and monitor system-wide activity.
2. NCO Login: Log in as NCO to register new cases and assign them to CID officers.
3. CID Login: Log in as CID to view assigned cases and update their status. Admin passowrd - admin123 nco and cid password - 1234

Screenshots

Example Screenshots

1. Login Screen

2. Admin Dashboard ![Admin Dashboard](

)

4. Case Registration Screen (NCO) ![Case Registration](

)

6. Assigned Cases View (CID)