Online Crime Investigation System Project in Java

Project Abstract: This Online Crime Investigation System software presents the part of an organization’s work as per the requirements, specifications, and conditions mentioned in the user manual. This application s/w has been developed and completed successfully and also tests successfully by taking “Test Cases” It is user-friendly and has all the needed menu options, which can be utilized by the user to perform the desired operations. Moreover, help messages are provided which will help any authorized user from using the system without trouble.

The proposed system is not limited presently. Presently we have to login to the system online and post the complaints. We can further develop the system by using the “Voice Recognition System”. So this project has got scope to get developed in the near future. The scope of the project exists throughout the life of the product development, testing and implementation.

Deployment of  Application:

1) Copy the Online Crime Investigation System application folder to

F:\Tomcat5.5.9\webapps\

2) Click on start.bat in the bin folder of tomcat

3) Create a User in Oracle as follows:

CREATE USER OCR IDENTIFIED BY OCR;

GRANT DBA TO OCR;

CONN OCR/OCR

Now place the all tables in the table.txt file at the SQL Command Line

And type the following command

COMMIT;

4) Create user DataSourceName(DSN) as

click  –> Start —> Control Panel—> Administrative Tools

Software Requirements:

  • Operating System: Windows 98 or above
  • Front end : HTML & JAVA SCRIPT, J2EE(JSP,servlets,Ajax),
  • Back end : Oracle 8i
  • Web Server: Tomcat 5.5.9
  • Front end  : HTML & XML
  • Middleware : J2EE(JSP)
  • Application server : Web logic 7.0

Crime Investigation System Screen Shots:

1.    Crime Investigation System

HomePage

Homepage for the Crime Investigation System Application

Overview

Functional Overview

This module/screen is the Homepage for the Crime Investigation System Application.

Technical Overview

This module Admin or Police Department or Customer can login through screen and customer can register.

Navigations

Customer Login ->Customer LoginScreen

AdminLogin ->Admin Login Screen

Home ->Application Homepage

Department Login ->Department Login Screen

Registration ->Customer Registration Form

ADMIN MODULE

2.    Admin Login Screen

Admin Login Screen

2.1.1    Overview

Functional Overview

This module/screen is used to Admin Login Process.

Technical Overview

  1. This module takes the valid Admin Username and password.
  2. The particulars are valid you will get Admin Homepage otherwise it will displays the message “Invalid Login Information”.

Navigation

AdminLogin->AdminLoginScreen

Action Controls

Control
Name
Type Description Action
       
Login button Gets the particulars of the Admin Login Details. Admin Homepage
Clear Button Clear the fields on the form Login Screen

3.    Admin Home Screen

3. Admin Home Screen

3.1.1    Overview

Functional Overview

This module/screen is used to operate Administration Module.

Technical Overview

  1. This module is used to create new Police Departments and updating the existed department details.
  2. This module is used to create new thief Information and updating the existed thief information
  3. Creating New Caution Information.

Navigation

AdminLoginProcess->AdminHomePage Screen

Action Controls

Control
Name
Type Description Action
       
New Department HyperLink Displays the New Department  registration Form Department Registration Form
All Departments HyperLink Displays the existed department details screen List of departments
New Thief Information Hyperlink Displays the New thief  registration Form Thief  Registration Form
Thief Information HyperLink Displays the existed thief details screen List of Thief Information
Caution HyperLink Displays Caution registration Screen Caution Registration Form

4.    Department Registration Screen

Department Registration Screen

4.1.1    Overview

Functional Overview

This module/screen is used to register New Department Information.

Technical Overview

  1. This module takes the valid new Department Information and Login details.
  2. These New Department particulars will be stored into “POLICE_DEPARTMENT” database table and login details into “LOGIN_MASTER” table.

Navigation

New Department->Department Registration Screen

Action Controls

Control
Name
Type Description Action
       
Register button Gets The new Department    information and login details from the form. Stores the department data into table POLICE_DEPARTMENTlogin details into table LOGIN_MASTER
Clear Button Clears the field in the form New Department Registration form will be displayed

5.    Updating Department Details Screen

SCREEN1

5. Updating Department Details Screen

SCREEN2

Updating Department Details Screen1

5.1.1    Overview

Functional Overview

This module/screen is used to Display the list of Department and Updating the department  Information according  to the Department Id.

Technical Overview

  1. Click on Update then it will takes the Department Id and displays Screen2 (Popup Window).

Navigation

All Departments->Department Details

Action Controls

Control
Name
Type Description Action
       
Update button Displays the Department  information of selected Department Id. Displays the Department Information Screen(Screen2)
Close Button Closes the Department Modification form Displays All Department Screen (Screen1)

6.    Thief Registration Screen

Thief Registration Screen

6.1.1    Overview

Functional Overview

This module/screen is used to register New Thief Information.

Technical Overview

  1. This module takes the valid new Thief Information.
  2. These New Thief particulars will be stored into “THIEVES” database table .

Navigation

New Thieves Information->Thief Registration Screen

Action Controls

Control
Name
Type Description Action
       
Register Button Gets The new Department    information and login details from the form. Stores the thieves data into table THIEVES
Clear Button Clears the field in the form New Thieve Registration form will be displayed

7.    Updating Thief Details Screen

Updating Thief Details Screen

SCREEN1 

7.1.1    Overview

Functional Overview

This module/screen is used to Display the list of Thieves and Updating the thief Information according  to thief Id.

Technical Overview

  1. Click on Update then it will takes the thief Id and displays Screen2 (Popup Window).
  2. If you select thief category then according to the selected Category it will Displays Screen3

Navigation

Thieves Information->Thieved Information

Action Controls

Control
Name
Type Description Action
       
Update button Displays the Thief   information of selected Thief Id. Displays the Thief Information Screen(Screen2)
Close Button Closes the Thief Modification form Displays All Department Screen (Screen1)

8.     Caution Registration Form

Caution Registration Form

7.1.2    Overview

Functional Overview

This module/screen is used to Create New Cautions.

Technical Overview

  1. This module takes the valid caution Information and will be stored into CAUTIONS Data Base Table.

Navigation

Caution->Caution Registration Form

Action Controls

Control
Name
Type Description Action
       
Save button Gets the required input details. caution Information and will be stored into CAUTIONSData Base
Clear Button Clears the fields data New Caution Form will be displayed

DEPARTMENT MODULE 

8.    Department Login Screen

Department Login Screen

8.1.1    Overview

Functional Overview

This module/screen is used Department Login Process.

Technical Overview

  1. This module takes the valid Username and password.
  2. The particulars are valid you will get Department Homepage otherwise it will displays the message “Invalid Login Information”.

Navigation

Department Login->Department Login Screen

Action Controls

Control
Name
Type Description Action
       
Login button Gets the particulars of the Department Login Details. Department   Homepage
Clear Button Clears the Form Details New Login Screen Will be displayed

  

9.    Department HomePage

Department HomePage

9.1.1    Overview

Functional Overview

This module/screen is used to process the Department operations.

Technical Overview

  1. In This module department can see his complaint details and thief information.
  2. Updating complaint status and modifying the selected thief informtaion.

Navigation

Department Login Process -> Department Homepage. 

10.    Requested Complaints

Requested Complaints

10.1.1    Overview

Functional Overview

This module/screen is used Display the complaints Information.

Technical Overview

  1. Updating the complaint status by changing the options in the Modify column.
  2. In options when the complaint status is ‘Closed’ then only you will get new option ‘ReOpen’ in the options

Navigation

Requested Complaints->Complaints Status

Action Controls

Control
Name
Type Description Action
       
Update button Gets the modified details. Changes the status of the complaint in COMPLAINT_REG Table

 

11.    Thief Details Screen

Thief Details Screen

11.1.1    Overview

Functional Overview

This module/screen is used to Display the list of Thieves and Updating the thief Information according  to thief Id.

Technical Overview

  1. Click on Update then it will takes the thief Id and displays Screen2 (Popup Window).
  2. If you select thief category then according to the selected Category it will Displays Screen3

Navigation

Thieves Information->Thieve Information

Action Controls

Control
Name
Type Description Action
       
Update button Displays the Thief   information of selected Thief Id. Displays the Thief Information Screen(Screen2)
Close Button Closes the Thief Modification form Displays All Department Screen (Screen1)

 

12. Customer Information

Customer Information

11.1.2    Overview

Functional Overview

This module/screen is used to Display all registered Customer Details

Navigation

Customer Information->Customers Information Screen

CUSTOMER MODULE 

12.    Customer Registration Screen

Customer Registration Scree

12.1.1    Overview

Functional Overview

This module/screen is used to Customer Registration.

Technical Overview

  1. This module takes the valid new Customer Information and Login details.
  2. These New Customer particulars will be stored into “CUSTOMER_MASTER” database table and login details in “LOGIN_MASTER”.

Navigation

Registration->Customer Registration Screen

Action Controls

Control
Name
Type Description Action
       
Register Button Gets The new Customer information and login details from the form. Stores the employee data into table CUSTOMER_MASTER
Clear Button Clears the field in the form New Registration form will be displayed

13.    Customer Login Screen

13. Customer Login Screen

13.1.1    Overview

Functional Overview

This module/screen is used Customer Login Process.

Technical Overview

  1. This module takes the valid Username and password.
  2. If The particulars are valid you will get Department Homepage otherwise it will displays the message “Invalid Login Information”.
  3. If you forgot your password then click on Forget Password option.

Navigation

Customer Login->Customer Login Screen

Action Controls

Control
Name
Type Description Action
       
Login button Gets the particulars of the Customer  Login Details. Customer    Homepage
Clear Button Clears the Form Details New Login Screen Will be displayed

 

14.    Customer HomePage

Customer HomePage

14.1.1    Overview

Functional Overview

This module/screen is used to process the Customer operations.

Technical Overview

  1. In this module customer can register his complaints and update the complaints.
  2. Customer can modify the complaint information, if the status is “Pending”.
  3. Checking the status of the complaints.
  4. Displaying all department details.
  5. Displaying all thief information.
  6. Changing the personal details.
  7. changing the password.

Navigation

Customer  Login Process -> Customer  Homepage

15.    Complaint Registration Screen

Complaint Registration Screen

15.1.1    Overview

Functional Overview

This module/screen is used to register the new Complaint

Technical Overview

  1. This module takes the valid new Complaint Information.
  2. These New Complaint particulars will be stored into “COMPLAINT_REG” database table.

Navigation

Complaint Registration->Complaint Registration Screen

Action Controls

Control
Name
Type Description Action
       
Register button Gets The new Compliant   from the form. Stores the Complaint data into table COMPLAINT_REG
Clear Button Clears the field in the form New Complaint  Registration form will be displayed

16.    Thief Details Screen

Thief Details Screen

16.1.1    Overview

Functional Overview

This module/screen is used to Display the list of Thieves Information.

Navigation

Thieve Information->Thieve Information

17.    Department Details Screen

 Department Details Screen

17.1.1    Overview

Functional Overview

This module/screen is used to Display the list of Departments Information.

Navigation

Departments->Department Information

18.    Changing Customer Profile

Changing Customer Profile

18.1.1    Overview

Functional Overview

This module/screen is used to Change the Customer Information.

Technical Overview

  1. This module takes the modified Customer Information from (Screen1).
  2. These New modified   particulars will be updated into “CUSTOMER_MASTER” database table.
  3. If u want update these modified details then click on “Update” in SCREEN1
  4. If you want to change the password then click on “Change Password” then “SCREEN2” will be displayed

Navigation

Change Profile->Customer Information

19.    Complaint Status Details Screen

 Complaint Status Details Screen

19.1.1    Overview

Functional Overview

This module/screen is used to Display the list of Complaints.

Technical Overview

  1. This module takes the valid search options like datewise and compliant type.
  2. According to the selected search option the complaints will be displayed.
  3. Click on “Show All” button, If no option selected then it will display all complaints information.
  4. Click on “Search”  button without selecting any search option then it will display message “Select Valid Search option”

Navigation

Complaint Status->Complaint Information.

Retail Business Analytical Process Osmania University CSE Final Year Project Report

This Project gives an idea of analyzing the business requirements to make a decision. The data warehousing demonstrates the principle idea to store and evaluate the data.

The Project entitled Retail business analytical processing gives the idea to demonstrate all evaluated and strategic necessities of the business requirements related to sales, stock evaluation and the systematic approach for the decision making and support.

The Project usually deals with the supermarkets, departmental store processing and the customer requirements to evaluate to develop the business by constant providing the customer requirements.

The Existing System

The current system is the database system. The usual concept of the database is to manage information in the integrated form. The data base is the record of the related information maintained in the single record or system without any error and effort for the easy accessibility of the user. The principle is to provide information in an easy, fast and less cost and effective way to the user. The database designing needs the various criteria’s.

The Proposed System

The database warehousing is simple and general in use but the application software provides the various applications.

Recording and Storing Data

The recorded data is reliable and protected  as the other user cannot retrieve the data.

Reading data online and reports

The data can be observed online

Analyzing data for identifying the business trends

The application module summarizes the data and presenting various summaries for each other databases. The process is called data warehousing.

The data warehousing is important tool in the information technology. The data warehousing gives the business to make strategic decisions. The data ware housing brings out the stored data to be evaluated.

The Oracle has already implemented the data ware housing application added in the Oracle 7 version in the early 1990. The Oracle 8, Oracle 8i, Oracle 9i has the additional features of the data ware housing to enhance the performance and management of the huge data warehouses. 

UML Diagrams of Java and Oracle Mobile Management System

UML Diagrams of Mobile Management System

The unified modeling language is a language for specification, constructing, visualizing and documenting the software and its components.

The UML is a graphical language with set of rules and syntaxes. The goal of UML is to keep the modeling simple.

ACTIVITY DIAGRAM

            Activity diagram is used to model an entire business process. The purpose of the E-R Diagram and activity diagram is below.


Activity Diagram for Computerized Mobile Store Management System

Activity Diagram for Computerized Mobile Store Management System                                                                                             

 Activity Diagram for Mobile Phone Administration

Activity Diagram for Mobile Phone Administration

 Activity Diagram for Customer Administration

Activity Diagram for Customer Administration

 Activity Diagram for Bill administration

Activity Diagram for Bill administration

 Activity Diagram for Sales Reports

Activity Diagram for Sales Reports

USE CASE DIAGRAM

 

Usecase Diagram for Computerized Mobile Store Management System

 Usecase Diagram for Computerized Mobile Store Management System.

Use Case Descriptions

  • Mobile Phone Administration:

In the “Mobile Phone Administration” the Administrator adds, updates, searches, and deletes the Mobile Phones details on his system.

Add a new Mobile Phone:

Here the administrator adds the new Mobile Phones into his system. Here administrator enters the Mobile details like MobileId, MobileModel, Mobile Price, Mobile Phone Color, etc.

Search for a Mobile Phone:

Here the administrator searches a Mobile Phone details by entering the input like Mobileid, Mobile Phone, and Price.

Update a Mobile Phone Details:

Here the Administrator Updates the Mobile Phone details by modifying the Mobile Phone details.

Delete a Mobile Phone:

            Here the Administrator Deletes a Phone details by entering the details like MobileId or IMEI no.

  • Customer Administration:

In the “Customer Administration” the administrator adds, updates, searches, and deletes the customer details on his system.

                   Add a new Customer:

Here the administrator adds the new Customer details into his system. Here administrator enters the Customer Name, Customer Address, Mobile purchased, MobileId etc.

Search for a Customer:

            In the ‘Search for a Phone’ system the administrator searches a Customer details by entering the input like CustomerId, Customer Name.

Update a Customer Details:

            In the ‘Update a Customer Details’ system the administrator Updates the details by modifying the details like Customer Address, Customer credit details.

Delete a Customer:

            In the ‘Delete a Customer’ system the administrator Deletes a Customer Details by entering input like CustomerId. 

  • Bill Administration:

In the “Bill Administration” the administrator generates and searches the bills.

Generate a Bill:

Here the Administrator generates the bill for sold Mobiles. Here he enters the information like Customer Name, Customer Address, Mobile Purchased, MobileId.

Search for a Bill:

Here the Administrator searches the bills by entering the details like Billid. 

  • Sales Reports:

                        In the “Sales Reports” the administrator can generate the Sales Reports for daily, monthly and yearly.

                        Daily Reports:

                        Here the Administrator can generate the Daily Sales Reports by giving the  input information like Date on which the Sales Reports are needed.

                        Monthly Reports:

                        Here the Administrator can generate the Monthly Sales Reports by giving  the input information like Month and Year on which the Sales Reports are                             needed.

                        Yearly Reports:

                        Here the Administrator can generate the Yearly Sales Reports by giving the input information like Year on which the Sales Reports are needed. 

SEQUENCE DIAGRAM

Sequence Diagram For Computerized Mobile Store Management System

Sequence Diagram For Computerized Mobile Store Management System 

CLASS DIAGRAMS

Relationships between identified classes

Relationships between identified classes.

E-R Diagrams & Database of Mobile Shop MCA Project

Oracle Database Table Description for Mobile Store Java Project Report

Tables: Login

Description: Stores the information of User Id and password

  Field    Type    Size    Key Description
Username Varchar 30 Not null Admin Identification
Password Varchar 20   Password

Tables: newcustomer_details

Description: Stores the information of Customer.

  Field    Type    Size    Key Description
Cid  Int 4 Not null Customer Identification
Cname Varchar  20     Customer Name
Pdate Date     Purchase Date
Paidamt Int 7   Paid Amount
Balamt Int 7   Balance Amount
Refid Int 3   Reference Id
Date Of Birth Date     Date of Birth
Age Int 3   Age
Gender Varchar 7   Gender
Dno Varchar 10   Door No
Street Varchar 15   Street
City Varchar 20   City
State Varchar 20   State
Phno Bigint 15   Phone Number
Mob_Purchase Varchar 2000   Mobiles Purchased

Tables: newmobile_details

Description: Stores the information of Mobile Phones.

  Field    Type    Size    Key Description
Phone_Id  Varchar 20 Not null Mobile Phone Id
Mobile_model Varchar 15   Mobile Phone Model
Mobile_name Varchar 20   Mobile Phone Name
Pcolor Varchar 10   Mobile Phone color
Imeino Varchar 20   IMEI No.
Mdate Date     Manufacture Date
Accessories Varchar 55   Accessories

 Tables: newbill

Description: Stores the information of Mobile Related Bill Details.

  Field    Type    Size    Key Description
Bid Int 4 Not null Bill Id
Bill Date Date     Bill Date
Cname Varchar 20   Customer Name
Price Int 7   Total Price
Amtpaid Int 7   Amount Paid
Mob_purchased Varchar 2000   Mobiles Purchased
Mob_Name Varchar 20   Mobile Name
Mob_Price Int 8   Mobile Price
Mob_color Varchar 10   Mobile Color
Mob_imei Varchar 20   Mobile Imei

Entity Relationship diagrams of Mobile Shop MCA Project

E-R Diagrams & Database of Mobile Shop MCA Project

Related Academic Project: Shop Management System

  • In this application, a user (Admin), can log in as an Admin or Staff to perform different activities.
  • By using this application the admin user can maintain the Staff and Customer Bill records and also manipulate it.

Methods of Software Development:

  • Rapid application development for making the user interface screens.
  • Prototyping Model used for development

Operating System and Languages:

  • Shop Management System is designed in .net.
  • Admin Or staff can Manage Products and Bill. The application is connected with Database using JDBC architecture.

Mobile Phone Store Management System Project in Java with Code

There is a full support from the higher authority to implement new system. All the projects can be beneficial if it can be turned to information systems that meet operating requirements. The test of feasibility is made only when the system will work it is developed and installed.

MODULE DESCRIPTION

 The ‘Mobile Phone Store Management System Project’ has four main Modules. 

1. Mobile Phone Administration 

It provides the user to maintain the Mobile Phone Details Like 

  1. Add a new Mobile Phone
  2. Search for a Mobile Phone
  3.  Update a Mobile Phone Details
  4. Delete a Mobile Phone

2.     Customer Administration

It provides the user to maintain the Customer Details Like

  1. Add a New Customer
  2. Search for a Customer
  3. Update a Customer Details
  4. Delete a Customer 

3.  Bill Administration

It provides the user to maintain the Bill Details Like

  1. Generate a Bill
  2. Search for a Bill 

4. Sales Reports

It provides the user to maintain the Sales Report Details Like

  1. Daily Reports
  2. Monthly Reports
  3. Yearly Reports

Also See:Mobile Showroom Management Project in Vb.Net

DBMS- Data Base Management System In SQL Project Report

Database Management System in SQL can be considered as one of the important aspects in the computer science filed which includes different innovations in it. Especially the data retrieval and data storage are happened to be important aspects in database management systems. Database management system is even playing important role in data storage of some huge software providers such as Google, Oracle, Yahoo and Mozilla Firefox.

The main aim of this project is to implement an efficient database management system that is capable of storing and retrieving huge data files in a secured manner by making use of the SQL commands. This database management system contains different sets as well as subsets which belong to MYSQL 4.0 functionalities. In this system, a process called interpretation will take place that present within the database system. This system includes different development processes in which database architecture design as well as SQL interpreter is the important steps. This system even include different stages such as Lexical Analysis stage, Syntax Analysis stage, Semantic Analysis stage, Type checking stage, Intermediate file generation stage, evaluation stage and GUI results display stage.

The data base management system which is developed by using SQL is capable of serving different types of functionality present within the system and it will even accept different SQL commands. Alternately the SQL commands will be interpreted with the support of interpreter present in the system which will be converted into the logical form. Then after this particular obtained form will be analyzed and evaluated critically in order to get the final and expected results. The final obtained results can be used to change and retrieve the data by using the database. This database is having an inbuilt error manager which allows the user to protect their data from hackers because if any unauthorized users enter the system then it will show an error message.

System Requirements

  • My SQL 4.0
  • SQL interpreter
  • GUI

Download DBMS- Data Base Management System In SQL Project Report.

Software & Hardware Specifications for Tourism Management System

The below added article give us brief explanation of how Hardware and Software Specifications added to this tourist project. Software Development Life Cycle is the fundamental method to follow and where the requirement phase plays major role. Software requirements for this project are VB  Visual Basic programming, Oracle Database Server and works on Windows XP. Hardware requirements are system should have 2 GB Ram, 80 GB hard disk Space. Find below added images to knwo more details about Abstract and SRS of the system.

SRS1

Software & Hardware Specifications for Tourism Management System

Download Software & Hardware Specifications for Tourism Management System.

B Tech Project Database Structure For Tourism Management

This B Tech (Bachelors of  Technology) Tourism Management Project Database Structures given below, where These tables include Field names, data type and description. Main structures are Boarding places. Tourism places, Passenger details, vehicle info. Students can create databases in MS Access, SQl and Oracle using the below custom table.

Database Structure for TMS

Download B Tech Project Database Structure For Tourism Management.

Dataflow Diagrams for Tourism System Final Year Project

The below DFD diagrams developed for Tourism Management System. These data flow diagrams very helpful while writing code in development stage. This post explains Tourist Location Maintenance, Vehicle Maintenance, Hotel Maintenance, Ticket Maintenance modules.

Data Flow Diagram of Tourism System

Download Data flow Diagrams for Tourism System Final Year Project.

Travel & Tourism Management System Project in VB & Oracle

This Project Travel & Tourism Management System explains how Travelling system works with VB application in Travelling agencies. Nowadays all travelling companies like Kesineni, Sri Kaleshwari, SVR, Diwakar Travels mainly depending on the travelling agencies and other travelling websites like redbus.in.

This application contains different modules including Book tickets module, Hotels location module, Customer Report module. All customer details and bus details stored in Oracle Database.

Find the below VB Source Code for Book Tickets Module where this module explains about how to get Available Buses To Location, get Available Hotels In Location:

Major Source Code Files Below:

 

Customer Report VB Source Code includes customer name and customer number:

 

Location Web form includes Journey Fare, Location Name, Location Number.