sank29/crime-information-management-system

The main aim of this system is to maintain and manage detailed information of the crime happened in an area under a particular police station. This software will be used by the police officials in the Police station.

Hi 👋, I'm Sanket Wankhede

A passionate backend developer from India

What you do today define your tomorrow

Aspiring Java Backend Developer. An individual who can write clean and optimize code. Like to solve Data Structure and Algorithms problems. I have made some solo and collaborative projects and continue to have some experience as well as acquiring more knowledge. Looking for enhancing my skills as a Backend Developer.

• 🔭 I’m currently working on Crime Information Management System

• 🌱 I’m currently learning Spring Boot

• 👨‍💻 Checkout my portfolio My Portfolio

• 💬 Ask me about Java, Spring Boot, Javascript, Hibernate

• 📫 How to reach me [email protected]

• 📄 Know about my experiences My Resume

Connect with me:

Languages and Tools:

Show some ❤️ by starring some of the repositories!

📊 My Github Stats

crime-information-management-system's Issues

Finalizing the tables and their relationships for the project

• Making the tables in sql
• Doing research how the make relationships between tables

Implementation of DAO methods

• Implementation of dao methods
• Make sure all the dao methods are working
• Finding the bugs in application
• Runing the application the if it is running or not

Finalizing the JDBC dependencies and DAO interface methdos

• Finalizing the jdbc dependencies
• DAO interfae methods
• Run the application to check the application run fine or not
• finding the bugs in application

Finalizing the Bean classes and DTO classes

• Making the bean class
• Making the dto class
• Take a look of any bug present in application.

Issues and Enhancement In your project

General Issues

• Try to use a meaningful commit message after each commit.
• Divide your GitHub commits based on each functionality so that it is easy to find the code error and you can easily roll back your changes based on your commit id.
• Try to create meaningful branch names so that others can understand, what code changes anyone can guess.
• Follow the best practice to create a .env file[ to store your secret i.e(db_username & password) and also create .gitignore.
• Try to create an Exception class for each class admin,crime_info, criminal_list, and police_station.

Functionality Issue

ADMIN
** admin table should have some auto_incremented id attribute to do curd operation in the admin table.
** while creating an admin profile make sure both username and password are not the same[apply validation while creating new admin].
** username and password should be case-sensitive while logged in through your application.[Use Binary keyword in mysql].
** Admin should have the option to view all crime information based on crime_id.
** Admin should have the option to view all crime information based on criminal_id.
CRIME_INFO
** It's better if crime_Id is auto_cremented primary key column.
** Add One column of the total number of crime victims.
** Add One Column that depicts crime time.
** One Additional column Criminal ID should be present[ which is nullable if it's new criminal]
** Add One Column that depicts equipment involved in crime.
** I saw one crime status 0, what does it mean?
CRIMINAL_LIST
** Criminal age should be dataType TINYINT, not DateTime.
** One field that depicts the Total crime done by one criminal.
** One field that depicts that criminal coming under which police station number.
POLICE_STATION
** In the Police Station table, there should be one column of Contact_Number
** In the Police Station table, there should be one column of Current SuperIncharge
** Try to use auto_increment id for the Police Station Number no need to manually insert the Police Station Number and Change it to Police Station Id.

Implementation of the Presentation part

• Implementation of the Presentation part
• Making sure all the application is run properly without any error
• Finding final bugs if any in application.