Client

Department of Disaster Management, providing safety and security solutions for island governments in disaster management and preparedness.

Service Provided

Development and enhancement of a disaster management application that provides detailed documentation, training databases, and preparedness assessments for disaster entities.

Technologies

C#, ASP.NET, Framework 4.0, SQL Server 2008, DotNetNuke6, JavaScript, jQuery

Project Overview

The Department of Disaster Management project was designed to support the island government in managing disaster-related documentation and preparedness assessments. The system was divided into three key modules:

• Document Center: A repository for storing and managing documentation related to various disaster events.
• Training Database: A module for tracking and managing the training programs for disaster management personnel.
• Disaster Preparedness Assessment (DPA): A module aimed at assessing the readiness of disaster management units, providing insights based on specific assessments.

The system allows disaster management professionals to upload, store, and manage critical data related to disaster events and training. The Disaster Preparedness Assessment module was particularly challenging due to database relationship issues from the client side, requiring a redesign of the entire database structure for proper functionality.

Challenges

• Database Issues: The client provided a pre-existing database structure with significant flaws, particularly in the Disaster Preparedness Assessment module. The database used incorrect relationships, especially with the use of foreign keys, which impacted overall system functionality.
• Complex Database Relationships: Managing and correcting the existing database relationships between different modules required a redesign of the database to ensure that data integrity and relationships were maintained correctly.
• Handling Large Documentation: Ensuring that the Document Center could store and retrieve large volumes of documents efficiently and securely.

Solution Delivered

• Database Redesign: The development team redesigned the database for the Disaster Preparedness Assessment (DPA) module, ensuring proper use of Entity_ID as a foreign key and rebuilding the database structure to fix issues related to relationships between tables.
• Enhanced Document Management: The Document Center was designed to store large volumes of critical documentation securely while ensuring easy retrieval and version control for disaster entities.
• Training Module Implementation: The Training Database was built to track all personnel training activities, allowing administrators to monitor their progress and ensure they meet the preparedness standards.
• User-Friendly Interface: Developed a user-friendly interface using DotNetNuke6, JavaScript, and jQuery to ensure ease of navigation and interaction for disaster management officials.

Roles & Responsibilities

• Code Development: Wrote clean, maintainable, and efficient code to address project requirements, including fixing issues with the database structure.
• Database Management: Managed the database relationships, especially correcting the foreign key management in the Disaster Preparedness Assessment module.
• Collaboration: Worked closely with senior developers and project managers to fully understand the system requirements and ensure timely delivery of project milestones.

Outcome

• Improved Data Integrity: The redesigned database ensured the proper relationship between entities, which improved the functionality and reliability of the Disaster Preparedness Assessment module.
• Efficient Document Management: The Document Center allowed for efficient storage and retrieval of large volumes of documents related to disaster management.
• Training Tracking System: The Training Database enabled the government to track personnel training progress, ensuring readiness for disaster response.
• Successful Project Delivery: Despite the initial challenges with the database, the project was delivered successfully, with all modules functioning smoothly, meeting the client’s needs for disaster preparedness and management.