# aryamansaxena18/food-order-dbms architecture

> Architecture diagram of the GitHub repository aryamansaxena18/food-order-dbms, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-06). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/aryamansaxena18/food-order-dbms
- Repository: https://github.com/aryamansaxena18/food-order-dbms

## Overview

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: [`sql/01_schema.sql`](https://github.com/aryamansaxena18/food-order-dbms/blob/main/sql/01_schema.sql) (Normalized Tables), [`sql/02_data.sql`](https://github.com/aryamansaxena18/food-order-dbms/blob/main/sql/02_data.sql) (Load and Normalize), [`sql/05_triggers.sql`](https://github.com/aryamansaxena18/food-order-dbms/blob/main/sql/05_triggers.sql) (Audit Triggers), [`sql/03_views_indexes.sql`](https://github.com/aryamansaxena18/food-order-dbms/blob/main/sql/03_views_indexes.sql) (Views and Indexes)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data["Data Model"]
  node_dataset["Food-order CSV"]
  node_staging[("Staging Table<br/>[01_schema.sql]")]
  node_normalized[("Normalized Tables<br/>[01_schema.sql]")]
  node_loader["Load and Normalize<br/>[02_data.sql]"]
end

subgraph group_logic["Database Logic"]
  node_stored_programs["Stored Programs<br/>[04_plsql.sql]"]
  node_triggers["Audit Triggers<br/>[05_triggers.sql]"]
  node_audit[("Order Audit<br/>[01_schema.sql]")]
end

subgraph group_analysis["Querying and Analysis"]
  node_views_indexes["Views and Indexes"]
  node_queries["SQL Queries<br/>[06_queries.sql]"]
  node_optimization["Query Optimization"]
end

subgraph group_operations["Database Operations"]
  node_dml_tcl["DML and TCL<br/>[07_dml_tcl.sql]"]
  node_transactions["Transactions"]
end

node_operator(("Database User"))

node_dataset -->|"loads into"| node_staging
node_loader -->|"loads data"| node_staging
node_loader -->|"transforms into"| node_normalized
node_staging -->|"transformed into"| node_normalized
node_normalized -->|"queried by"| node_queries
node_normalized -->|"views represent"| node_views_indexes
node_normalized -->|"indexes support"| node_views_indexes
node_triggers -->|"records changes"| node_audit
node_normalized -->|"order changes fire"| node_triggers
node_operator -->|"runs queries"| node_queries
node_operator -->|"uses routines"| node_stored_programs
node_operator -->|"executes statements"| node_dml_tcl
node_operator -->|"manages transactions"| node_transactions
node_operator -->|"analyzes plans"| node_optimization

click node_dataset "https://github.com/aryamansaxena18/food-order-dbms/blob/main/data/food_order%20data%20set.csv"
click node_staging "https://github.com/aryamansaxena18/food-order-dbms/blob/main/sql/01_schema.sql"
click node_normalized "https://github.com/aryamansaxena18/food-order-dbms/blob/main/sql/01_schema.sql"
click node_loader "https://github.com/aryamansaxena18/food-order-dbms/blob/main/sql/02_data.sql"
click node_views_indexes "https://github.com/aryamansaxena18/food-order-dbms/blob/main/sql/03_views_indexes.sql"
click node_stored_programs "https://github.com/aryamansaxena18/food-order-dbms/blob/main/sql/04_plsql.sql"
click node_triggers "https://github.com/aryamansaxena18/food-order-dbms/blob/main/sql/05_triggers.sql"
click node_audit "https://github.com/aryamansaxena18/food-order-dbms/blob/main/sql/01_schema.sql"
click node_queries "https://github.com/aryamansaxena18/food-order-dbms/blob/main/sql/06_queries.sql"
click node_dml_tcl "https://github.com/aryamansaxena18/food-order-dbms/blob/main/sql/07_dml_tcl.sql"
click node_transactions "https://github.com/aryamansaxena18/food-order-dbms/blob/main/sql/08_transactions.sql"
click node_optimization "https://github.com/aryamansaxena18/food-order-dbms/blob/main/sql/09_storage_query_opt.sql"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_dataset,node_staging,node_normalized,node_loader toneBlue
class node_stored_programs,node_triggers,node_audit,node_operator toneAmber
class node_views_indexes,node_queries,node_optimization toneMint
class node_dml_tcl,node_transactions toneRose
```

## Components

### Data Model

- [Food-order CSV](https://github.com/aryamansaxena18/food-order-dbms/blob/main/data/food_order%20data%20set.csv): `data/food_order data set.csv`
- [Staging Table](https://github.com/aryamansaxena18/food-order-dbms/blob/main/sql/01_schema.sql): `sql/01_schema.sql`
- [Normalized Tables](https://github.com/aryamansaxena18/food-order-dbms/blob/main/sql/01_schema.sql): `sql/01_schema.sql`
- [Load and Normalize](https://github.com/aryamansaxena18/food-order-dbms/blob/main/sql/02_data.sql): `sql/02_data.sql`

### Database Logic

- [Stored Programs](https://github.com/aryamansaxena18/food-order-dbms/blob/main/sql/04_plsql.sql): `sql/04_plsql.sql`
- [Audit Triggers](https://github.com/aryamansaxena18/food-order-dbms/blob/main/sql/05_triggers.sql): `sql/05_triggers.sql`
- [Order Audit](https://github.com/aryamansaxena18/food-order-dbms/blob/main/sql/01_schema.sql): `sql/01_schema.sql`

### Querying and Analysis

- [Views and Indexes](https://github.com/aryamansaxena18/food-order-dbms/blob/main/sql/03_views_indexes.sql): `sql/03_views_indexes.sql`
- [SQL Queries](https://github.com/aryamansaxena18/food-order-dbms/blob/main/sql/06_queries.sql): `sql/06_queries.sql`
- [Query Optimization](https://github.com/aryamansaxena18/food-order-dbms/blob/main/sql/09_storage_query_opt.sql): `sql/09_storage_query_opt.sql`

### Database Operations

- [DML and TCL](https://github.com/aryamansaxena18/food-order-dbms/blob/main/sql/07_dml_tcl.sql): `sql/07_dml_tcl.sql`
- [Transactions](https://github.com/aryamansaxena18/food-order-dbms/blob/main/sql/08_transactions.sql): `sql/08_transactions.sql`

### Other components

- **Database User**

## Connections

- Food-order CSV → Staging Table: loads into (evidence: `readme.md`)
- Load and Normalize → Staging Table: loads data (evidence: `readme.md`)
- Load and Normalize → Normalized Tables: transforms into (evidence: `readme.md`)
- Staging Table → Normalized Tables: transformed into (evidence: `readme.md`)
- Normalized Tables → SQL Queries: queried by (evidence: `readme.md`)
- Normalized Tables → Views and Indexes: views represent (evidence: `readme.md`)
- Normalized Tables → Views and Indexes: indexes support (evidence: `readme.md`)
- Audit Triggers → Order Audit: records changes (evidence: `readme.md`)
- Normalized Tables → Audit Triggers: order changes fire (evidence: `readme.md`)
- Database User → SQL Queries: runs queries (evidence: `readme.md`)
- Database User → Stored Programs: uses routines (evidence: `readme.md`)
- Database User → DML and TCL: executes statements (evidence: `readme.md`)
- Database User → Transactions: manages transactions (evidence: `readme.md`)
- Database User → Query Optimization: analyzes plans (evidence: `readme.md`)
