DP-900 Capstone Project

General Hospital
Keffi Database

Relational database replacing paper & Excel · Keffi, Nasarawa State

✦ Live Database Azure SQL Ready
👥
7
Patients
🏨
6
Wards
👨‍⚕️
7
Staff
📋
8
Visits
🔬
8
Diagnoses
Ward Bed Capacity
Total beds available across all 6 wards
Patient Gender Split
Distribution of registered patients
7 patients
Female — 4
57% of patients
Male — 3
43% of patients
ICD-10 Diagnoses
WHO standard codes used
Visit Timeline
Recent patient activity
Staff by Role
Doctors vs nurses on record
4 Doctors
3 Nurses
Ward Occupancy Overview
Bed capacity per ward — designed to scale with Azure SQL Database