JSS ACADEMY OF TECHNICAL EDUCATION
DBMS LABORATORY WITH MINI PROJECT (18CSL58)
INFORMATION SCIENCE AND ENGINEERING DEPARTMENT
MINI PROJECT SYNOPSIS
5th SEM B-SEC (B3 Batch)
ACADEMIC YEAR 2021-22
PROJECT TITLE: CRIME RECORD MANAGEMENT SYSTEM
SI No. NAME USN SIGNATURE
1. SAGAR J 1JS19IS118
2. SHASHANK S P 1JS19IS124
ABSTRACT
Crime Record Management System is designed to make the existing manual system automatic with the help of
computerized equipment, fulfilling their requirements, so that their valuable data and information can be stored
for a longer period with easy access and manipulation of the same. The required software is easily available and
easy to work with. This web application can maintain and view computerized record without getting redundant
entries. The project describes how to manage user data for good performance and provide better services for
the client.
ENTITY & ATTRIBUTES:
CRIME crime id, crime criminal id, crime name, crime type, crime description, court id.
COMPLAINT crime id, complaint id, complaint name, complaint registered location, complaint
description.
FIR FIR id, FIR name, FIR type, FIR description.
CHARGE SHEET Complaint id, charge sheet id, charge sheet fee, charge sheet type, charge sheet
description, FIR id.
PRESIONER Criminal id, prisoner id, prisoner crime id, prisoner name , prisoner location.
CRIMINALS Criminal id, criminal crime id, criminal name, criminal phone no., criminal address, FIR id.
COURT Court id, court name, court type, court place, court description.
PUNISHMENT Court id, criminal id, punishment id, punishment type, punishment description.
ENTITY-RELATIONSHIP DIAGRAM:
SCHEMA DIAGRAM:
CRIME
Crime id Crime criminal id Crime name Crime type Crime Court id
description
COMPLAINT
Crime id Complaint name Complaint name Complaint registered location Complaint description
FIR
Fir id Fir name Fir type Fir description
CHARGE SHEET
Complaint id Charge sheet id Charge sheet fee Charge sheet type Charge sheet description Fir id
PRISONER
criminal id Prisoner id Prisoner crime id Prisoner name Prison location
CRIMINALS
Criminal id Criminal crime id Criminal name Criminal phone no. Criminal address Fir id
COURT
Court id Court name Court type Court place Court description
PUNISHMENT
Court id Criminal id Punishment id Punishment type Punishment description
HARDWARE REQUIREMENT:
Minimum System Hardware requirement:
OS :Windows 8 or above
Processor : Intel i3
RAM : 4GB
Hard disk : 512GB
SOFTWARE IMPLEMENTATION:
HTML
CSS
PHP
JAVA SCRIPT
MySQL
DESCRIPTION:
A criminal record is a record of a person's criminal history. The information included in a criminal record and the
existence of a criminal record varies between countries and even between jurisdictions within a country. In most
cases it lists all non-expunged criminal offences and may also include traffic offences such as speeding and drunk
driving. In some countries the record is limited to actual convictions , while in others it also includes arrests,
charges dismissed, charges pending and charges of which the individual has been acquitted.
A criminal history may be used by potential employers, lenders, and others to assess a person's trustworthiness.
Criminal records may also be relevant for international travel, and for the charging and sentencing of persons
who commit additional criminal offenses.
So it is necessary to maintain the crime record in a way the access and process of crime record is faster. The
classical crime record management is not efficient hence the solution for the problem is computerized manner of
storing the crime record i.e., crime record management system (CRMS).
APPLICATION AREA:
1) Police Department to access the criminal data.
Helps the policemen to work with the crimes and criminals easily.
2) Passport verification officer (Background check and Criminal Records).
3) Background check while hiring an employee for a company.
