study2025Completed
Hospital SQL database
Relational hospital database designed and built in SQL.
study/2025
Overview
A group assignment for DTU course 02170 Database Systems, designing a relational schema for a hospital covering wings, departments, rooms, staff, patients, appointments, hospitalisations, and surgeries.
Two SQL scripts create the schema with primary and foreign key constraints and populate and query the database.
Highlights
- Normalized multi-table hospital schema across 10 tables
- Referential integrity via primary and foreign key constraints
- Over 600 lines of SQL across schema and query scripts
- Five-person group assignment, March 2025