# sonjoy209164/dtabaseproject1907073 architecture

> Architecture diagram of the GitHub repository sonjoy209164/dtabaseproject1907073, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2025-06-26). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/sonjoy209164/dtabaseproject1907073
- Repository: https://github.com/sonjoy209164/dtabaseproject1907073

## Overview

##### Project type and purpose
- This is a pure database‐centric project (“Furniture Management System”) built entirely in SQL/PL-SQL.
- It contains scripts to define schema (DDL.sql), load and manipulate data (various DML*.sql), define triggers (tigger.sql), PL/SQL procedures (plsql.sql), and test or prep scripts (labtestprep, lab9.sql, labtestprep).

##### File structure
- Top‐level artifacts:
- DDL.sql             → schema definition (tables, constraints, indexes)
- DMLinsertvalues.sql → initial data load
- DMLSearchupdatedelete.sql → CRUD operation scripts
- DMLjoinandview.sql  → join queries and view definitions
- DMLAll.sql          → a consolidated DML script
- tigger.sql          → trigger definitions for enforcing business rules or auditing
- plsql.sql           → stored procedures, functions, packages
- lab9.sql, labtestprep, plsql.sql → test/study scripts
- There is no “frontend” or “backend” code—everything runs inside the RDBMS.

##### README for additional insights
- Title: “DatabaseProject1907073”
- Subtitle: “Furniture Management System”
- No further architectural notes, so we infer domain entities from the DDL (e.g., Furniture, Customers, Orders, Inventory).

## Diagram (Mermaid)

```mermaid
flowchart TB
    %% Metadata Layer
    subgraph "Metadata Layer"
        README["README.md"]:::metadata
    end

    %% Schema Definition Layer
    subgraph "Schema Definition Layer"
        DDL["DDL.sql"]:::script
        DB["FurnitureDB"]:::db
    end

    %% Schema Objects
    subgraph "Schema Objects"
        FUR["FURNITURE"]:::table
        CAT["CATEGORY"]:::table
        SUP["SUPPLIER"]:::table
        CUS["CUSTOMER"]:::table
        ORD["ORDERS"]:::table
        OI["ORDER_ITEMS"]:::table
        INV["INVENTORY"]:::table
    end

    %% Data Manipulation Layer
    subgraph "Data Manipulation Layer"
        DML1["DMLinsertvalues.sql"]:::script
        DML2["DMLSearchupdatedelete.sql"]:::script
        DMLAll["DMLAll.sql"]:::script
    end

    %% Business Logic Layer
    subgraph "Business Logic Layer"
        PL["plsql.sql"]:::script
        TR["tigger.sql"]:::script
    end

    %% Reporting Layer
    subgraph "Reporting Layer"
        VIEW["DMLjoinandview.sql"]:::script
    end

    %% Test & Preparation Layer
    subgraph "Test & Prep Layer"
        LAB9["lab9.sql"]:::script
        LABPrep["labtestprep"]:::script
    end

    %% Relationships
    README --> DDL
    DDL --> DB
    DDL --> FUR
    DDL --> CAT
    DDL --> SUP
    DDL --> CUS
    DDL --> ORD
    DDL --> OI
    DDL --> INV

    DML1 -->|"writes"| FUR
    DML1 -->|"writes"| CAT
    DML1 -->|"writes"| SUP
    DML1 -->|"writes"| CUS
    DML1 -->|"writes"| ORD
    DML1 -->|"writes"| OI
    DML1 -->|"writes"| INV

    DML2 -->|"CRUD"| FUR
    DML2 -->|"CRUD"| CAT
    DML2 -->|"CRUD"| SUP
    DML2 -->|"CRUD"| CUS
    DML2 -->|"CRUD"| ORD
    DML2 -->|"CRUD"| OI
    DML2 -->|"CRUD"| INV

    DMLAll -->|"batch writes"| FUR
    DMLAll -->|"batch writes"| CAT
    DMLAll -->|"batch writes"| SUP
    DMLAll -->|"batch writes"| CUS
    DMLAll -->|"batch writes"| ORD
    DMLAll -->|"batch writes"| OI
    DMLAll -->|"batch writes"| INV

    PL -->|"executes"| FUR
    PL -->|"executes"| CAT
    PL -->|"executes"| SUP
    PL -->|"executes"| CUS
    PL -->|"executes"| ORD
    PL -->|"executes"| OI
    PL -->|"executes"| INV

    TR -->|"on INSERT/UPDATE/DELETE"| FUR
    TR -->|"on INSERT/UPDATE/DELETE"| CAT
    TR -->|"on INSERT/UPDATE/DELETE"| SUP
    TR -->|"on INSERT/UPDATE/DELETE"| CUS
    TR -->|"on INSERT/UPDATE/DELETE"| ORD
    TR -->|"on INSERT/UPDATE/DELETE"| OI
    TR -->|"on INSERT/UPDATE/DELETE"| INV

    FUR -->|"read"| VIEW
    CAT -->|"read"| VIEW
    SUP -->|"read"| VIEW
    CUS -->|"read"| VIEW
    ORD -->|"read"| VIEW
    OI -->|"read"| VIEW
    INV -->|"read"| VIEW

    LAB9 --> DDL
    LAB9 --> DMLAll
    LABPrep --> PL

    %% Click Events
    click DDL "https://github.com/sonjoy209164/dtabaseproject1907073/blob/main/DDL.sql"
    click DML1 "https://github.com/sonjoy209164/dtabaseproject1907073/blob/main/DMLinsertvalues.sql"
    click DML2 "https://github.com/sonjoy209164/dtabaseproject1907073/blob/main/DMLSearchupdatedelete.sql"
    click DMLAll "https://github.com/sonjoy209164/dtabaseproject1907073/blob/main/DMLAll.sql"
    click VIEW "https://github.com/sonjoy209164/dtabaseproject1907073/blob/main/DMLjoinandview.sql"
    click PL "https://github.com/sonjoy209164/dtabaseproject1907073/blob/main/plsql.sql"
    click TR "https://github.com/sonjoy209164/dtabaseproject1907073/blob/main/tigger.sql"
    click LAB9 "https://github.com/sonjoy209164/dtabaseproject1907073/blob/main/lab9.sql"
    click LABPrep "https://github.com/sonjoy209164/dtabaseproject1907073/tree/main/labtestprep"
    click README "https://github.com/sonjoy209164/dtabaseproject1907073/blob/main/README.md"

    %% Styles
    classDef script fill:#f9f,stroke:#333,stroke-width:1px;
    classDef db fill:#ccf,stroke:#333,stroke-width:1px;
    classDef table fill:#cfc,stroke:#333,stroke-width:1px;
    classDef metadata fill:#ffc,stroke:#333,stroke-width:1px;
```
