Hospital Information System

Relational Database Design & Enterprise Backend Management

An enterprise relational database and management backend designed for hospital patient admissions, medical records, and scheduling, built as the final project for an IEEE backend workshop.

1. The Engineering Problem

Healthcare facilities manage complex, highly coupled data entities (patients, physicians, departments, admissions, prescriptions, billings) that require strict referential integrity, auditability, and ACID transaction compliance.

2. What Was Built

A normalized relational database schema with PL/SQL business logic, stored procedures, triggers, and CRUD operations supporting patient intake, medical history querying, and physician scheduling.

3. System Architecture & Topology

ASCII Topology

Normalized 3NF relational schema with stored procedures enforcing hospital business rules at the database engine level.

Client Interface / Application
              |
              v
PL/SQL Procedures & Business Rules (ACID Transactions)
              |
              v
Relational Schema (Patients, Doctors, Admissions, Prescriptions, Rooms)

4. Mohamed's Personal Implementation

Designed normalized relational entity-relationship diagrams (ERDs) adhering to 3NF standards.

Wrote complex SQL queries, views, and PL/SQL stored procedures for patient registration and medical record updates.

Implemented database constraints and foreign keys to guarantee data integrity across admissions and patient records.

5. Engineering Challenges & Solutions

Challenge: Maintaining Referential Integrity Across Patient History

Solution: Designed cascading integrity constraints and stored transaction procedures that ensure medical notes cannot exist without active physician and patient associations.

Impact: Zero orphan records and clean clinical audit trails.

6. Technology Stack

Database

Oracle DatabaseSQLPL/SQLRelational Modeling

Application

C# / .NET Desktop InterfaceCRUD Architecture

7. Verified Outcomes

•Completed as the capstone final project for the IEEE Backend Engineering Workshop.
•Earned official IEEE Back-End Module certification.

← Back to Portfolio