# aljolandaalhandhali/database architecture

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

- Interactive diagram: https://gitdiagram.com/aljolandaalhandhali/database
- Repository: https://github.com/aljolandaalhandhali/database

## Overview

This repository is a collection of database coursework and an EMS database capstone, not a conventional application with a demonstrated user-facing runtime. The clearest implementation workflow is schema definition and data manipulation, alongside query, reporting, and database-programming materials. The README is only a title and no source excerpts were supplied, so connections beyond the operations indicated by filenames are omitted.

Main entry points: [`EMSDatabaseProject/Implementation/DDL.sql`](https://github.com/aljolandaalhandhali/database/blob/main/EMSDatabaseProject/Implementation/DDL.sql) (Schema definition), [`EMSDatabaseProject/Implementation/DML.sql`](https://github.com/aljolandaalhandhali/database/blob/main/EMSDatabaseProject/Implementation/DML.sql) (Data manipulation), [`EMSDatabaseProject/Implementation/Views.sql`](https://github.com/aljolandaalhandhali/database/blob/main/EMSDatabaseProject/Implementation/Views.sql) (Views), [`EMSDatabaseProject/Implementation/StoredProceduresAndFunctions.sql`](https://github.com/aljolandaalhandhali/database/blob/main/EMSDatabaseProject/Implementation/StoredProceduresAndFunctions.sql) (Procedures and functions)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_ems["EMS database"]
  node_schema["Schema definition<br/>[DDL.sql]"]
  node_data["Data manipulation<br/>[DML.sql]"]
  node_views["Views<br/>[Views.sql]"]
  node_procedures["Procedures and functions"]
  node_triggers["Triggers<br/>[Triggers.sql]"]
  node_jobs["Scheduled jobs"]
  node_capstone["Capstone overview"]
end

subgraph group_query["Query and reporting"]
  node_joins["Join queries<br/>[Joins.sql]"]
  node_subqueries["Subqueries<br/>[Subqueries.sql]"]
  node_aggregations["Aggregation functions"]
end

subgraph group_coursework["Database coursework"]
  node_joinpractice["Join practice"]
  node_subqueryreports["Subquery analytics"]
  node_queryreview["Query logic review"]
  node_validation["Query validation"]
  node_sqljoins["SQL join study"]
  node_setops["Set operations"]
  node_enterprise["Enterprise assignment<br/>[Assignment.pdf]"]
  node_reports["Database investigation"]
end

node_engineer(("Database engineer"))
node_database[("Oracle database")]

node_schema -->|"defines schema"| node_database
node_data -->|"manipulates data"| node_database
node_views -->|"defines views"| node_database
node_procedures -->|"defines routines"| node_database
node_triggers -->|"defines triggers"| node_database
node_jobs -->|"defines jobs"| node_database
node_joins -->|"queries data"| node_database
node_subqueries -->|"queries data"| node_database
node_aggregations -->|"aggregates data"| node_database

click node_schema "https://github.com/aljolandaalhandhali/database/blob/main/EMSDatabaseProject/Implementation/DDL.sql"
click node_data "https://github.com/aljolandaalhandhali/database/blob/main/EMSDatabaseProject/Implementation/DML.sql"
click node_views "https://github.com/aljolandaalhandhali/database/blob/main/EMSDatabaseProject/Implementation/Views.sql"
click node_procedures "https://github.com/aljolandaalhandhali/database/blob/main/EMSDatabaseProject/Implementation/StoredProceduresAndFunctions.sql"
click node_triggers "https://github.com/aljolandaalhandhali/database/blob/main/EMSDatabaseProject/Implementation/Triggers.sql"
click node_jobs "https://github.com/aljolandaalhandhali/database/blob/main/EMSDatabaseProject/Implementation/OracleSchedulerJobs.sql"
click node_joins "https://github.com/aljolandaalhandhali/database/blob/main/EMSDatabaseProject/Implementation/Joins.sql"
click node_subqueries "https://github.com/aljolandaalhandhali/database/blob/main/EMSDatabaseProject/Implementation/Subqueries.sql"
click node_aggregations "https://github.com/aljolandaalhandhali/database/blob/main/EMSDatabaseProject/Implementation/AggregationFunctions.sql"
click node_capstone "https://github.com/aljolandaalhandhali/database/blob/main/EMSDatabaseProject/CapstoneProject.pdf"
click node_joinpractice "https://github.com/aljolandaalhandhali/database/blob/main/JOINPracticeTask/OracleHRSchemaJOINPracticeTask.pdf"
click node_subqueryreports "https://github.com/aljolandaalhandhali/database/blob/main/SubqueryAnalyticsAndBusinessReporting/SubqueriesAnalyticalReports.pdf"
click node_queryreview "https://github.com/aljolandaalhandhali/database/blob/main/SubqueryLogicReviewAndExecutionAnalysis/SubqueryLogicReviewAndExecutionAnalysis.pdf"
click node_validation "https://github.com/aljolandaalhandhali/database/blob/main/QueryLogicValidation/CodeReviewAndQueryLogicValidation.pdf"
click node_sqljoins "https://github.com/aljolandaalhandhali/database/blob/main/SQLJOINImplementation/SQLJOINImplementation.pdf"
click node_setops "https://github.com/aljolandaalhandhali/database/blob/main/SQLSetOperationsResearch/SQLSetOperations.pdf"
click node_enterprise "https://github.com/aljolandaalhandhali/database/blob/main/EnterpriseDatabaseEngineeringAssignment/Assignment.pdf"
click node_reports "https://github.com/aljolandaalhandhali/database/blob/main/reports/Database-Investigation.pdf"

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_schema,node_data,node_views,node_procedures,node_triggers,node_jobs,node_capstone toneBlue
class node_joins,node_subqueries,node_aggregations,node_engineer,node_database toneAmber
class node_joinpractice,node_subqueryreports,node_queryreview,node_validation,node_sqljoins,node_setops,node_enterprise,node_reports toneMint
```

## Components

### EMS database

- [Schema definition](https://github.com/aljolandaalhandhali/database/blob/main/EMSDatabaseProject/Implementation/DDL.sql): `EMSDatabaseProject/Implementation/DDL.sql`
- [Data manipulation](https://github.com/aljolandaalhandhali/database/blob/main/EMSDatabaseProject/Implementation/DML.sql): `EMSDatabaseProject/Implementation/DML.sql`
- [Views](https://github.com/aljolandaalhandhali/database/blob/main/EMSDatabaseProject/Implementation/Views.sql): `EMSDatabaseProject/Implementation/Views.sql`
- [Procedures and functions](https://github.com/aljolandaalhandhali/database/blob/main/EMSDatabaseProject/Implementation/StoredProceduresAndFunctions.sql): `EMSDatabaseProject/Implementation/StoredProceduresAndFunctions.sql`
- [Triggers](https://github.com/aljolandaalhandhali/database/blob/main/EMSDatabaseProject/Implementation/Triggers.sql): `EMSDatabaseProject/Implementation/Triggers.sql`
- [Scheduled jobs](https://github.com/aljolandaalhandhali/database/blob/main/EMSDatabaseProject/Implementation/OracleSchedulerJobs.sql): `EMSDatabaseProject/Implementation/OracleSchedulerJobs.sql`
- [Capstone overview](https://github.com/aljolandaalhandhali/database/blob/main/EMSDatabaseProject/CapstoneProject.pdf): `EMSDatabaseProject/CapstoneProject.pdf`

### Query and reporting

- [Join queries](https://github.com/aljolandaalhandhali/database/blob/main/EMSDatabaseProject/Implementation/Joins.sql): `EMSDatabaseProject/Implementation/Joins.sql`
- [Subqueries](https://github.com/aljolandaalhandhali/database/blob/main/EMSDatabaseProject/Implementation/Subqueries.sql): `EMSDatabaseProject/Implementation/Subqueries.sql`
- [Aggregation functions](https://github.com/aljolandaalhandhali/database/blob/main/EMSDatabaseProject/Implementation/AggregationFunctions.sql): `EMSDatabaseProject/Implementation/AggregationFunctions.sql`

### Database coursework

- [Join practice](https://github.com/aljolandaalhandhali/database/blob/main/JOINPracticeTask/OracleHRSchemaJOINPracticeTask.pdf): `JOINPracticeTask/OracleHRSchemaJOINPracticeTask.pdf`
- [Subquery analytics](https://github.com/aljolandaalhandhali/database/blob/main/SubqueryAnalyticsAndBusinessReporting/SubqueriesAnalyticalReports.pdf): `SubqueryAnalyticsAndBusinessReporting/SubqueriesAnalyticalReports.pdf`
- [Query logic review](https://github.com/aljolandaalhandhali/database/blob/main/SubqueryLogicReviewAndExecutionAnalysis/SubqueryLogicReviewAndExecutionAnalysis.pdf): `SubqueryLogicReviewAndExecutionAnalysis/SubqueryLogicReviewAndExecutionAnalysis.pdf`
- [Query validation](https://github.com/aljolandaalhandhali/database/blob/main/QueryLogicValidation/CodeReviewAndQueryLogicValidation.pdf): `QueryLogicValidation/CodeReviewAndQueryLogicValidation.pdf`
- [SQL join study](https://github.com/aljolandaalhandhali/database/blob/main/SQLJOINImplementation/SQLJOINImplementation.pdf): `SQLJOINImplementation/SQLJOINImplementation.pdf`
- [Set operations](https://github.com/aljolandaalhandhali/database/blob/main/SQLSetOperationsResearch/SQLSetOperations.pdf): `SQLSetOperationsResearch/SQLSetOperations.pdf`
- [Enterprise assignment](https://github.com/aljolandaalhandhali/database/blob/main/EnterpriseDatabaseEngineeringAssignment/Assignment.pdf): `EnterpriseDatabaseEngineeringAssignment/Assignment.pdf`
- [Database investigation](https://github.com/aljolandaalhandhali/database/blob/main/reports/Database-Investigation.pdf): `reports/Database-Investigation.pdf`

### Other components

- **Database engineer**
- **Oracle database**

## Connections

- Schema definition → Oracle database: defines schema
- Data manipulation → Oracle database: manipulates data
- Views → Oracle database: defines views
- Procedures and functions → Oracle database: defines routines
- Triggers → Oracle database: defines triggers
- Scheduled jobs → Oracle database: defines jobs
- Join queries → Oracle database: queries data
- Subqueries → Oracle database: queries data
- Aggregation functions → Oracle database: aggregates data