This assignment presents a comprehensive hospital database design and implementation using Oracle Database Management System. The solution begins with an introduction emphasizing the importance of efficient record storage in hospitals, covering patient medical reports, employee data, and medical stocks. The assignment is structured into two stages: Stage 1 focuses on scenario selection and conceptual database design for a fictitious hospital, "Better Health Care," detailing its various sections (Management, Finance, Pharmacy, Health Records, Labs, Wards, and Sanitary) and their operations. Enterprise rules are established to model relationships between entities, visualized through an Entity Relationship Diagram (ERD) identifying entities such as Section, Ward, Employee, Patient, and Health Record. Stage 2 delves into the logical database design, presenting the table structures with data types and constraints. It includes the creation of tables using Oracle DBMS, the implementation of unique indexes for data integrity, and data population using SQL INSERT statements for various tables (Sections_Tbl, Employees_Data, Patients_Data, Wards_Table, and Health_Records). The solution also provides example SQL queries to retrieve specific data, such as employee details, patient records, and financial summaries. The assignment concludes with a summary of the database design process and references relevant sources.
![[object Object]](/_next/static/media/star-bottom.7253800d.svg)
