How aryamansaxena18/food-order-dbms works
This is a MySQL food-order database project, not an application with a separate frontend or API. Its central workflow is loading the included raw dataset into staging, transforming it into normalized relational tables, then querying and analyzing the resulting data. The repository also demonstrates reusable stored logic, trigger-based auditing, transactions, and query optimization. The SQL source was not excerpted, so relationships below rely on the README’s documented workflow and capabilities.
Main entry points: 01_schema.sql Normalized Tables · 02_data.sql Load and Normalize · 05_triggers.sql Audit Triggers · 03_views_indexes.sql Views and Indexes
Components 13
Data Model
- Food-order CSV
data/food_order data set.csv - Staging Table
sql/01_schema.sql - Normalized Tables
sql/01_schema.sql - Load and Normalize
sql/02_data.sql
Database Logic
- Stored Programs
sql/04_plsql.sql - Audit Triggers
sql/05_triggers.sql - Order Audit
sql/01_schema.sql
Querying and Analysis
- Views and Indexes
sql/03_views_indexes.sql - SQL Queries
sql/06_queries.sql - Query Optimization
sql/09_storage_query_opt.sql
Database Operations
- DML and TCL
sql/07_dml_tcl.sql - Transactions
sql/08_transactions.sql
Other components
- Database User
Connections 14
- Food-order CSV → Staging Table: loads into
readme.md - Load and Normalize → Staging Table: loads data
readme.md - Load and Normalize → Normalized Tables: transforms into
readme.md - Staging Table → Normalized Tables: transformed into
readme.md - Normalized Tables → SQL Queries: queried by
readme.md - Normalized Tables → Views and Indexes: views represent
readme.md - Normalized Tables → Views and Indexes: indexes support
readme.md - Audit Triggers → Order Audit: records changes
readme.md - Normalized Tables → Audit Triggers: order changes fire
readme.md - Database User → SQL Queries: runs queries
readme.md - Database User → Stored Programs: uses routines
readme.md - Database User → DML and TCL: executes statements
readme.md - Database User → Transactions: manages transactions
readme.md - Database User → Query Optimization: analyzes plans
readme.md