sharonyohanna-cyber/Plateau-care-DB

A MySQL-based Hospital Management System for General Hospitals in Plateau State, Nigeria. # PlateauCareDB ## Hospital Management System for Plateau State, Nigeria PlateauCareDB is a MySQL-based relational database project designed for a General Hospital in Plateau State, Nigeria. It demonstrates the design and implementation of a healthcare database using SQL and realistic healthcare scenarios. ## Problem Statement Many hospitals still rely on manual record-keeping, making patient management slow, error-prone, and difficult to maintain. PlateauCareDB provides a structured database for storing and managing patient information, staff records, appointments, medical records, and hospital visits. ## Features - Patient Registration - Staff Management - Medical Records - Appointment Scheduling - Patient Visit Tracking - Department Management - Diagnosis Management ## Database Tables - LGAs - Departments - Diagnoses - Patients - Staff - MedicalRecords - PatientVisits - Appointments ## SQL Concepts Demonstrated - CREATE DATABASE - CREATE TABLE - INSERT - UPDATE - DELETE - ALTER TABLE - DROP DATABASE - PRIMARY KEY - FOREIGN KEY - INNER JOIN - GROUP BY - ORDER BY - Aggregate Functions ## Technologies Used - MySQL - MySQL Workbench - GitHub ## Repository Structure ``` PlateauCareDB/ ├── PlateauCareDB.sql ├── README.md ├── docs/ ├── assets/ └── screenshots/ ``` ## Future Improvements - Pharmacy Module - Laboratory Module - Billing System - NHIA Integration - User Authentication ## Author **Sharon Dung** SQL Portfolio Project – Healthcare Database Design