Skip to content

End-to-end SQL database design for a simulated hospital ER. Includes EER modeling, relational schema mapping, and complex query implementation with a focus on relational algebra and normalized data architecture.

Notifications You must be signed in to change notification settings

ChaseH01/SQLDatabaseDesign-EmergencyRoomCaseStudy

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

14 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Simulated Emergency Room Database

I designed the database for a simulated emergency room given specific requirements. I then implemented this database in SQL, populated the tables, and performed relevant queries to exemplify the design.

Please read the full report for more details, query examples, and relational algebra: 📄 View Full Project Report (PDF)

Note: This project was created for the IES Madrid / Universidad Carlos III de Madrid course Files and Databases.


Diagrams

EER Model

EER Model

Relational Schema

Relational Schema

About

End-to-end SQL database design for a simulated hospital ER. Includes EER modeling, relational schema mapping, and complex query implementation with a focus on relational algebra and normalized data architecture.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors