Restaurant & Cafe Chain Data Model
A governed relational model for restaurant operations, customers, orders, inventory, and sensitive information.
THE DECISION
How should a multi-location restaurant chain structure operational data so it remains usable, consistent, and governed?
APPROACH
- Designed conceptual and relational models
- Normalized 11 tables and 57 attributes to 3NF
- Classified sensitive fields and data-quality risks
- Implemented representative business queries
EVIDENCE & DELIVERABLES
- SQLite database and schema
- Entity-relationship diagrams
- Four-part final submission
EVIDENCE INTEGRITY
This case is presented as uc davis final assignment. The label distinguishes observed work from simulated impact, proxies, historical comparisons, or proposed architecture.