Online Crime Investigation ER Diagram

Subscribe our YouTube channel for latest project videos and tutorials Click Here

Posted By freeproject on July 17, 2017

This ER (Entity Relationship) Diagram represents the model of Online Crime Investigation Entity. The entity-relationship diagram of Online Crime Investigation shows all the visual instrument of database tables and the relations between Criminal , Department , Case , FIR etc. It used structure data and to define the relationships between structured data groups of Online Crime Investigation functionalities. The main entities of the Online Crime Investigation are Case , Criminal , Crime , Department , Police and FIR .

Online Crime Investigation entities and their attributes :

  • Case Entity : Attributes of Case are case_id, case_crime_id, case_criminal_id, case_name, case_type, case_description
  • Criminal Entity : Attributes of Criminal are criminal_id, criminal_crime_id, criminal_name, criminal_mobile, criminal_email, criminal_username, criminal_password, criminal_address
  • Crime Entity : Attributes of Crime are crime_id, crime_criminal_id, crime_name, crime_type, crime_description
  • Department Entity : Attributes of Department are department_id, department_name, department_place, department_type, department_description
  • Police Entity : Attributes of Police are police_id, police_department_id, police_name, police_mobile, police_email, police_username, police_password, police_address
  • FIR Entity : Attributes of FIR are FIR_id, FIR_name, FIR_type, FIR_description

Description of Online Crime Investigation Database :

  • The details of Case is store into the Case tables respective with all tables
  • Each entity ( FIR , Crime , Police , Criminal , Case ) contains primary key and unique keys.
  • The entity Crime , Police has binded with Case , Criminal entities with foreign key
  • There is one-to-one and one-to-many relationships available between Police , Department , FIR , Case
  • All the entities Case , Police , Crime , FIR are normalized and reduce duplicacy of records
  • We have implemented indexing on each tables of Online Crime Investigation tables for fast query execution.
Online Crime Investigation  ER Diagram
Get 6 diagrams only in 300/- or $6.99 USD.
Call or WhatsApp us on +91-8470010001 for more details.

Project Category

Related Entity Relationship Diagram (ERD)

 Student Grading Ranking System ER Diagram

Student Grading Ranking System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Student Grading Ranking System Entity. The entity-relationship diagram of Student Grading Ranking System shows all the visual instrument of database tables and the relations between Exams, Results, Student, Merit List etc. It used...
Coach Management System ER Diagram

Coach Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Coach Management System Entity. The entity-relationship diagram of Coach Management System shows all the visual instrument of database tables and the relations between Coach Number, Train, Coach, Report etc. It used structure data and to...
HRD Management System ER Diagram

HRD Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of HRD Management System Entity. The entity-relationship diagram of HRD Management System shows all the visual instrument of database tables and the relations between Trainings, Departments, Employee, Salary slip etc. It used structure data...
Health Care Appointment System ER Diagram

Health Care Appointment System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Health Care Appointment System Entity. The entity-relationship diagram of Health Care Appointment System shows all the visual instrument of database tables and the relations between Booking, Customer, Health Care, Test etc. It used...
Training and Placement Management System ER Diagram

Training and Placement Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Training and Placement Management System Entity. The entity-relationship diagram of Training and Placement Management System shows all the visual instrument of database tables and the relations between Placement, Jobskeer, Trainning,...
Fitness Center Management System ER Diagram

Fitness Center Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Fitness Center Management System Entity. The entity-relationship diagram of Fitness Center Management System shows all the visual instrument of database tables and the relations between Branch, Fitness class, Fitness, Memeber etc. It...
Fast Food Corner Portal ER Diagram

Fast Food Corner Portal ER Diagram

This ER (Entity Relationship) Diagram represents the model of Fast Food Corner Portal Entity. The entity-relationship diagram of Fast Food Corner Portal shows all the visual instrument of database tables and the relations between Items, Receipts, Foods, Bill etc. It used structure data and to...
Cargo Management System ER Diagram

Cargo Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Cargo Management System Entity. The entity-relationship diagram of Cargo Management System shows all the visual instrument of database tables and the relations between Cargo, Billing, Customer, Payment etc. It used structure data and to...
Library Application System ER Diagram

Library Application System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Library Application System Entity. The entity-relationship diagram of Library Application System shows all the visual instrument of database tables and the relations between Book, Address, Student, Supplier etc. It used structure data...
Store Management System ER Diagram

Store Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Store Management System Entity. The entity-relationship diagram of Store Management System shows all the visual instrument of database tables and the relations between Product, Bill, Stock, Store etc. It used structure data and to define...
Call FreeProjectz WhatsApp FreeProjectz