EVERWIN VIDHYASHRAM

SENIOR SECONDARY SCHOOL

COMPUTER SCIENCE PROJECT

TOPIC : CRIME RECORD MANAGEMENT

SYSTEM

NAME: S.SRIVATSA
STANDARD : XII
SECTION: METICULOUS

1
 CERTIFICATE

This is to certify that the project entitled

“CRIME RECORD MANAGEMENT” Is a
record
of bonafide work carries out by
“SRIVATSA.S” of
XII-METICULOUS. In partial Fulfilment of
the requirements in COMPUTER SCIENCE
prescribed by CBSE for CBSE BOARD 2024
– 2025 in school EVERWIN
VIDHYASHRAM
SENIOR SEC.SCHOOL, Kolathur, Chennai-
600099

DATE: PRINCIPAL

INTERNAL EXTERNAL

2
 DECLARATION
I hereby declare that this project report titled “Crime
Record Management System” is an original work
carried out by me under the guidance of [Teacher’s
Name]. The information presented here is true to the
best of my knowledge.
[Your Name]
Class XII
Roll No: [Your Roll Number]

3
 ACKNOWLEDGEMENT

We wish to express our sincere thanks to

Ms.
Vidhya Hari, Principal of EVERWIN
VIDHYASHRAM SENIOR SEC.SCHOOL,
Kolathur , Chennai for guiding us to cause
the successful outcome of this project
work.
We wish to express our deep & profound
sense of gratitude to our guide/teacher
SUMALATHA.S
(Comp. Sc), for her expert help & valuable
guidance, comments and suggestions. We
also place on record, our sincere gratitude
to one and all who, directly or indirectly
have lent their helping hand in this venture
4
INDEX

5
 INTRODUCTION
The "Crime Record Management System" is a Python-based
application designed to streamline the process of recording
and managing crime-related data. It facilitates efficient
storage, retrieval, and management of criminal records,
aiding law enforcement agencies in their operations. The
crime record management system can help in storing the
records related to the criminals, cases, complaint record, and
case history and so on. This can allow a person to enter or
delete the records if necessary. All these records can be
maintained in a single database. Security is maintained so as
to ensure that only the authorized users will have access to
the system. This application will be one of the useful projects
that the police can rely on. This website can help in getting
the information of the criminals of many years back. It can
also help in minimizing most of the work of the police. Crime
has always been a key concern for governments and
societies. The management of crime-related data is crucial for
ensuring justice and maintaining law and order. In traditional
systems, records are stored manually using paperwork. This
method is error-prone, slow, and difficult to manage.
A Crime Record Management System (CRMS) provides a
digital solution to store, retrieve, and update crime records
quickly and securely. By implementing this system in Python,
students can explore the real-world application of
programming in governance and public safety.
The goal of this project is to:

6
 • Minimize human error
• Store large volumes of data efficiently
• Retrieve case details using simple queries

OBJECTIVE
• To design and develop a software system for managing
crime records.
• To enable efficient storage and retrieval of FIRs and
criminal data.
• To provide a user-friendly interface for managing
records.
• To reduce manual paperwork and enhance data security.

EXISTING SYSTEM
In the current manual system, crime records are stored in physical
registers or in spreadsheets with limited access. This method is prone
to errors, data loss, and inefficiencies in record retrieval. It is also
difficult to ensure data security and maintain updated information.

PROPOSED SYSTEM
The proposed Crime Record Management System aims to
overcome the shortcomings of the existing system by
implementing a computerized database application using
Python and MySQL. It will allow users to:

7
 • Register FIRs and complaints
• Add criminal records
• Update or delete entries
• View reports and search for data using filters
The system will ensure data integrity, improve access speed,
and provide security using user authentication.

Introduction to Python
Python is a high-level, interpreted programming language
known for its simplicity and readability. It supports multiple
programming paradigms and has a vast standard library,
making it suitable for various applications, including web
development, data analysis, artificial intelligence, and more.

Advantages of Python
• Easy to Learn and Use: Python's syntax is
straightforward, making it accessible to beginners.
• Extensive Libraries: A rich set of libraries and
frameworks accelerates development.
• Cross-Platform Compatibility: Python programs can run
on various operating systems without modification.
• Community Support: A large community contributes to
continuous improvement and support.

8
• What is Python?

• Origin and Evolution

• Key Principles (e.g., PEP8)

• Python vs Other Languages

• Use Cases:
• Data Science
• Automation
• Web Development
• Artificial Intelligence
• Comparison Between Python and Other Languages:
Feature Python C++ Java
Syntax Easy Complex Moderate
Speed Moderate Fast Fast
Ease of High Low Moderate
Learning
Library Extensive Moderate High
Support

Introduction to the Project

The "Crime Record Management System" aims to digitize the
traditional method of recording crime data. By leveraging Python's
capabilities, the system allows for:
• Adding new crime records.
• Viewing existing records.
• Searching for specific records using identifiers.

9
 • Updating and deleting records as necessary.

Advantages of the Project

• Efficiency: Automates the process of managing crime
records.
• Accuracy: Reduces errors associated with manual
record-keeping.
• Accessibility: Enables quick retrieval of information.
• Scalability: Can be expanded to include additional
features like report generation and analytics.

Scope of the Project

While the current system handles basic CRUD (Create, Read,
Update, Delete) operations for crime records, future
enhancements could include:
• Integration with databases for persistent storage.
• User authentication for secure access.
• Advanced search and filtering options.
• Analytical tools for crime pattern analysis.

10
Hardware and Software Requirements

Hardware:

• Processor: Intel Core i3 or higher

• RAM: 4 GB or more
• Storage: 500 MB free space

Software:
• Operating System: Windows 10 or above
• Python 3.10+
• MySQL Server
• MySQL Connector for Python
• Tkinter (for GUI)
• Operating System: Windows/Linux/MacOS
• Python 3.x
• Text Editor or IDE (e.g., VS Code, PyCharm)

11
 SYSTEM DESIGN

Database Design:
• criminals (id, name, age, crime_type, address,
date_of_crime)
• firs (fir_id, complainant_name, complaint_details,
date_of_filing, officer_in_charge)
User Interface Design:
• Main Menu
• FIR Entry Form
• Criminal Record Entry Form
• Report Viewer
• Search Feature

MODULES DESCRIPTION
• 1. Login Module:
Ensures only authorized users access the system.

• 2. FIR Management:
Allows entry, update, and viewing of FIRs

• 3. Criminal Records:
Manages details of criminals including type of crime and
investigation status.

12
 • 4. Reports:
Generates reports based on crime type, date, etc.

• 5. Search Module:
Enables searching of records using filters.

Source Code and Output Screens

Source Code:
python
CopyEdit
import os

def add_crime_record():
with open("crime_records.txt", "a") as file:
case_id = input("Enter Case ID: ")
name = input("Enter Criminal Name: ")
crime = input("Enter Crime Type: ")
status = input("Enter Case Status (Open/Closed): ")

13
 file.write(f"{case_id},{name},{crime},{status}\n")
print("Crime record added successfully.\n")

def display_crime_records():
print("\n--- All Crime Records ---")
print("Case ID\tName\tCrime\tStatus")
try:
with open("crime_records.txt", "r") as file:
for line in file:
data = line.strip().split(",")
print(f"{data[0]}\t{data[1]}\t{data[2]}\t{data[3]}")
except FileNotFoundError:
print("No records found.\n")

def search_crime_record():
search_id = input("Enter Case ID to search: ")
found = False
try:
with open("crime_records.txt", "r") as file:
for line in file:
data = line.strip().split(",")
if data[0] == search_id:
14
 print("Record Found:")
print(f"Case ID: {data[0]}, Name: {data[1]}, Crime:
{data[2]}, Status: {data[3]}")
found = True
break
if not found:
print("Record not found.")
except FileNotFoundError:
print("No records to search.")

def menu():
while True:
print("\n--- Crime Record Management System ---")
print("1. Add Crime Record")
print("2. Display All Records")
print("3. Search Record by Case ID")
print("4. Exit")
choice = input("Enter your choice: ")
if choice == "1":
add_crime_record()
elif choice == "2":
display_crime_records()

15
 elif choice == "3":
search_crime_record()
elif choice == "4":
print("Exiting system.")
break
else:
print("Invalid choice. Try again.")

menu()

CODING (Python with MySQL)

import mysql.connector
from tkinter import *

def connect_db():
return mysql.connector.connect(
host="localhost",
user="root",
password="yourpassword",
database="crime_db"
)

16
def add_criminal(name, age, crime_type, address, date):
conn = connect_db()
cursor = conn.cursor()
cursor.execute("INSERT INTO criminals (name, age,
crime_type, address, date_of_crime) VALUES (%s, %s, %s, %s,
%s)",
(name, age, crime_type, address, date))
conn.commit()
conn.close()

# GUI Skeleton
root = Tk()
root.title("Crime Record Management")
Label(root, text="Crime Record Management System",
font=("Arial", 18)).pack()
root.mainloop()

17
OUTPUT

Main Menu

Adding a New Criminal Record

18
Viewing All Records

Searching Record by Crime

19
Updating a Record

Deleting a Record

20
Exit Message

ADVANTAGES
• Fast and efficient record management
• Easy data retrieval and searching
• Better data accuracy and integrity
• Secure access with login feature

14. LIMITATIONS
• Limited to local system unless hosted on a server
• Basic GUI may not suit all users
• No real-time crime reporting

21
15. FUTURE SCOPE
• Integration with national crime database
• Addition of facial recognition using OpenCV
• Web and mobile-based version
• Role-based access for officers

22
12. Conclusion of the Project
The development of the "Crime Record Management System"
has provided insights into file handling, user input validation,
and basic data management using Python. The project
underscores the importance of digitizing records for
improved efficiency and accuracy in law enforcement
agencies. This project has successfully demonstrated how
crime records can be efficiently managed using a
computerized system. It provides a scalable foundation that
can be extended with advanced features and integrated into
real-world applications.

23
13. Bibliography
• Python Official Documentation:
https://docs.python.org/3/
• W3Schools Python Tutorial:
https://www.w3schools.com/python/
• GeeksforGeeks Python Programming:
https://www.geeksforgeeks.org/python-programming-
language/
• CBSE Computer Science Textbook
• Crime-Record-Management-System Using Python-
Tkinter

24