akbted / inventory-management-system_sql_project

I have developed a a simple Inventory Management System using SQL. The database should allow for managing product inventory, tracking sales, and generating basic reports.

Inventory Management System

Project Overview

This project is a simple Inventory Management System developed using SQL. The system is designed to manage product inventory, track sales, and generate basic reports.

Requirements

Database Schema

Created a database schema named InventoryDB with tables:

1. Products: Columns include ProductID, ProductName, CategoryID, UnitPrice, UnitsInStock.
2. Categories: Columns include CategoryID, CategoryName.
3. Sales: Columns include SaleID, ProductID, SaleDate, QuantitySold.

Data Population

Inserted sample data into the Products and Categories tables for testing purposes.

Basic Operations

Implemented SQL queries for adding, updating, and deleting products. Recorded product sales using SQL queries.

Data Integrity

Implemented data integrity constraints, including foreign key constraints between Products.CategoryID and Categories.CategoryID.

Data Validation

Included basic data validation checks, such as ensuring unit price is positive and quantity sold is non-negative.

Reports

Created SQL queries to generate basic reports, such as total sales by product or category and current inventory status.

Documentation

Provided documentation explaining the database schema, table structures, and sample queries for basic operations and reports.

Testing (Testing is still to be completed)

Thoroughly tested SQL queries to ensure they perform as expected and handle edge cases gracefully.

GitHub Repository

Uploaded the project to GitHub, including SQL script files, documentation, and any additional resources.

Conclusion

This project demonstrates my ability to design and implement a database schema, manage inventory data, track sales, generate reports, and follow industry-standard practices for data integrity, validation, and documentation. It serves as a valuable addition to the resume and GitHub profile, showcasing SQL skills to potential employers.

I would also like to highlight that I faced some challenges while using the JOIN function, performing data validation, and generating basic reports. I overcame these challenges by referring to YouTube, GPT, and Stack Overflow.