Creation Of ReciclaPC Aplication.pptx

Creation of ReciclaPC Application

Antonio Vodopija Erasmus+ 2025 Portugal, Braga

Contents:

• Getting started
• Database
• Application development
• Final application

Getting started

During this year's Erasmus+ project in Braga, Portugal, I worked at a computer repair company called ReciclaPC. As part of my job, I was tasked with creating an application to organize components in the company. I developed the application during the second week of our stay, from March 17th to 21st.

• Collaborative Discussion of Needs for the Sales Shop of Components
• Identifying Key Problems:
• Lack of real-time inventory tracking.
• Manual record-keeping (Excel).
• Difficulty in quickly finding products.
• Goal: Automate component tracking and simplify sales processes.

Getting started

Brainstorming Ideas and Designing the Application

• Defining application specifications.
• Researching technology.

Getting started

Migrating from Excel to SQL Database:

• Speed
• Reliability
• Centralized management
• Scalability
• Advanced analysis

Database

Database

Example of Conversion from Excel to SQL

From Excel to SQL code

System functional requirements:

• Component management.
• User management.
• Transaction system.

Application development

Application Development

Example of interface with components

Application Development

Example of interface with users

Application Development

Example of interface with transactions