The main objective of this system is to maintain and manage detailed information on the a crime that happened in an area under a particular police station.
- Open project ONLINE BANKING SYSTEM.
- Create Database, tables into local system from SQL_TABLES.txt.
- Download the .jar file according to your MySQL version from https://mvnrepository.com/artifact/mysql/mysql-connector-java.
- Admin role
- Public role
MySQL
- JAVA - JDBC
- MySQL
- Admin Login/Logout
- Add Crime Details
- Update Crime Details Using CrimeId
- Add Crimina lDetails
- Update Criminal Details Using CriminalID
- Assign Criminal To Crime
- Remove Criminal From Crime
- Delete Crime By Using CrimeID
- Delete Criminal By Using CriminalID
- Total Crime For Each PS Between Date
- Total Crime For Each Crime Type Between Date
- Get Criminal Details By Criminal Name
- Get Crime Details By Description
- Get Crime Details By Crime Type
Flow Chart ---->
ER Diagram ---->
-
- Your valuable feedback is greatly appreciated. You can reach out to me via the below medium
- 👨💻 All of my projects are available at Portfolio
- Aman Maurya
- Masai School