This project simulates a product restocking system for VendiCose SpA, a fictitious company that operates a network of supermarkets and warehouses. The goal is to manage inventory efficiently by automating the flow of product orders between warehouses and their associated retail stores.
- Designed a relational database schema to model product inventory, sales, and restocking processes.
- Developed an ER diagram to define entities, keys, and relationships between warehouses, stores, and products.
- Implemented the database in MySQL, simulating real-world operations in a retail logistics system.
- Database: MySQL
- Design: ER diagram for data modeling
- Queries: SQL scripts for creatung and populating the database, updating stock levels, and checking inventory
For questions or feedback, contact:
leonardo.porcacchia@gmail.com