Crime Reporting System 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 Crime Reporting System Entity. The entity-relationship diagram of Crime Reporting System shows all the visual instrument of database tables and the relations between Criminal, Department, Case, Complaint etc. It used structure data and to define the relationships between structured data groups of Crime Reporting System functionalities. The main entities of the Crime Reporting System are Case, Criminal, Crime, Department, Police and Complaint.

Crime Reporting System 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
  • Complaint Entity : Attributes of Complaint are complain_id, complain_name, complain_type, complain_description

Description of Crime Reporting System Database :

  • The details of Case is store into the Case tables respective with all tables
  • Each entity (Complaint, 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, Complaint, Case
  • All the entities Case, Police, Crime, Complaint are normalized and reduce duplicacy of records
  • We have implemented indexing on each tables of Crime Reporting System tables for fast query execution.
Crime Reporting System 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)

Login Authentication System ER Diagram

Login Authentication System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Login Authentication System Entity. The entity-relationship diagram of Login Authentication System shows all the visual instrument of database tables and the relations between Password, Changing Password, Username, Groups etc. It used...
Auto Spare Parts Management System ER Diagram

Auto Spare Parts Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Auto Spare Parts Management System Entity. The entity-relationship diagram of Auto Spare Parts Management System shows all the visual instrument of database tables and the relations between Sales, Billing, Purchase, Order etc. It used...
Car Insurance Management System ER Diagram

Car Insurance Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Car Insurance Management System Entity. The entity-relationship diagram of Car Insurance Management System shows all the visual instrument of database tables and the relations between Insurance, Booking, Car, Bill etc. It used structure...
Clinic Appointment System ER Diagram

Clinic Appointment System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Clinic Appointment System Entity. The entity-relationship diagram of Clinic Appointment System shows all the visual instrument of database tables and the relations between Patient, Booking, Clinic, Doctor Schedule etc. It used structure...
Online Travel Portal System ER Diagram

Online Travel Portal System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Online Travel Portal System Entity. The entity-relationship diagram of Online Travel Portal System shows all the visual instrument of database tables and the relations between Registrations Customer, Bookings, Users, Payments etc. It...
Timetable Management System ER Diagram

Timetable Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Timetable Management System Entity. The entity-relationship diagram of Timetable Management System shows all the visual instrument of database tables and the relations between Attendance, Student, Timetable, Teacher etc. It used...
Credit Card Approval System ER Diagram

Credit Card Approval System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Credit Card Approval System Entity. The entity-relationship diagram of Credit Card Approval System shows all the visual instrument of database tables and the relations between Application, Limits, Credit Card, Document etc. It used...
School Registration System ER Diagram

School Registration System ER Diagram

This ER (Entity Relationship) Diagram represents the model of School Registration System Entity. The entity-relationship diagram of School Registration System shows all the visual instrument of database tables and the relations between Teachers, Schools, Classes, Registrations etc. It used...
Computerized Examination System ER Diagram

Computerized Examination System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Computerized Examination System Entity. The entity-relationship diagram of Computerized Examination System shows all the visual instrument of database tables and the relations between Papers, Results, Exams, Questions etc. It used...
Pharmacy Management System ER Diagram

Pharmacy Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Pharmacy Management System Entity. The entity-relationship diagram of Pharmacy Management System shows all the visual instrument of database tables and the relations between Medicines, Company, Pharmacy, Sells etc. It used structure data...
Call FreeProjectz WhatsApp FreeProjectz