ForenSys
Forensic Medical Department Database Management System
Team
- E/22/182, Dinith Kariyawasam, e22182@eng.pdn.ac.lk
- E/22/291, Rameesha Prathapasinghe, e22291@eng.pdn.ac.lk
- E/22/421, Tharindu Weerasinghe, e22421@eng.pdn.ac.lk
- E/22/449, Gayumi Wimalaweera, e22449@eng.pdn.ac.lk
Table of Contents
Introduction
Forensic medical departments serve as a critical bridge between medicine and the justice system by handling sensitive clinical forensic evaluations and postmortem investigations. To function effectively, these departments require precise data management. Currently, however, many institutions rely heavily on manual record keeping.
The reliance on traditional methods introduces several critical vulnerabilities and inefficiencies. Some of the existing problems include,
- Paper records: Physical documents are prone to degradation, misplacement, and physical damage.
- Difficulty in searching: Manually retrieving specific patient demographics or historical clinical forensic (MLEF) records is time-consuming and inefficient.
- Confidentiality: Maintaining strict privacy is challenging when physical files can be easily viewed or mishandled.
- Report generation: Compiling comprehensive autopsy or court reports by hand is labor-intensive and prone to human error.
- Evidence tracking: Without an automated system, ensuring a strict chain of custody for physical evidence and media assets is highly difficult.
The general Objective of this system is to design and develop a complete, secure Database System for a Forensic Medical Department to streamline medico-legal processes. To address these challenges, this project details the design and development of a comprehensive, secure database system tailored specifically for a Forensic Medical Department.
The primary standfast goal is to digitize patient demographics, medico-legal examination records, autopsy files, and evidence tracking into a centralized, reliable platform. The methodology involved designing a monolithic system architecture utilizing a Java Spring Boot backend, a React frontend, and a highly normalized PostgreSQL database. Strict Role-Based Access Control (RBAC) and cryptographic security measures were implemented to ensure data isolation and maintain the integrity of legal evidence.
Specific Objectives:
- To digitize patient demographics and clinical forensic (MLEF) records.
- To automate the tracking of autopsy and death investigations.
- To establish a secure repository for evidence and media assets.
- To enforce normalization and clear functional dependencies within the database schema.
The resulting system successfully automates administrative workflows, enables the instant querying of historical case files, and facilitates the rapid generation of standardized medical and court reports. This digital transition significantly enhances operational efficiency, data reliability, and forensic confidentiality compared to legacy manual processes.