Digitalizing Education Services

Dezenhu & Arkitetura
Sistema
G2 Chatbot ME

Solusaun bazeia ba Web hodi automatiza kestionáriu públiku ba Ministériu Edukasaun liuhusi integrasaun database no algoritmu text-matching.

Arkitektura Dadus

Diagrama Fluxu Dadus (Level 0)

graph LR U[User Publik] -- "Kestionáriu" --> S((SISTEMA CHATBOT)) S -- "Resposta Automátiku" --> U D[Diresaun ME] -- "Informasaun Foun" --> S A[Administrator] -- "Maneja Rules" --> S S -- "Relatóriu & Log" --> A

Diagrama Fluxu Dadus (Level 1)

"Deskompozisaun prosesu husi Diagrama Kontestu ba prosesu detallu."

graph TD classDef entidade fill:#e0e7ff,stroke:#4338ca,stroke-width:2px; classDef prosesu fill:#fff7ed,stroke:#ea580c,stroke-width:2px; classDef database fill:#ecfdf5,stroke:#059669,stroke-width:2px; U[User Publik]:::entidade D[Diresaun ME]:::entidade A[Administrator]:::entidade P1((1.0 Matching)):::prosesu P2((2.0 Verifika)):::prosesu P3((3.0 Konesimentu)):::prosesu P4((4.0 Relatoriu)):::prosesu DB1[(Rules DB)]:::database DB2[(Info DB)]:::database DB3[(History DB)]:::database U --> P1 P1 <--> DB1 P1 --> U P1 --> DB3 D --> P2 P2 --> DB2 A --> P3 P3 <--> DB1 A --> P4 P4 <--> DB3 P4 --> A
Entidade: User, Diresaun, Admin.
Prosesu: Matching, Verifika, Konesimentu, Relatóriu.

Entity Relationship Diagram (ERD)

erDiagram USERS ||--o{ CHAT_HISTORY : "halo" RULES ||--o{ CHAT_HISTORY : "gera" DIRESAUN ||--o{ INFORMATION : "input" RULES { int id PK string keyword text response int hits } CHAT_HISTORY { int id PK string session_id text message timestamp created_at }

Algoritmu Rejolve 'Typo'

"Levenshtein Distance: Sura hira mak diferensa karakter hodi rekoñese lia-fuan sala."

$lev_{a,b}(i,j)$
+

1. Insertion

Aumenta letra ne'ebé falta.

Ex: "Estud" → "Estudu"
Cost: 1
-

2. Deletion

Hasai letra ne'ebé resin.

Ex: "Eskolla" → "Eskola"
Cost: 1

3. Substitution

Troka letra ne'ebé sala.

Ex: "Escola" → "Eskola"
Cost: 1
Lójika Desizaun:

Sistema simu kestionáriu se Total Cost ≤ 2. Ne'e katak maske user halo sala to'o karakter rua (rua troka, ka ida troka ida aumenta), Bot sei nafatin "hatene" saida mak user hakarak no fó resposta ne'ebé loos husi database.

Analiza SWOT

S
Strengths
  • Atendimentu lalais 24/7 sem limitasaun.
  • Bele komprende "typo" (hakerek sala).
  • Maneja kestaun foun liuhusi tabela Unanswered Chats.
W
Weaknesses
  • Depende maka'as ba konesaun internet.
  • Presiza konesimentu database ne'ebé boot hodi hatán kestaun barak liu tan.
  • Seidauk bele komprende kontestu (Natural Language Processing - NLP ne'ebé kle'an).
O
Opportunities
  • Bele integra ho API (WhatsApp, Telegram, etc.).
  • Bele dezenvolve hodi uza kbiit AI/LLM (hanesan OpenAI API).
T
Threats
  • Ataque Cyber hanesan SQL Injection.
  • Kestaun ne'ebé komplika demais bele halo bot fó resposta ne'ebé sala se keywords sira "overlap" (konflitu).

Metodolojia Waterfall

Step 1

Analysis

Identifika problema atendimentu iha ME.

Step 2

Design

Kria DFD, ERD, no UI Mockup.

Step 3

Coding

Implementasaun PHP & MySQL.

Step 4

Testing

Teste lójika & seguransa (SQL Injection).

Step 5

Support

Manutensaun ba konesimentu bot.

Stack Teknolozia & Tools

Development

  • PHP 8.2: Lójika server-side no algoritmu.
  • MySQLi: Jestaun baze de dadus relasionál.
  • Apache: Web server hodi host aplikasaun.

Interface

  • Tailwind CSS: UI modernu no responsivu.
  • Mermaid.js: Vizualizasaun diagrama dinámiku.
  • JavaScript: Interasaun real-time iha chat.

Support Tools

  • VS Code: Code editor prinsipál.
  • XAMPP: Local server environment (PHP/MySQL).
  • Git: Kontrola versaun kódigu (Version Control).

Struktura Ekipa G-2

"Kolaborasaun hodi lori inovasaun ba Ministériu Edukasaun."

N

Nelson

Project Leader & System Architect

  • • Koordena servisu ekipa nian hodi tuir timeline.
  • • Dezenu arkitektura sistema (DFD & ERD).
  • • Responsável ba desizaun tékniku boot hotu.
D

Dora

System Analyst & QA

  • • Analiza rekizitu husi Ministériu Edukasaun.
  • • Teste algoritmu Levenshtein hodi asegura katak laiha error.
  • • Dokumentasaun ba kazu uza (Use Case).
M

Manuel

UI/UX & Frontend Developer

  • • Dezenu interface Chatbot ne'ebé User-Friendly.
  • • Implementa Tailwind CSS hodi halo web responsivu.
  • • Garantiza user experience ne'ebé di'ak.
N

Natalino

Database Administrator & Backend

  • • Jere baze de dadus MySQL (Rules & Logs).
  • • Optimizasaun query hodi chatbot hatán lalais.
  • • Implementa seguransa dadus (Sanitization).