🧠 VendingPLUS Database System

A relational database project developed in Oracle for managing vending machines, stock, warehouses, and logistics operations.
The system supports product management, stock monitoring, refilling routes, and operational analytics.

---

🚀 Setup / Execution

1. Open the project in Oracle SQL Developer (or another Oracle client).
2. Run the script Script_CreateTables.sql to create the database structure.
3. Execute Script_InsertData.sql to populate the database with base and test data.
4. Run the PL/SQL files located in phase-3_final/ to create functions, procedures, and triggers.

After these steps, the database is ready to execute analytical queries, views, and operational logic.

---

🗺 Database Diagram

Below is the relational schema representing the VendingPLUS database model. It illustrates the main entities, relationships, and data flow within the system.

(If the image doesn’t load, check the full version in phase-1_modeling/G20_Checkpoint1_PhysicalModel.pdf.)

---

📁 Project Structure

• phase-1_modeling/ → Conceptual & physical data models (ER diagrams, table scripts)
• phase-2_views/ → SQL queries and analytical views for business insights
• phase-3_final/ → PL/SQL functions, procedures, and triggers for automation and data integrity

---

⚙️ Main Features

• ER and relational modeling in Oracle 11g
• SQL scripts for database creation and data population
• Analytical queries using GROUP BY, nested SELECTs, and joins
• Business-oriented views for sales, stock, and logistics
• PL/SQL functions, procedures, and triggers ensuring data consistency
• Exception handling and transaction control

---

🧩 Technologies

• Oracle Database 11g
• SQL / PL/SQL
• Data Modeling (ER + Relational Schema)

---

📚 About

Developed for the Database Architecture and Administration course (Instituto Superior de Engenharia de Coimbra, 2024/2025).
Team project focused on applying relational modeling, advanced SQL querying, and PL/SQL programming in a real-world business scenario.