Inventory Management Database in MySQL

Inventory Management Database in MySQL

Relational database project developed in MySQL to simulate an inventory management system, focusing on data modeling, relationships, and analytical queries.

The database manages products, categories, and suppliers, enabling structured storage of inventory data and providing insights through aggregation and business-oriented queries.

Key features:

  • Relational schema with three core entities: products, categories, and suppliers
  • Use of foreign keys to enforce data integrity and relationships
  • Structured data model supporting product classification and supplier tracking
  • Analytical queries including:
    • Product distribution by category
    • Inventory value calculation (price × stock)
    • Stock level analysis (minimum, maximum, low stock detection)
    • Supplier performance (number of products, average pricing)
  • Aggregations using COUNT, AVG, MIN, and MAX functions

Total stock value by category
GitHub Page
Contact me!
LinkedInGITHUB