This project involves the design and implementation of a robust Hospital Management Database. The goal was to create a centralized system that efficiently handles daily hospital operations, ensuring data integrity and providing meaningful insights through complex reporting.
- Conceptual Design: Created a detailed Entity-Relationship Diagram (ERD) to model entities like Patients, Doctors, Nurses, Rooms, and Appointments.
- Logical Design: Mapped the ERD to a Relational Schema, ensuring normalization and proper relationship mapping (One-to-Many, Many-to-Many).
- Physical Implementation: Developed SQL scripts (DDL) for table creation and (DML) for populating the database.
- Advanced Querying: Implemented complex SQL queries involving Joins, Aggregations, Subqueries, and Group By clauses for reporting.
- Prototype Development: Built a user-friendly interface using Oracle APEX for data entry and report generation.
- Patient Management: Track admissions, medical history, and discharge.
- Staff Scheduling: Manage doctor and nurse assignments to departments and rooms.
- Resource Tracking: Real-time monitoring of room availability (Special Care, Maternity, etc.).
- Financial Reporting: Automated billing based on consultation and room types.
Design/: Contains the ERD, Relational Schema, and Oracle APEX screenshots.Documentation/: Full technical report (PDF) detailing the system analysis and implementation.
Developed by Computer Science students at King Faisal University:
- Atekah Hussain
- Rana Salah
- Amal Marshad
- Hanan Abdullah
- Maryam Alshabib
- Supervised by: Dr. Bashayer Fareed Altulaihey
This diagram illustrates the logical structure of the hospital database, showing entities and their relationships.
.jpg)
The mapped relational model showing tables, primary keys, and foreign keys.
Connect with me on LinkedIn for more projects! https://www.linkedin.com/in/ateka-hussain/