This project is my first complete step into database design , it simulates how a hospital works behind the scenes in real life:
Patients & Visitors – who’s admitted, where they stay, and who comes to see them.
Doctors & Nurses – their departments and contact details.
Rooms & Equipment – hospital resources, locations, and availability.
Medicines & Pharmacy – stock levels, expiry dates, and prescriptions.
Operations and surgical records connected to patients and doctors.