# abonaeem657/pharmacy-database architecture

> Architecture diagram of the GitHub repository abonaeem657/pharmacy-database, 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/abonaeem657/pharmacy-database
- Repository: https://github.com/abonaeem657/pharmacy-database

## Overview

This repository is an Oracle pharmacy-database design and usage example, not an application service. Its documented workflow is to create the relational schema, load sample records, run queries to explore the data, and optionally perform updates. Separate capabilities include ER modeling, a salary-calculation PL/SQL procedure, and role-based access control. The README identifies these capabilities and run steps; no SQL excerpts were provided, so internal SQL dependencies are not inferred.

Main entry points: [`SQL-Scripts/1_create_tables.sql`](https://github.com/abonaeem657/pharmacy-database/blob/main/SQL-Scripts/1_create_tables.sql) (Pharmacy Schema), [`SQL-Scripts/2_insert_data.sql`](https://github.com/abonaeem657/pharmacy-database/blob/main/SQL-Scripts/2_insert_data.sql) (Sample Data), [`SQL-Scripts/3_select_queries.sql`](https://github.com/abonaeem657/pharmacy-database/blob/main/SQL-Scripts/3_select_queries.sql) (Query Examples), [`SQL-Scripts/4_update_queries.sql`](https://github.com/abonaeem657/pharmacy-database/blob/main/SQL-Scripts/4_update_queries.sql) (Data Updates)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_modeling["Data Modeling"]
  node_diagrams["ER Diagrams"]
end

subgraph group_database["Oracle Database"]
  node_schema["Pharmacy Schema"]
  node_oracle[("Oracle Database")]
end

subgraph group_operations["Database Operations"]
  node_seed["Sample Data<br/>[2_insert_data.sql]"]
  node_queries["Query Examples"]
  node_salary["Salary Procedure"]
  node_updates["Data Updates"]
  node_access["Role Permissions"]
end

node_operator(("Database User"))

node_operator -->|"executes first"| node_schema
node_schema -->|"creates schema"| node_oracle
node_operator -->|"executes next"| node_seed
node_seed -->|"loads records"| node_oracle
node_operator -->|"runs queries"| node_queries
node_queries -->|"queries data"| node_oracle
node_operator -->|"runs updates"| node_updates
node_updates -->|"updates records"| node_oracle
node_salary -->|"calculates salary"| node_oracle

click node_diagrams "https://github.com/abonaeem657/pharmacy-database/tree/main/ER-Diagrams"
click node_schema "https://github.com/abonaeem657/pharmacy-database/blob/main/SQL-Scripts/1_create_tables.sql"
click node_seed "https://github.com/abonaeem657/pharmacy-database/blob/main/SQL-Scripts/2_insert_data.sql"
click node_queries "https://github.com/abonaeem657/pharmacy-database/blob/main/SQL-Scripts/3_select_queries.sql"
click node_salary "https://github.com/abonaeem657/pharmacy-database/blob/main/SQL-Scripts/3_select_queries.sql"
click node_updates "https://github.com/abonaeem657/pharmacy-database/blob/main/SQL-Scripts/4_update_queries.sql"
click node_access "https://github.com/abonaeem657/pharmacy-database/tree/main/SQL-Scripts"

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_diagrams toneBlue
class node_schema,node_oracle,node_operator toneAmber
class node_seed,node_queries,node_salary,node_updates,node_access toneMint
```

## Components

### Data Modeling

- [ER Diagrams](https://github.com/abonaeem657/pharmacy-database/tree/main/ER-Diagrams): `ER-Diagrams`

### Oracle Database

- [Pharmacy Schema](https://github.com/abonaeem657/pharmacy-database/blob/main/SQL-Scripts/1_create_tables.sql): `SQL-Scripts/1_create_tables.sql`
- **Oracle Database**

### Database Operations

- [Sample Data](https://github.com/abonaeem657/pharmacy-database/blob/main/SQL-Scripts/2_insert_data.sql): `SQL-Scripts/2_insert_data.sql`
- [Query Examples](https://github.com/abonaeem657/pharmacy-database/blob/main/SQL-Scripts/3_select_queries.sql): `SQL-Scripts/3_select_queries.sql`
- [Salary Procedure](https://github.com/abonaeem657/pharmacy-database/blob/main/SQL-Scripts/3_select_queries.sql): `SQL-Scripts/3_select_queries.sql`
- [Data Updates](https://github.com/abonaeem657/pharmacy-database/blob/main/SQL-Scripts/4_update_queries.sql): `SQL-Scripts/4_update_queries.sql`
- [Role Permissions](https://github.com/abonaeem657/pharmacy-database/tree/main/SQL-Scripts): `SQL-Scripts`

### Other components

- **Database User**

## Connections

- Database User → Pharmacy Schema: executes first (evidence: `README.md`)
- Pharmacy Schema → Oracle Database: creates schema (evidence: `README.md`)
- Database User → Sample Data: executes next (evidence: `README.md`)
- Sample Data → Oracle Database: loads records (evidence: `README.md`)
- Database User → Query Examples: runs queries (evidence: `README.md`)
- Query Examples → Oracle Database: queries data (evidence: `README.md`)
- Database User → Data Updates: runs updates (evidence: `README.md`)
- Data Updates → Oracle Database: updates records (evidence: `README.md`)
- Salary Procedure → Oracle Database: calculates salary (evidence: `README.md`)
