March 2025
As a team of three, we designed and implemented a hospital database system in Oracle SQL to manage healthcare records and demonstrate end-to-end database management practices. In Phase 1, we developed an Entity-Relationship Diagram (ERD) to conceptually model the entities, attributes, and relationships involved in a hospital. In Phase 2, we built the relational schema with primary and foreign keys, normalized tables, and integrity constraints, and we queried the database a number of times. In Phase 3, we added views and triggers to automate data entry with no errors.