Skip to content

Latest commit

 

History

9 Commits

Folders and files

NameName
Last commit message
Last commit date
 
 
 
 
 
 
 
 
 
 

Repository files navigation

IAzimute

sqlutions logo

Welcome to the repository of project IAzimute, developed by team SQLutions for the 6th Semester Database course at FATEC São José dos Campos.


📑 The Challenge


The client reported that the engineers have a hard time finding and classifying documents, this process is manual and takes a extremely long time, the consequence is a loss and stop of the current task to read hundreds of pages from documents hoping the document contains information from the task, this takes minutes to hours of time, the other problem is classifying these documents with "tags" to make finding them easier, the process is also manual and takes minutes to hours at a time.

The Solution (IAzimute)


We decided to build a web application to and organize, classify and turn the search for documents easy for any employee. Our project offers:

  • A search bar to find documents based on name or even context from the documents.
  • Filters to hasten the search.

🏁 Sprint Deliverables

Sprint Forecast Status History
01 09/07/2026 to 09/27/2026 Current Stage On going
02 10/05/2026 to 10/25/2026 Future Stage Future Stage
03 11/02/2026 to 11/22/2026 Future Stage Future Stage

→ Back to top

🎯 Backlogs & User Stories

✅ Functional Requirements

ID Functionality Description Priority
RF-1 Search by Document Name Allow users to quickly search for files by partial or full name. High
RF-2 Automatic Classification The system must automatically associate labels to each document to facilitate the search process. High
RF-3 Internal Text Search Engine Index and allow the search of specific technical terms directly within the internal content of the files (e.g., PDFs). High
RF-4 Technical Standards Filter Allow filtering the search by crossing labels and technical standards associated with documents of similar content. High
RF-5 Audit System (Logs) TImplement access and data manipulation logs for traceability. Medium
RF-6 Access Control and Permissions Restrict file viewing and manipulation only to users with the proper security clearances. High
RF-7 LGPD Compliance Implement data anonymization and database de-characterization records, ensuring the right to be forgotten. High
RF-8 Access Request Flow Create a process in the system so that engineers can formally request access to restricted documents, avoiding physical requests. Low

⚙️ Non-Functional Requirements

ID Category Description
RNF-1 Artificial Intelligence The system must use some form of Machine Learning to solve the problem.
RNF-2 Documentation The project must contain the API (Application Programming Interface) Documentation.
RNF-3 Modeling Delivery of the Database or Data File Modeling is mandatory..
RNF-4 Security / LGPD The system must have data anonymization implemented according to LGPD guidelines.
RNF-5 Audit System (Logs) The system must continuously record access and data manipulation logs.
RNF-6 Security / LGPD The system must maintain records of database de-characterization.

📌 Product Backlog


Rank Priority User Story Estimate Sprint Functional Requisite Non-Functional Requisites
1 High [[US-01]] - As an employee, I want to search for documents by name, so that I can quickly find the exact file I need, saving time locating documents. 5 1 RF-1 RNF-2, RNF-3
2 High [[US-02]] - As an operator, I want documents to be automatically classified using tags to facilitate the use of the system by engineers, saving search time and improving document organization in the system. 13 1 RF-2 RNF-1
3 High [[US-03]] - As an engineer, I want the search to include the internal text of the documents, to locate specific technical information even when I don't know the file title, saving the time of reading all files. 13 2 RF-3 RNF-1, RNF-2
4 High [[US-04]] - As an engineer, I want the search to use the standards/tags attached to the documents, to ensure I am consulting the correct regulatory documentation, thus saving time manually identifying what each file is about. 5 2 RF-3 RNF-2
5 High [[US-06]] - As an operator, I want users to only have access to files they are cleared for, so that document information remains secure and prevents costs from data leaks. 8 2 RF-6 RNF-5
6 High [[US-07]] - As an employee, I want to exercise my data protection rights, to preserve my privacy and the right to be forgotten. 8 2 RF-7 RNF-4, RNF-6
7 Medium [[US-05]] - As an operator, I want access to an auditing system, to track accesses to the system's documents. 5 3 RF-5 RNF-5
8 Low [[US-08]] - As an engineer, I want to be able to request access to documents to obtain necessary information, saving time in the process of going in person to request document access. 5 3 RF-8 RNF-2

📌 Sprint Backlog


[Youtube video]


[Youtube video]


[Youtube video]

→ Back to top

🛠️ Technologies

The following tools, languages, libraries, and technologies were used in the project's construction:

Jira GitHub Git Figma Prettier ESLint SonarQube

Backend

Python Pytest Docker

Frontend

React TypeScript

→ Back to top

👥 Team

Photo Function Name Socials
bryan Product Owner Bryan Matheus LinkedIn GitHub
gabriel vasconcelos Scrum Master Gabriel Vasconcelos Ferreira LinkedIn
GitHub
caina Developer Cainã Nascimento Melo LinkedIn GitHub
daniel Developer Daniel Sendreti Broder LinkedIn GitHub
enzo Developer Enzo Lemos Franco LinkedIn
GitHub
elbert Developer Elbert Jean LinkedIn GitHub
gabriel carvalho Developer Gabriel Carvalho Silva LinkedIn GitHub
gloria Developer Glória Brito LinkedIn GitHub

→ Back to top

About

No description, website, or topics provided.

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors