Family Reunion DB & Online Banking
A combined case study: a family-reunion relational database covering schema design and queries, and a PHP/MySQL midterm simulating account balances and customer views.
Sec 01
Overview
The database half started with schema design — deciding what a family reunion actually needs to record, normalising it into related tables, and then writing the queries that answer real questions about it.
The PHP/MySQL half connects a front end to that kind of data: an online-banking simulation with account balances and per-customer views, where the query layer and the page output have to stay in step.
Debrief
What I Took Away
- ▸Normalising a real-world domain into related tables.
- ▸Writing queries that answer questions, not just return rows.
- ▸Connecting PHP to MySQL and rendering per-user views safely.
- ▸Keeping data access and presentation separated.
LanguagesSQL · PHP
DatabaseMySQL
TypeWeb + schema
ScopeTwo projects