1 of 10

HACKATHON’23

TEAM

THECONQUERERS2023

AYUSH SHAURYA JHA

SHARAD PRAKASH

ANIKET ARYAN

PRATHAM DWIVEDI

TEAM MEMBERS

2 of 10

STATEMENT: Website for Citizens and Police for management of crime records

THECONQUERERS2023

Description : Develop a solution for management of crime records for police and citizens . The solution should provide proper management of crime records which can easily be accessed by police and citizens . The Website should allow the user to file a complaint and would also allow the user to judge /view the crimes(and related things) which took place till now . The normal user can login via mentioning certain details while a police person can login through police ID and after verification he/she would land to the main home page.

At home page , there would be option to file a complaint and other option to access the crime records . When user clicks on the icon of “FILE COMPLAINT” , then he/she would be directed to a page asking for Crime details and finally he/she could submit it there . There would also be a option of some other help which victim may require . This option would land him/her to another page showing all possible help that Police can provide.

The other option at home page would allow user to have access to all crime which took place . Then after, user can check crime detail by clicking on “CRIME DETAILS” option . This can help user to check the most crime prone areas ,victims , case current position and so on.

The user can also give his/her suggestions at the home page by clicking on the option of “FEEDBACK” . This would help in improving the website.

At the backend , all information ,complaint and suggestions of users could easily be accessed.

Problem Statement

3 of 10

Proposed Solution

We propose to build a webpage, easily accessible to both policemen for ease of work and to general public to register new complaints. The goal of the website is to provide a simple and readily accessible solution for a crime record management system.

We plan to provide separate login pages for admins, police personnel and public, who can add update or delete data at different levels.

Any person can sign up and register his/her complaint through the portal.

The database is accessible entirely to all the admins, and they have the permission to add, update, or remove any data.

In case some data is deleted or modified, the admins and the personnel who added the data are to be notified.

In case new entries are added, the details of the personnel who added is visible to the admins.

4 of 10

Primary aspects of our proposed solution

  • Police personnel need to login through their ID and password to access the database. They have the permission to read, update or delete data, depending on their clearance.

  • The data stored by one police station will not be accessible to other police stations without permission from admins.

  • General public can create a user ID, which can be used to register new FIRs and view the details and status of previous complaints.

  • The status of complaint filed by a user is visible to him, and is updated once it is accepted.

5 of 10

Tech Stack

  • The login and authentication part is implemented

using ‘node.js’ .

  • The front-end is implemented using HTML and CSS

and JavaScript to some extent.

  • Database is managed with the help of MySQL.

6 of 10

Solution Workflow

Landing Page

Admin Login

Personnel Login

User Login

Has access to all data, and can add, update or modify it. Admin can also suspend or remove an account permanently.

Has the authority to add new FIRs, and fill out the details of criminals. Any new complaint has to be authorized by them, before it is officially registered as an FIR.

Any person can create a new user account to register a complaint. Users can view the status of their complaints, and also the details of their previous complaints.

7 of 10

Plan Implementation

database

Public user

Admin

Police Personnel

New complaint

Accepted complaints are added to the database.

Has access to all data in the database.

Admin can temporarily suspend or permanently ban user and personnel accounts.

User can view his previous complaints and their status.

Can add or update the contents of the database.

Ask for admin’s permission to access data from other police stations.

8 of 10

Future Scope

Priority listing: To provide a sort of notice board, where the highest priority cases can be listed, so that different stations can better use their resources in order to solve the problem.

Evidence Board: An evidence board would be a temporary page, like a clipboard, that can be used by policemen while solving the case to look up the evidence pertaining that case. Once the current session is terminated, the data in the evidence board gets deleted automatically.

9 of 10

Summary

Any user can signup and register their complaints, which will be reviewed by policemen and an FIR will be registered for valid complaints.

When a policeman logs in with his official account, he will have access to all the cases in his police station, apart from those barred by the admin.

The admin can add, modify and delete data from the database. He can also suspend or remove any account.

10 of 10

THANK YOU

TEAM

THECONQUERERS2023