k

1

Project Report on

ONLINE CRIME REPORTING SYSTEM

AT

HCL INFOSYSTEMS LTDAhmedab

By:Shaheen Vora (07DCE072)

Smita Gajjar (07DCE082)

Diploma in Computer Engineering Semester – VIII

Year 2010-11

Guided By:

Asst. Prof. Rahul Shrimali (Internal)

Mr.Shayama Bhattacharya (External)

INSTITUTE OF DIPLOMA STUDIES

NIRMA UNIVERSITY

AHMEDABAD (GUJARAT- INDIA) 382481

2

NIRMA UNIVERSITY

INSTITUTE OF DIPLOMA STUDIES

AHMEDABAD (GUJARAT- INDIA) 382481

INSTITUTE OF DIPLOMA STUDIES

C E R T I F I C A T E

This is to certify that following student of Diploma in Computer Engineering Semester-VIII have completed their on

site Project Work /Industrial Training titled ONLINE CRIME REPORTING

SYSTEM satisfactorily in partial fulfillment of requirement of Diploma in Computer Engineering in the year 2010-11.

Roll No. Name of the Students07DCE082 SMITA J. GAJJAR

Asst.Prof. Rahul Shrimali

Internal Project Guide HOD – CE

Date: - 11th May 2011

Place: - Ahmedabad

ACKNOWLEDGEMENTS

3

We wish to express our heartfelt appreciation to all those who have contributed to this project, both explicitly and implicitly, without the co-operation of whom, it would not have been possible to complete this project.

We would like to thank our institute for giving us the opportunity to have some feel about the Industrial environment. We would like to thank Faculty Prof.Rahul Shrimali(Assistant Prof., IDS, NU) for constantly guiding and showing us the correct path to reach towards our desired goal.

We are indebted and thankful to Mr. Shyama Bhattacharya for their keen interest, untiring perseverance and unceasing motivation during the course of our project despite of his busy schedule.Last but not the least we would like to thank our family members and friends for their constant encouragement and support through out the duration of our training.

With Regards,

Smita J.Gajjar

(07DCE082)

PREFACE

Our Project title is on ONLINE CRIME REPORTING SYSTEM. It is the one type system developed to report FIR(First Investigation Report)online..

4

This system is developed for user and it most useful for police department.When login user is enter in system they can report FIR of any crime and any person or things or vehicle are missing so they can easily fillup the form and after fillup their form and submit after submitting their report they can show their progress report no need to go any kind of police station to report their FIR .admin is add criminal so any user can view criminals and their details. Admin can also add missing person and so if any user view that person so easily find out his or her.

5

Index

Sr No Topic Page No1. Project Profile 12. System Summary 23. Company Profile 34. ASP.Net 5

4.1 Introduction To ASP.Net 54.2 How ASP.Net pages execute? 64.3 Technology Used In .NET Platform 74.4 Why SQL? 74.5 SQL server 2005 84.6 Benefits of Using MS SQL Server 2005 8

5. System Analysis 95.1 What is system analysis? 95.2 SDLC (System Development Life Cycle) 9

6. System DesignSystem Design 136.1 System ChartSystem Chart 136.2 System Flow ChartSystem Flow Chart 14 6.2.1 6.2.1 System Flow Chart (Admin) 16 6.2.2 System Flow Chart(user) 176.3 E-R DiagramE-R Diagram 186.4 Data Flow DiagramData Flow Diagram 19 6.4.1 Context Level DFD 6.4.1 Context Level DFD 19 6.4.2 First Level DFD (Admin) 20 6.3.3 First Level DFD (User) 216.5 Data Dictionary 22

7. Screen shortScreen short 298. Bibliography Bibliography 59

1.Project ProfileProject Title : Online Crime Reporting Syatem

6

Project Objective : Website for Online Crime Reporting System is to provide online FIR and check CRIMINAL RECORDS,Add missing person/things/vehicles User can View their Progress Report Can reduce the cost associated with creating and distributing paper requirements and reduce the work of police and user

Developers : Smita Gajjar (07DCE082)

Project Guide : Asst. Prof. Rahul Shrimali

Hardware Configuration

: 1 GB RAM,10 GB Hard Disk Space,32 or 64 bits OS, 1.6 GHZ processor or Higher.

Front End : Microsoft Visual Studio 2008

Back End : Microsoft SQL server 2005

Technology : .NET 3.5

Operating System : Windows XP or later

7

2. System Summary

The project titled as “ Online Crime Reporting System “is a web based application.This software provides facility for user reporting online FIR, missing persons/things and vehicls ,criminals details and search criminals and shows their progress report. Any Number of clients can connect to the site. Each user first makes their login to site to show their availability.

2.1 Scope

This Website provides an architectural overview of the crime management. This Website is a generic, web-based tool that enables users to manage the Crime on tasks completed as part of projects with tasks and sub-tasks. The tool includes interactivity. Functionality. Information will be stored in a database. Administrative and managerial functions will be provide including configuring projects/tasks/subtasks.

2.2 Purpose

We have developed the portal of “CRIME REPORTING”, the portal can handle data of criminals who are under the judicial surveillance or are under trial. This portal will be most useful for defence for searching of details of criminals, any one can report a FIR online, missing citizen ,vehicle and things secure registration and profile management facilities ,reduce the work of police and user and reduce the time

8

3.Company Profile

HCL Info Systems is India's premier information enabling company. Leveraging its 27 years of expertise in total technology solutions, HCL Info Systems offers value-added services in key areas such as system integration, networking consultancy and aide range of support services.HCL Info Systems is among the leading players in all the segments comprising the domestic IT products, solutions and related services business, which includes PCs, servers, networking products, imaging & communication products.Continuously meeting the ever increasing customer expectations and applications, its focus on integrated enterprise solutions has strengthened the HCL Info systems SSO's (System Support Organization) capabilities in supporting installation types ranging from single to large, multi-location, multi-vendor & multi-platform spread across India. The SSO, comprising a direct support force of over 1600+ members, is operational at 170+ locations across the country and is the largest such human resource of its kind in the IT business. A majority of the SSO members have been special trained in a variety of supporting solutions, the company's key focus area.HCL Info Systems ' manufacturing facilities are ISO 9001 - 2000 &ISO 14001 certified and adhere to stringent quality standards and global processes. With the largest installed PC base in the country,

Four indigenously developed and manufactured PC brands -'Infiniti', 'Busy bee' 'Beanstalk' and the 'Ezeebee' - and its robust manufacturing facilities; HCL Info Systems aims to further leverage its dominance in the PC market. It has been consistently rated as Top player in PC industry by IDC .The 'Infiniti' line of business computing products is incorporated with leading edge products from world leaders such as Intel. A fully integrated and business-ready family of servers and workstations, the 'Infiniti Global Line' is targeted at medium and large companies to help them to manage their enterprise-related applications. It has considerable dominance in verticals like finance, government, and education & research.The Frontline Division of HCL Info Systems has an extensive network of over 1000 resellers across 300 cities. Frontline Division has actively promoted the penetration of PCs in the home and the small office/home office (SOHO) segments, through BeanstalkPCs, Toshiba Laptops & Dragon Speech Recognition Systems.Constant evolution with changing times has helped HCL Info Systems retain its leadership and profitability for all stakeholders. In 1992, HCL formed a joint venture company, HCLHP, with the international computer giant, Hewlett-Packard (HP),and precipitated a technological leap by achieving world class manufacturing expertise in the country for HP's RISC/UNIX based business

9

servers and workstations. In 1997, HCL and its joint venture partner, HP, re-organized their joint business activities in India through the buying back of HP's 26 per cent of equity inch HP by the HCL promoters.Last year, HCL entered into an alliance with SUN Microsystems to be their Enterprise Distributor for entire range of SUN products. Combing the latest technology & best-practices from SUN, with 27years of customer relationship and pan Indian sales & service expertise of HCL, it aims to leverage the relationship to offer complete spectrum of IT to the end user.

HCL has closely seen the IT industry rise from scratch, and has actively participated in its progress. During the twenty-seven year journey, it has picked up valuable lessons in serving the IT needs of the Indian customer and gathered domain expertise to successfully service various businesses.HCL Infinite, our 100% subsidiary focuses on the ever-growing segment in Imaging, Telecom and Communication products, solutions and services. HCL Infinite’s product portfolio covers arrange of other office automation and communication products through alliances with world leaders - including mobile communication products from Nokia, Duprinters from Duplo,LCD projectors from InFocus, Mass Mailing solutions from Pitney Bowes and voice and telecommunication solutions from Ericsson.It has an exclusive sale and support partnership with Toshiba Corporation, Japan, for sales and servicing of its imaging and photocopier products.The Managed Network Service offerings for corporate includeVPNs, ASP offerings, Co Location/ hosting, CDNs, security, corporate internet telephony solutions, technical and consumer help desks, 24/7 Network Operations Centre monitoring and a host of value added networking services. Consumer services include dialup PSTN/ISDN Internet access, Valufon calling cards and VoIP telephony devices.As a leading information enabler, HCL Info systems has longstanding relationships with world technology leaders such as SUN for enterprise computing solutions, Intel and AMD for PCs and PCServers; Microsoft, Novell and SCO for operating systems and software solutions; Toshiba Corp. for business automation Equipment; and Oracle, Sybase and Informix for RDBMSplatform, EMC, VERITAS for storage solutions. The aim is to straddle the entire landscape of information enabling technology far more comprehensively, effectively and competitively.

Indeed, a vision to create enterprises of tomorrow

10

4. 4. ASP.NetASP.Net

4.1 Introduction to the ASP .NET

ASP.NET is a set of Microsoft .NET Framework technologies used for building Web applications and XML Web Services. ASP.NET pages execute on the server and generate markup such as HTML, WML or XML that is sent to a desktop or mobile browser.

The Microsoft .NET Framework and Active Server Pages.NET (ASP.NET) allow developers to create world-class Web applications and Web services quickly and easily. Web applications built within the .NET Framework can integrate with any operating system running on any device. Web services are reusable component applications that enable distributed computing on the Internet, using standard protocols like HTTP and XML. Developers conversant in .NET can now deliver more dynamic applications to market more quickly

ASP.NET pages use a compiled, event-driven programming model that improves performance and enables the separation of application logic and user interface. Both ASP.NET pages and ASP.NET XML Web Services files contain server-side logic (as opposed to client side logic) written in Visual Basic .NET, C# .NET, or any .NET compatible language. Web applications and XML Web Services take advantage of the features of the common language runtime, such as type safety, inheritance, language interoperability, versioning, and integrated security.

11

4.2 How ASP.Net pages execute?

[Figure 2.1: - How ASP.Net pages execute?]

Above figure illustrate that how the .aspx pages are executing at web server in that first of all it will find using which language script is written like usingVB.net, C#, J#, or other with respective of scripting language it will use appropriate compiler means if code is written in C# then it will use C# compiler afterward .NET framework uses second platform neutral language called CIL Common Intermediate Language afterward that compiled code is submitted to common language runtime (CLR) and this CLR compiles code into machine readable language.

12

4.3 Technology Used In .NET Platform

From a technology standpoint, .NET is the. Platform and the .NET experiences built on top of the platform. The platform includes:

Tools – to build applications and XML Web services (.NET Framework and Visual Studio.NET),

Servers – on which to build, host and deploy those applications and services (Windows 2000 Server and the .NET Enterprise Servers)

Services – a core set of .NET building block services (“Hailstorm” services),

4.4 Why SQL?

Once you start running multiple web servers for the same web site, the default asp.net session state, InProc, is no longer useful, as you cannot guarantee that each page request goes to the same server. It becomes necessary to have a central state store that every web server accesses.

SQL Server offers you centralized storage of a session state in a Web farm. It also offers the transactional capabilities that provide reliability to most relational database systems. You can use SQL Server to save a session. This process is not as efficient as InProc and StateServer mode, because you must store the information in a different process or on a different server. However, this option may be more efficient than using the asp.net state service, depending on the actual workload and the database configuration. Once you start saving session state to a SQL database it will also persist through web server restarts and reboots.

For reliability you should consider storing session state for a web farm on a SQL cluster.

13

4.5 SQL server 2005

Microsoft SQL is the most widely used databases in the world. Microsoft SQL is a relational database. This concept is an extremely simple way of thinking about and managing data used in a business. Microsoft SQL 2005 was developed and defined by Microsoft Corporation. SQL us a non-procedural language because it

Processes sets of records rather than just one at a time. Provides automatic navigation to the data.

Rather than manipulating single records, you can mange sets of records. The most common form of a set of record is a table. All SQL statements accept sets as input and all SQL statements to be used as input to other SQL statements. SQL provides statements for a variety of tasks including

Inserting, updating, deleting database objects Creating, modifying and deleting database objects Controlling access to the database and database objects Guaranteeing database consistency

4.6 Benefits of Using MS SQL Server 2005

Handles large amount of data efficiently. Fits in current Infrastructure Compatible with most OS (Win 9x) used in Organization. Compatible with other Microsoft Technologies used in Project like MS Visual Studio .net The data in the future might be made available on Internet. Centralized Control Reduction Of Redundancies

14

5. System Analysis

5.1 What is system analysis?

The collection of notations, methodologies & tools used to gather details &analyse a problem situation prior to information system design & implementation is called system analysis.

Record inspections:

In this method analyst examines information that has been recorded earlier about system & users. It can be applied at the beginning or end as required.

Observations:

Observation allows analyst to gain information they can’t by any other fact finding technique. Experienced observers know what to look for & how to access the significance of what they observed.There are distinct approaches to the development of computer information system.

Here described is the method called as SDLC(System Development Life Cycle).

5.2 SDLC (System Development Life Cycle)

It consists of following 6 activities:-

1. Preliminary Investigation : This activity has three parts:

1) Request clarificationIt deals with clarity of requests from users.

2) feasibility study:Feasibility study is a stage in the system development life cycle following the information phase. In this phase, it is decided whether it is worth automating/computerizing the problem. The information collection that occurs during preliminary investigation examines system feasibility, and find out whether system will be beneficial to the organization or not.

15

Technical feasibility:

The following factors suffice for considering the given project as

Technically Feasible.

1. The system developed in .net technology which is well known and today we can easily get the technical help of .net technology from the internet.

2. The system development in .net technology is specified by client.

Operation Feasibility:The following factors suffice for considering the given project as operational Feasible.

1. Sufficient support from the user.

2. Acceptance from the user side for active involvement and interest in project

Economic feasibility :

The following factors suffice for considering the given project as Economically Feasible.

1. The system does require investment which provided by client. 2. The system will perform according to client requirement and

Economical will not much expensive.

Implementation Feasibility:

This system is developed using Visual Studio .NET 2008 as front end and MySQL as back end. The software’s are available in the development company.

3) Request approval:It deals with selection of feasible projects among various projects.

16

2. Determination of system requirements:

Detailed understanding of all important facts of business area under investigation.

System Requirement Specification:

1.) Functional Requirements

Admin Add user: This module help the user to report online complaints. Manage system: Admin can manage whole the system. View/Add/Delete Missing persons: This module help the user to report

online missing persons details also we have to add photos of missing person.

View and Missing vehicles and things: This module helps the user to view and add the detail of vehicles and things.

View /Delete User: This module helps the user to view and delete the Detail of users.

Add/Edit/Delete Criminals: This module helps the user to view and delete the detail

of users. Add /Delete Police Station: This module helps add /delete police station. Add /Delete City: This module helps add /delete city. Add/Delete Country: This module helps add /delete country. Search user/Criminal: This module helps the search user & criminal and

details for that. Generate Progress Report: This module helps to generate progress report

For user. Its shoe the status of F.I.R

User:

Register: This module allows complainer to view their profile. View progress status: This module allows complainer to view their

progress report which is generated by admin. Add/view Missing Person/Missing things/Missing vehicle: This module

help to add and view missing person, missing things, missing vehicle. Search Criminals: This module allows complainer to criminals and their

details.

17

3.Design of System:The design of system consists of logical & physical types of designs. The design that produces the details stating how a system will meet the requirements identified during system analysis. This stage is referred as logical design. The process of developing application is referred as physical design.

4.Development of software

This part refers to the coding of the system.

5.System testing

The system is used experimentally to ensure that the application does not fails.It should run according to its specifications & in the way users expect.

6.Implementation & Evaluation:

Implementation is the process that checks the system & put it into use. Evaluation is performed to identify its strength & weaknesses. Dimensions in which evaluation may occur are:

1) Operation Evaluation 2) Organizational Impact 3) User management assessment4) Development performance

18

6. 6. System Design System Design

6.1 System Chart

F igure: 1 System chart

19

6.2 System Flowcharts

System flowchart describes the data flow for a data processing system. It

provides a logical diagram of how the system operates. It represents the flow of

documents, the operations performed in data processing system. It also reflects

the relationship between inputs, processing and outputs.

Or

A graphical representation of the sequence of operations in an information

system or program. Information system flowcharts show how data flows source

documents through the computer to final distribution to users. Program

flowcharts show the sequence of instructions in a single program or subroutine.

Different symbols are used to draw each type of flowchart.

Following are the features of systems flowcharts:

The sources from which data is generated and device used for this

purpose.

Various processing steps involved

The intermediate and final output prepared and the devices used for their

storage.

Symbols Used for flow Chart

The Process Symbol represents any process, function,

or action and is the most frequently used symbol in

flowchart.

The Document Symbol is used to represents any type

of hard copy input or output (i.e. Reports)

Off page Connector Symbol are used to indicate the

flowcharts continues on another page. Often, the page

number is placed in the shape for easy reference.

The Input/ Output Symbol represents data that is

available for input or resulting from processing.

The Decision Symbol is a junction where a decision

must be made. A single entry may have any number of

alternative solutions, but onlt one can be chosen.

The Connector Symbol represents the exit to, or entry

fro, another part of the same flowchart. It is usually

used to break a flow line that will be continued

elsewhere.

21

6.2.1 Flow Chart: (Admin)

Figure:2 Flow chart of admin

6.2.2 Flow Chart: (user)

22

Figure:3 Flow Chart of User

6.3 E-R Diagram

23

Figure:4 E-R Daigram

24

6.4 Data Flow Diagram

6.4.1 Context Level Diagram:

Figure:5 Context Daigram

25

6.4.2 1 st level Data flow Diagram for Admin

Figure:6 1st level DFD of admin

26

6.4.3 1 st level Data flow Diagram for User

Figure:7 1st level DFD of user

6.5 Data Dictionary:

27

A data dictionary is a catalog-a-repository-of the elements in a system. As the name suggests, these elements centre on data and the way they are structured to meet user requirements and organization needs. In a data dictionary you will find a list of all the elements composing the data flowing through a system. The major elements are data flows, data stores and processes. The data dictionary stores details and descriptions of these elements.

Analysts are used data dictionaries for five important reasons:

To document the features of the systems. To manage the details in a large systems. To facilitate analysis of the details in order to evaluate characteristics

and determine where system changes should be made. To locate errors and omissions in the system.

Data Dictionary describes the Tables used by CRS :

28

1 Table: user _master

Description: To store the information about user.

Column Name Data type Constraint Descriptionuser_id Varchar(20) PK It store UsernameFirstName Varchar(20) Not null To store First Name LastName Varchar(20) Not null To store Last NameUsername Varchar(20) Not null To store usernamePassword Varchar(30) Not null To store passwordreg._date Datetime Not null To store registration DateAddress Varchar(Max) Not null To store addressEmail Varchar(50) Not null To store email addresscontact_no Number(15) Null To store contact number city_id Varchar(10) FK To store cityDob Datetime Not null To store the date of birthGender Varchar(6) Not null To store the genderedu_qual Varchar(20) Null To store the education qualificationOccupation Varchar(20) Null To store the occupation

2. Table: country

Description: To store the information about country.

Column Name Data type Constraint Descriptioncountry_id Varchar(10) PK To store the country idcountry_name Varchar(30) Not null To store the country namecountry_code Varchar(10) Not null To store the country code

3. Table:state

Description: To store the information about state.

Column Name Data type Constraint Descriptionstate_id Varchar(10) PK To store the state idstate_name Varchar(20) Not null To store the state namecountry_id Varchar(10) FK To store the country id

4. Table: city

29

Description: To store the information about city.

Column Name Data type Constraint Descriptioncity _id Varchar(10) PK To store the city idcity _name Varchar(20) Not null To store the city namestate _id Varchar(10) FK To store the district id

5. Table: FIR

Description: To store the information about F.I.R.

Column Name Data Type Constraint DescriptionFIR_id Varchar(10) PK To store FIR idcity_id Varchar(10) FK To store city idps_id Varchar(10) FK To store police station detailFIR_date Datetime Not null To store Fir dateFIR_topic Varchar(50) Not null To store fir topicocc_date Datetime Null To store occurrence dateocc_time DateTime Null To store occurrence timeocc_place Varchar(100) Not null To Store Occurrence Placecriminal_name Varchar(20) Null To Store criminal namecomplainant_name Varchar(50) Not null To store complainant Namegender Varchar(6) Not Null To store gender detailcrime_info Varchar(100) Not null To store crime information.address Varchar(50) Not null To store Address complainant_Contact Number(15) Not null To store complainant Contactvictim_id Varchar(10) FK To store victim detailwitness_info Varchar(50) Null To store witness information FIR_Status Varchar(15) Not null To store FIR statusFIR_Submit_date Datetime Not null To store FIR_submit_dateFIR_forward_date Datetime Not null To store FIR_forward dateFIR_Update_date Datetime Not null To store FIR_Update_time

6. Table: progress

Description: To store the information about progress of F.I.R.

Column name Data type Constraint DescriptionPrg_id Varchar(10) PK To store progress idPS_id Varchar(10) FK To store police Station idFIR_id Varchar(10) FK To store FIR id

30

court_id Varchar(10) FK To store Court idstatus Varchar(50) Not Null To store status

7. Table: Victim_detail

Description: To store the information about view details.

Column name Data type Constraint Descriptionvictim_id Varchar(10) PK To store victim idvictim_Fname Varchar(20) Not null To store victim Fnamevictim_Lname Varchar(20) Not null To store victim lnamegender Varchar(6) Not null To store victim genderaddress Varchar(MAX

)Not null To store address

city_id Varchar(10) FK To store cityvictim_contact Varchar(15) Not null To store contact nocrime_type Varchar(20) Not null To store crime type

8. Table: court

Description: To store the information about court.

Column Name Data Type Constrain Descriptioncourt_id Varchar(10) PK To Store court idcourt_Name Varchar(10) Not null To store court Namecourt_type Varchar(10) Not null To store type

9. Table: missing_person

Description: To store the information about missing person.

Column Name Data Type Constraint DescriptionMP_id Number(10) PK To store missing person idcity_id Varchar(10) FK To store city Idfname Varchar(25) Not null To store first namelname Varchar(25) Not null To store Last Nameaddress Varchar(MAX

)Not null To store address

dob Datetime Not null To store dobheight Number(3) Not null To store heightphoto Varchar(MAX Null To store photo

31

)reporting_date Datetime Not null To store reporting datedate_from Datetime Null To store date from missingplace_Missing Varchar(50) Null To store place from

missingyour_relation Varchar(10) Not null To store your relationgender Varchar(6) Not null To store gendercomplexion Varchar(20) Not null To store complexionhair Varchar(10) Not null To store hair coloreyes Varchar(10) Not null To store eyes colorphysical_Detail Varchar(100) Not null To store physical detailpersonal Detail Varchar(100) Not null To store personal detailcomplain’s contact

Varchar(15) Not null To store complaint’s contact no.

last_seen Varchar(15) Null To store last seen placestatus Varchar(20) Not null To store status

10. Table: missing_vehicle

Description: To store the information about missing vehicle.

Name Type Constraint DescriptionMV_id Varchar(10) PK To store Missing vehicle idFIR_id Varchar(10) FK To store FIR idPS_id Varchar(10) FK To store police stationvehicle_type Varchar(20) Not null To store vehicle typevehicle_model Varchar(20) Not null To store vehicle modelmodel_year Number(5) Not null To store model yearvehicle_no Varchar(20) Not null To store vehicle novehicle_color Varchar(20) Not null To store vehicle color engine_no Varchar(20) Not null To store engine numberchasis_no Varchar(20) Not null To store chassis no.date_of_theaft Datetime Not null To store data of theft date_of_inform Datetime Not null To store date of informstolen_from Varchar(20) Not null To store stolen from placeowner_name Varchar(20) Not null To store owner Namecost_origin Number Not null To store the original cost cost_current number Not null To store the current cost

11. Table: missing _thing

32

Description: To store the information about missing things.

Column Name Data Type Constraint Descriptionmis_thing_id Varchar(20) PK To store missing thing iduser_id Varchar(20) FK To store useridmis_thing Varchar(10) Not null To store missing thingdetails Varchar(100) Not null To store missing detailsf_name Varchar(50) Not null To store first namel_name Varchar(50) Not null To store last namemis_date Datetime Not null To store missing Datemissing_from Varchar(10) Null To store missing placecity_id Varchar(10) FK To store city

12. Table: criminal_detail

Description: To store the information about criminals.

Column Name Data Type Constraint Descriptioncr_id Varchar(10) PK To store criminal idf_name Varchar(20) Not null To store first namel_name Varchar(20) Not null To store last nameFIR_id Varchar(10) FK To store FIR idarrest/Surr.Date Datetime Not null To store arrested or

surrender dategender Varchar(6) Not null To store gender crime_type Varchar(20) Not null To store crime typecr_photo Varchar(MAX) Not null To store criminal photoDob datetime Not null To store date of birthaddress Varchar(MAX) Not null To store address religion Varchar(10) Not null To store religioncity_id Varchar(20) FK To store cityheight Varchar(3) Null To store heightBuild Varchar(10) Not null To store buildoccupation Varchar(20) Null To store occupationeducation Varchar(20) Null To store educationpolice_id Varchar(20) FK To store police id

33

13. Table: police_station _name

Description: To store the information about police station.

Column Name Data Type Constraint Descriptionps_id Varchaer(10) PK To store police station idPS_Code Varchar(10) Not null To store police station codePS_Name Varchar(20) Not null To store police station Namecontact_no Number(10) Not null To store contact address Varchar(Max) Not null To store Addresslocation Varchar(20) Not null To store locationdivision Varchar(20) Not null To store DivisionFAX_no Number(20) Null To store fax no

34

7 7 Screen shortScreen short

7.1 Login Page

Description: In these pages user/ admin can login using their roles, name and password.

35

7.2 User Registration Page

Description: In these user fill up their information.

Validation:Validation:Some detail in the forms are must required that can’t be allow Null other Some detail in the forms are must required that can’t be allow Null other wise registration is not completewise registration is not complete

36

7.3 F.I.R Form

Description: After login user can fill up F.I.R Form in these from its fills first investigation form, victim info as well as witness info if they have.

37

7.3 Missing Person Form

Description: In this user can fill up missing person information.

38

7.4 View Missing Person Details

Description: In these page user views list of missing person information.

39

7.5 After Select Missing Person

Description: In these pages user views missing person details.

40

7.6 Missing Things Form

Description: User fill up a form for missing things like mobile, gold, wallet etc.

41

7.7Missing Vehicle

Description: User fill up a form if their vehicle is missing.

42

7.8 Search Criminals

Description: In these page users search the criminal by first name, last name and arrest/surrender date.

43

7.9 Criminal Details

Description: In these page is come after selecting criminal.

44

7.10 Admin Login:

Description: These pages for admin login.

45

7.11After Admin:

Description: In these page is come after admin login.

46

7.12 Criminal Form

Description: After Fill up this form admin can add criminal.

47

7.13 Add/Delete Criminals

Description: In these page admin edit/delete criminal.

48

7.14 Search User

Description: In these page admin search user.

49

7.15 View FIR

Description: In this page admin views list of F.I.R as well as delete F.I.R.

50

7.16 Add City

Description: In these page admin add city using these form.

51

7.17 View City

Description: In this page Admin edit/delete/select city.

52

7.18 Add State

Description: In these page admin add state.

53

7.19 View State

Description: In this page admin edit/select/delete state.

54

7.20 Add Country

Description: In these page admin add country.

55

7.21View Country

Description: In these page admin view/edit/delete countries.

56

7.22 Add /View Police Station

Description: In these admin add/delete and edit police station.

7.23 View Police Station

57

Description: In these page admin view/edit/delete/select police stations.

7.24 Contact Us

58

Description: In this page for contact us.

7.25 Feedback

59

Description: In this page for gives feedback.

7.26 Change Password:

60

Description: In this page for change password.

61

8.Bibliography8.Bibliography

8.1 Websites referred:

1. http://www.ic3.gov/default.aspx

2. http://www.fbi.gov/

3. http://www.homeoffice.gov.uk/crime/

4. http://www.met.police.uk/

5. http://www.hamsaweb.org/crime/

62