Designing a Hospital Management System

A hospital administrator describes the problem in one breath. "We need to know which doctor saw which patient, what was prescribed, which bed they were in, and what to bill."

Every rule from the last six chapters is needed to answer that. This case study builds the whole design, from that sentence to running SQL.

What the system must do

Six capabilities, taken from what the staff actually do.

Register patients and keep their details current.

Keep doctor profiles, with specialty and the department they belong to.