Act III
File System vs DBMS, demonstrated
Not a static table. Pick any dimension and run the demonstration for both systems, side by side.
File-Based System
Copies drift apart silently
DBMS
Single source of truth
Live demo · file-based
Consistency without a database
John changed his phone number
He tells the receptionist. Only the receptionist.
Reception
9999999999
Doctor
9999999999
Laboratory
9999999999
Pharmacy
9999999999
Billing
9999999999
Administration
9999999999
Live demo · DBMS
Consistency with a database
One record. Six readers.
UPDATE Patients SET phone = ? WHERE PatientID = 101;
Reception
9999999999
reads Patients.phone
Doctor
9999999999
reads Patients.phone
Laboratory
9999999999
reads Patients.phone
Pharmacy
9999999999
reads Patients.phone
Billing
9999999999
reads Patients.phone
Administration
9999999999
reads Patients.phone
hospital_db
Patients(101, John Mathew, 9999999999)