The Evolution
of Data
Experience why traditional File-Based Systems failed and how Database Management Systems changed everything.
reception_patients.txt
101 · John · 999…
doctor_notes.txt
101 · John · 999…
lab_reports.txt
101 · John · 999…
pharmacy_issue.txt
101 · John · 999…
billing_ledger.txt
101 · John · 999…
admin_master.txt
101 · John · 999…
hospital_db
One record. Every department.
A 400-bed hospital that runs on text files
Reception, Doctor, Laboratory, Pharmacy, Billing and Administration each keep their own file. The same patient is typed in six times. For a while, it works. Then a phone number changes.
You will not read about the failures — you will cause them. Then you'll rebuild the same hospital on a database and watch each failure disappear.
Act I — The File-Based System
Open real files, edit records, break the data, lose it. Eight interactive failures.
Enter
Act II — The DBMS
One central database, SQL console, roles, transactions, backup and joins.
Enter
Act III — Side by side
Eleven dimensions, each with a live demonstration you can click into.
Enter