Skip to content

Latest commit

 

History

History
107 lines (76 loc) · 2.24 KB

README.md

File metadata and controls

107 lines (76 loc) · 2.24 KB

📦 Inventory Management System (SQL Project)

📌 Project Overview

This project demonstrates the design and implementation of a structured Inventory Management System using SQL.

It covers database design, table relationships, constraints, and analytical queries to manage inventory operations efficiently.

The project showcases practical SQL skills including:

  • Database schema design
  • Table relationships (Primary & Foreign Keys)
  • Data insertion
  • Data retrieval using JOINs
  • Aggregation and filtering
  • Business insights generation

🗂️ Repository Structure

Sql_project-/
│
├── Inventory Project SQL Query.sql
├── Relationship diagram sql server.png
└── README.md
  • Inventory Project SQL Query.sql → Contains complete SQL scripts (DDL + DML + Queries)
  • Relationship diagram sql server.png → Visual representation of table relationships
  • README.md → Project documentation

🧠 Objective

The main objectives of this project are:

  • To design a relational database for inventory management
  • To implement structured SQL queries for data manipulation
  • To perform data analysis using aggregate functions
  • To understand table relationships and normalization
  • To simulate real-world business inventory scenarios

🏗️ Database Design

The database includes multiple related tables such as:

  • Products
  • Categories
  • Suppliers
  • Orders
  • Customers
  • Stock / Inventory

The relationship diagram demonstrates:

  • Primary Keys
  • Foreign Keys
  • One-to-Many Relationships
  • Data integrity constraints

🛠️ Key SQL Concepts Used

🔹 Data Definition Language (DDL)

  • CREATE TABLE
  • PRIMARY KEY
  • FOREIGN KEY
  • ALTER TABLE

🔹 Data Manipulation Language (DML)

  • INSERT INTO
  • UPDATE
  • DELETE

🔹 Querying & Analysis

  • SELECT
  • WHERE
  • GROUP BY
  • HAVING
  • ORDER BY
  • INNER JOIN / LEFT JOIN
  • Aggregate Functions (SUM, COUNT, AVG, etc.)

📊 Business Insights Generated

The project allows analysis such as:

  • Total inventory value
  • Monthly sales summary
  • Low stock identification
  • Supplier-wise product distribution
  • Order tracking and reporting

👨‍💻 Author

Sunil Kumar
Aspiring Data Analyst | SQL | Power BI | Excel | Tableau