# tamoziit/dbms_lab architecture

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

- Interactive diagram: https://gitdiagram.com/tamoziit/dbms_lab
- Repository: https://github.com/tamoziit/dbms_lab

## Overview

DBMS_Lab is a collection of SQL and PL/SQL lab examples, not a connected application with a documented runtime workflow. The README identifies the subject broadly as RDBMS and SQL; the file names indicate topics such as schemas, constraints, queries, functions, and triggers. Source excerpts are unavailable, so relationships between scripts and their execution behavior cannot be verified. The map groups the examples by apparent topic without asserting that one script invokes or feeds another.

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_schema["Schemas and Constraints"]
  node_students["Students<br/>[Students.sql]"]
  node_employee["Employee<br/>[Employee.sql]"]
  node_employee_constraints1["Employee Constraints"]
  node_employee_department["Employee Department"]
  node_self_reference["Self Reference"]
  node_day2_notes["Day Two SQL<br/>[day2_Rem.sql]"]
  node_d4a["D4a SQL<br/>[D4a.sql]"]
  node_d4b["D4b SQL<br/>[D4b.sql]"]
  node_employee_constraints2["Employee Constraints Two"]
  node_person_orders["Person Orders<br/>[Person_Orders.sql]"]
end

subgraph group_queries["SQL Queries"]
  node_nested_queries["Nested Queries<br/>[Nested_Queries.sql]"]
  node_joins["Joins<br/>[join.sql]"]
  node_having["Having Clause<br/>[Having_clause.sql]"]
end

subgraph group_plsql["PL/SQL Examples"]
  node_accounts["Accounts<br/>[accounts.sql]"]
  node_area["Area<br/>[area.sql]"]
  node_factorial["Factorial<br/>[factorial.sql]"]
  node_plsql_examples["PL/SQL Examples<br/>[plsql.sql]"]
  node_functions["Functions<br/>[Functions.sql]"]
end

subgraph group_practice["Practice Examples"]
  node_audit_trigger["Audit Trigger<br/>[audit_trigger.sql]"]
  node_delete_trigger["Delete Trigger<br/>[delete_trigger.sql]"]
  node_practice_d1["Practice D1<br/>[d1.sql]"]
  node_practice_d2["Practice D2<br/>[d2.sql]"]
  node_practice_d3["Practice D3<br/>[d3.sql]"]
  node_practice_d4["Practice D4<br/>[d4.sql]"]
  node_practice_d5["Practice D5<br/>[d5.sql]"]
  node_practice_d6["Practice D6<br/>[d6.sql]"]
  node_practice_d7["Practice D7<br/>[d7.sql]"]
  node_practice_plsql["Practice PL/SQL<br/>[plsql.sql]"]
  node_records["Records<br/>[records.sql]"]
end

click node_students "https://github.com/tamoziit/dbms_lab/blob/main/day0/Students.sql"
click node_employee "https://github.com/tamoziit/dbms_lab/blob/main/day1/Employee.sql"
click node_employee_constraints1 "https://github.com/tamoziit/dbms_lab/blob/main/day2/Employee_Constraints1.sql"
click node_employee_department "https://github.com/tamoziit/dbms_lab/blob/main/day2/Employee_Department.sql"
click node_self_reference "https://github.com/tamoziit/dbms_lab/blob/main/day2/Self_Referencial_Foreing_Key.sql"
click node_day2_notes "https://github.com/tamoziit/dbms_lab/blob/main/day2/day2_Rem.sql"
click node_d4a "https://github.com/tamoziit/dbms_lab/blob/main/day3/D4a.sql"
click node_d4b "https://github.com/tamoziit/dbms_lab/blob/main/day3/D4b.sql"
click node_employee_constraints2 "https://github.com/tamoziit/dbms_lab/blob/main/day3/Employees_Constraint_2.sql"
click node_person_orders "https://github.com/tamoziit/dbms_lab/blob/main/day3/Person_Orders.sql"
click node_nested_queries "https://github.com/tamoziit/dbms_lab/blob/main/day5/Nested_Queries.sql"
click node_joins "https://github.com/tamoziit/dbms_lab/blob/main/day5/join.sql"
click node_having "https://github.com/tamoziit/dbms_lab/blob/main/day6/Having_clause.sql"
click node_accounts "https://github.com/tamoziit/dbms_lab/blob/main/PL_SQL/accounts.sql"
click node_area "https://github.com/tamoziit/dbms_lab/blob/main/PL_SQL/area.sql"
click node_factorial "https://github.com/tamoziit/dbms_lab/blob/main/PL_SQL/factorial.sql"
click node_plsql_examples "https://github.com/tamoziit/dbms_lab/blob/main/PL_SQL/plsql.sql"
click node_functions "https://github.com/tamoziit/dbms_lab/blob/main/day4/Functions.sql"
click node_audit_trigger "https://github.com/tamoziit/dbms_lab/blob/main/practice/audit_trigger.sql"
click node_delete_trigger "https://github.com/tamoziit/dbms_lab/blob/main/practice/delete_trigger.sql"
click node_practice_d1 "https://github.com/tamoziit/dbms_lab/blob/main/practice/d1.sql"
click node_practice_d2 "https://github.com/tamoziit/dbms_lab/blob/main/practice/d2.sql"
click node_practice_d3 "https://github.com/tamoziit/dbms_lab/blob/main/practice/d3.sql"
click node_practice_d4 "https://github.com/tamoziit/dbms_lab/blob/main/practice/d4.sql"
click node_practice_d5 "https://github.com/tamoziit/dbms_lab/blob/main/practice/d5.sql"
click node_practice_d6 "https://github.com/tamoziit/dbms_lab/blob/main/practice/d6.sql"
click node_practice_d7 "https://github.com/tamoziit/dbms_lab/blob/main/practice/d7.sql"
click node_practice_plsql "https://github.com/tamoziit/dbms_lab/blob/main/practice/plsql.sql"
click node_records "https://github.com/tamoziit/dbms_lab/blob/main/practice/records.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_students,node_employee,node_employee_constraints1,node_employee_department,node_self_reference,node_day2_notes,node_d4a,node_d4b,node_employee_constraints2,node_person_orders toneBlue
class node_nested_queries,node_joins,node_having toneAmber
class node_accounts,node_area,node_factorial,node_plsql_examples,node_functions toneMint
class node_audit_trigger,node_delete_trigger,node_practice_d1,node_practice_d2,node_practice_d3,node_practice_d4,node_practice_d5,node_practice_d6,node_practice_d7,node_practice_plsql,node_records toneRose
```

## Components

### Schemas and Constraints

- [Students](https://github.com/tamoziit/dbms_lab/blob/main/day0/Students.sql): `day0/Students.sql`
- [Employee](https://github.com/tamoziit/dbms_lab/blob/main/day1/Employee.sql): `day1/Employee.sql`
- [Employee Constraints](https://github.com/tamoziit/dbms_lab/blob/main/day2/Employee_Constraints1.sql): `day2/Employee_Constraints1.sql`
- [Employee Department](https://github.com/tamoziit/dbms_lab/blob/main/day2/Employee_Department.sql): `day2/Employee_Department.sql`
- [Self Reference](https://github.com/tamoziit/dbms_lab/blob/main/day2/Self_Referencial_Foreing_Key.sql): `day2/Self_Referencial_Foreing_Key.sql`
- [Day Two SQL](https://github.com/tamoziit/dbms_lab/blob/main/day2/day2_Rem.sql): `day2/day2_Rem.sql`
- [D4a SQL](https://github.com/tamoziit/dbms_lab/blob/main/day3/D4a.sql): `day3/D4a.sql`
- [D4b SQL](https://github.com/tamoziit/dbms_lab/blob/main/day3/D4b.sql): `day3/D4b.sql`
- [Employee Constraints Two](https://github.com/tamoziit/dbms_lab/blob/main/day3/Employees_Constraint_2.sql): `day3/Employees_Constraint_2.sql`
- [Person Orders](https://github.com/tamoziit/dbms_lab/blob/main/day3/Person_Orders.sql): `day3/Person_Orders.sql`

### SQL Queries

- [Nested Queries](https://github.com/tamoziit/dbms_lab/blob/main/day5/Nested_Queries.sql): `day5/Nested_Queries.sql`
- [Joins](https://github.com/tamoziit/dbms_lab/blob/main/day5/join.sql): `day5/join.sql`
- [Having Clause](https://github.com/tamoziit/dbms_lab/blob/main/day6/Having_clause.sql): `day6/Having_clause.sql`

### PL/SQL Examples

- [Accounts](https://github.com/tamoziit/dbms_lab/blob/main/PL_SQL/accounts.sql): `PL_SQL/accounts.sql`
- [Area](https://github.com/tamoziit/dbms_lab/blob/main/PL_SQL/area.sql): `PL_SQL/area.sql`
- [Factorial](https://github.com/tamoziit/dbms_lab/blob/main/PL_SQL/factorial.sql): `PL_SQL/factorial.sql`
- [PL/SQL Examples](https://github.com/tamoziit/dbms_lab/blob/main/PL_SQL/plsql.sql): `PL_SQL/plsql.sql`
- [Functions](https://github.com/tamoziit/dbms_lab/blob/main/day4/Functions.sql): `day4/Functions.sql`

### Practice Examples

- [Audit Trigger](https://github.com/tamoziit/dbms_lab/blob/main/practice/audit_trigger.sql): `practice/audit_trigger.sql`
- [Delete Trigger](https://github.com/tamoziit/dbms_lab/blob/main/practice/delete_trigger.sql): `practice/delete_trigger.sql`
- [Practice D1](https://github.com/tamoziit/dbms_lab/blob/main/practice/d1.sql): `practice/d1.sql`
- [Practice D2](https://github.com/tamoziit/dbms_lab/blob/main/practice/d2.sql): `practice/d2.sql`
- [Practice D3](https://github.com/tamoziit/dbms_lab/blob/main/practice/d3.sql): `practice/d3.sql`
- [Practice D4](https://github.com/tamoziit/dbms_lab/blob/main/practice/d4.sql): `practice/d4.sql`
- [Practice D5](https://github.com/tamoziit/dbms_lab/blob/main/practice/d5.sql): `practice/d5.sql`
- [Practice D6](https://github.com/tamoziit/dbms_lab/blob/main/practice/d6.sql): `practice/d6.sql`
- [Practice D7](https://github.com/tamoziit/dbms_lab/blob/main/practice/d7.sql): `practice/d7.sql`
- [Practice PL/SQL](https://github.com/tamoziit/dbms_lab/blob/main/practice/plsql.sql): `practice/plsql.sql`
- [Records](https://github.com/tamoziit/dbms_lab/blob/main/practice/records.sql): `practice/records.sql`
