# ahmadayman28/optimization-of-the-tourism-industry architecture

> Architecture diagram of the GitHub repository ahmadayman28/optimization-of-the-tourism-industry, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2025-07-23). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/ahmadayman28/optimization-of-the-tourism-industry
- Repository: https://github.com/ahmadayman28/optimization-of-the-tourism-industry

## Overview

##### Project Type and Purpose
- This is a hybrid full-stack desktop application plus data-science pipeline.
- It combines:
– A relational database (SQL Server) for persistent storage of packages, budgets, resources, and results
– An ETL layer (Python/Jupyter notebooks) for data preprocessing, integration, and mathematical modeling
– Optimization engines (exact MILP via PuLP, Genetic Algorithm, Ant Colony) implemented in Python
– An AI forecasting component (seven ML models exposed via a Tkinter GUI)
– A C# Windows-Forms user interface for admin operations (role-based access for SuperAdmin, Manager, etc.)

##### Main Components
A. Data Sources
– Excel files (Budget.xlsx, PackageSeason.xlsx, Resource.xlsx, TourPackage.xlsx)
– External raw data (historical booking records, market research, social media)
B. ETL & Preprocessing
– “Ui/Code for First Normal Form on data” notebooks
– “Ui/Code For Import Data from Excel into Database” notebooks
C. Database Layer
– Tables: Packages, Seasons, Resources, Budgets, Predictions, OptimizationResults
D. Business Logic & Modeling
– Mathematical model notebooks (“Exact Solution.ipynb”)
– Meta-heuristic algorithm notebooks (GA, AC)
– Data‐analysis notebooks for trend analysis and visualization
E. AI Prediction Model
– Jupyter notebooks in “AI Prediction Model & GUI”
– Tkinter-based GUI for forecasting demand with multiple regressors
F. User Interface (Desktop App)
– C# Windows Forms solution (“GP Optimization of Tourism Industry.sln”)
– Forms: LoginForm, AdminDashboardForm, SuperAdminDashboardForm
– Role-based access control, CRUD operations on Packages, Budgets, Resources
G. Documentation & Reporting
– PDF/PPTX documents, Excel dashboards for descriptive statistics, trend charts

##### Relationships & Data Flows
1. Excel → ETL notebooks → SQL Server (initial load & normalization)
2. SQL Server ↔ C# UI (CRUD operations by admins)
3. SQL Server → Optimization notebooks (Exact/GA/AC) → Results → SQL Server or output files
4. SQL Server & cleaned datasets → AI notebooks → Predictions → Tkinter GUI → end‐users
5. Reporting outputs (graphs, charts) generated by Jupyter and by Excel dashboards

##### Architectural Patterns & Design Principles
- Layered Architecture:
– Data Layer (SQL Server)
– Service/Processing Layer (Python ETL, optimization, AI models)
– Presentation Layer (C# WinForms, Tkinter GUI)
- Separation of Concerns: ETL, modeling, UI are distinct modules
- Extensibility Points: New optimization algorithms or ML models plug into the Jupyter workflow
- Role-Based Access: Enforced in the C# app, decoupled from data storage

## Diagram (Mermaid)

```mermaid
flowchart TB
    %% Data Sources
    subgraph "Data Sources"
        direction TB
        ExcelBudget["Budget.xlsx"]:::storage
        ExcelPackageSeason["PackageSeason.xlsx"]:::storage
        ExcelResource["Resource.xlsx"]:::storage
        ExcelTourPackage["TourPackage.xlsx"]:::storage
        ExternalRawData["External Raw Data"]:::storage
    end

    %% ETL & Preprocessing Layer
    subgraph "ETL & Preprocessing" 
        direction TB
        FNF["First Normal Form Notebook"]:::processing
        ImportBudget["Import Budget.ipynb"]:::processing
        ImportPackageSeason["Import PackageSeason.ipynb"]:::processing
        ImportResource["Import Resource.ipynb"]:::processing
        ImportTourPackage["Import TourPackage.ipynb"]:::processing
    end

    %% Database Layer
    SQLServer[(SQL Server)]:::storage
    ERDDiagram["GP Design.sql"]:::processing

    %% Business Logic & Modeling
    subgraph "Optimization Notebooks"
        direction TB
        ExactSolver["Exact Solution.ipynb"]:::processing
        GeneticAlgo["Genetic Algorithm.ipynb"]:::processing
        CompareGAAC["Comparison Between (GA , AC).ipynb"]:::processing
    end

    %% AI Prediction Model
    subgraph "AI Prediction Model"
        direction TB
        AIModel["AI_for_GP.ipynb"]:::processing
        CompareModels["Compare Models.ipynb"]:::processing
        TkinterGUI["Tkinter Forecast GUI"]:::ui
    end

    %% User Interface
    subgraph "C# Desktop Application"
        direction TB
        SolutionFile["GP Optimization of Tourism Industry.sln"]:::ui
        LoginForm["LoginForm.cs"]:::ui
        AdminDashboard["AdminDashboardForm.cs"]:::ui
        SuperAdminDashboard["SuperAdminDashboardForm.cs"]:::ui
        ProgramFile["Program.cs"]:::ui
    end

    %% Documentation & Reporting
    subgraph "Documentation & Reporting"
        direction TB
        PDFReport["OPTIMIZATION OF TOURISM INDUSTRY.pdf"]:::doc
        PPTReport["Optimization of Tourism Industry.pptx"]:::doc
        SummaryPDF["Project Summary.pdf"]:::doc
    end

    %% Data Flows
    ExcelBudget -->|load| FNF
    ExcelPackageSeason -->|load| FNF
    ExcelResource -->|load| FNF
    ExcelTourPackage -->|load| FNF
    FNF -->|"normalized data"| SQLServer
    ImportBudget -->|insert| SQLServer
    ImportPackageSeason -->|insert| SQLServer
    ImportResource -->|insert| SQLServer
    ImportTourPackage -->|insert| SQLServer

    SQLServer <-->|CRUD| SolutionFile
    SolutionFile -->|calls| LoginForm
    SolutionFile -->|calls| AdminDashboard
    SolutionFile -->|calls| SuperAdminDashboard
    SolutionFile -->|runs| ProgramFile

    SQLServer -->|data| ExactSolver
    SQLServer -->|data| GeneticAlgo
    SQLServer -->|data| CompareGAAC
    ExactSolver -->|results| SQLServer
    GeneticAlgo -->|results| SQLServer
    CompareGAAC -->|results| SQLServer

    SQLServer -->|cleaned data| AIModel
    AIModel -->|predictions| SQLServer
    AIModel -->|feeds| TkinterGUI

    AIModel -->|charts| PDFReport
    GeneticAlgo -->|charts| PPTReport
    ExactSolver -- "performance notes" --> SummaryPDF

    %% Click Events
    click ExcelBudget "https://github.com/ahmadayman28/optimization-of-the-tourism-industry/blob/main/Ui/Excel Data/Budget.xlsx"
    click ExcelPackageSeason "https://github.com/ahmadayman28/optimization-of-the-tourism-industry/blob/main/Ui/Excel Data/PackageSeason.xlsx"
    click ExcelResource "https://github.com/ahmadayman28/optimization-of-the-tourism-industry/blob/main/Ui/Excel Data/Resource.xlsx"
    click ExcelTourPackage "https://github.com/ahmadayman28/optimization-of-the-tourism-industry/blob/main/Ui/Excel Data/TourPackage.xlsx"

    click FNF "https://github.com/ahmadayman28/optimization-of-the-tourism-industry/blob/main/Ui/Code for First Normal Form on data/First Normal Form of data.ipynb"
    click ImportBudget "https://github.com/ahmadayman28/optimization-of-the-tourism-industry/blob/main/Ui/Code For Import Data from Excel into Database/Budget.ipynb"
    click ImportPackageSeason "https://github.com/ahmadayman28/optimization-of-the-tourism-industry/blob/main/Ui/Code For Import Data from Excel into Database/PackageSeason.ipynb"
    click ImportResource "https://github.com/ahmadayman28/optimization-of-the-tourism-industry/blob/main/Ui/Code For Import Data from Excel into Database/Resource.ipynb"
    click ImportTourPackage "https://github.com/ahmadayman28/optimization-of-the-tourism-industry/blob/main/Ui/Code For Import Data from Excel into Database/TourPackage.ipynb"

    click ERDDiagram "https://github.com/ahmadayman28/optimization-of-the-tourism-industry/blob/main/Ui/Diagrams/GP Design.sql"

    click ExactSolver "https://github.com/ahmadayman28/optimization-of-the-tourism-industry/blob/main/Solution of the Mathematical Model/Exact Solution.ipynb"
    click GeneticAlgo "https://github.com/ahmadayman28/optimization-of-the-tourism-industry/blob/main/Solution of the Mathematical Model/Genetic Algorithm.ipynb"
    click CompareGAAC "https://github.com/ahmadayman28/optimization-of-the-tourism-industry/blob/main/Solution of the Mathematical Model/Comparison Between (GA , AC).ipynb"

    click AIModel "https://github.com/ahmadayman28/optimization-of-the-tourism-industry/blob/main/AI Prediction Model & GUI/AI_for_GP.ipynb"
    click CompareModels "https://github.com/ahmadayman28/optimization-of-the-tourism-industry/blob/main/AI Prediction Model & GUI/Compare Models.ipynb"

    click SolutionFile "https://github.com/ahmadayman28/optimization-of-the-tourism-industry/blob/main/Ui/GP Optimization of Tourism Industry/GP Optimization of Tourism Industry.sln"
    click LoginForm "https://github.com/ahmadayman28/optimization-of-the-tourism-industry/blob/main/Ui/GP Optimization of Tourism Industry/GP Optimization of Tourism Industry/LoginForm.cs"
    click AdminDashboard "https://github.com/ahmadayman28/optimization-of-the-tourism-industry/blob/main/Ui/GP Optimization of Tourism Industry/GP Optimization of Tourism Industry/AdminDashboardForm.cs"
    click SuperAdminDashboard "https://github.com/ahmadayman28/optimization-of-the-tourism-industry/blob/main/Ui/GP Optimization of Tourism Industry/GP Optimization of Tourism Industry/SuperAdminDashboardForm.cs"
    click ProgramFile "https://github.com/ahmadayman28/optimization-of-the-tourism-industry/blob/main/Ui/GP Optimization of Tourism Industry/GP Optimization of Tourism Industry/Program.cs"

    click PDFReport "https://github.com/ahmadayman28/optimization-of-the-tourism-industry/blob/main/Documentation/OPTIMIZATION OF TOURISM INDUSTRY.pdf"
    click PPTReport "https://github.com/ahmadayman28/optimization-of-the-tourism-industry/blob/main/Documentation/Optimization of Tourism Industry.pptx"
    click SummaryPDF "https://github.com/ahmadayman28/optimization-of-the-tourism-industry/blob/main/Documentation/Project Summary.pdf"

    %% Styles
    classDef storage fill:#cfe2f3,stroke:#000,stroke-width:1px
    classDef processing fill:#d9ead3,stroke:#000,stroke-width:1px
    classDef ui fill:#fff2cc,stroke:#000,stroke-width:1px
    classDef doc fill:#f4cccc,stroke:#000,stroke-width:1px
```
