Database - UDESC

The final project

📜 Table of contents

• Starting
• Features
• Prerequisites
• Built with
• Author
• License

🚀 Starting

This database project is designed to address the operational challenges faced by Confeitaria Dona Lúcia, providing a solution for managing various aspects of the business. The system ensures control of ingredients by recording information such as descriptions, quantities, brands, and units of measurement. Supplier orders are tracked, including data on quantities purchased, unit prices, and total order values, ensuring a stock overview. Furthermore, the system integrates recipe management, enabling the storage and retrieval of preparation methods, preparation times, yields, and required ingredients, streamlining updates and access to information.

The project also supports sales tracking, associating each transaction with specific products, quantities, and purchase dates. Product pricing dynamically considers ingredient costs and desired profit margins, ensuring financial stability.

📚 Features

Used during the evolution of the final project:

• User/Permission Management: CRUD operations for managing users and permissions.
• Table Creation: Design and create tables for all business aspects.
• CRUD with MySQL: Perform CRUD operations on all data tables using MySQL.
• SQL Joins: Use INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN to manage relationships between tables.
• Additional SQL Features: Implement advanced SQL features like subqueries and indexing for improved performance.

📋 Prerequisites

To run this project, ensure the following prerequisites are met:

• Database Setup: Install MySQL on your machine and set up the database using the provided scripts.
• Java Environment: Have Java installed (version 22 or higher) to support the execution of the graphical interface.
• Executable File: Use the provided .bat file to launch the graphical interface, which allows interaction with the database through features like CRUD operations and data analysis.

🛠️ Built with

• Java - The programming language used.
• MySQL - Used to handle the databases.

✒️ Author

• Mateus Adada - Documentation - mateusadada
• Vinicius Eduardo Beuther - Developer - ViniciusBeuther

You can also see the list of all collaborators who participated in this project.

📄 License

This project is under the license MIT. See the LICENSE.md file for more details.

---

Developed with ❤️ in Brazil 🇧🇷