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.
Created a database schema named InventoryDB with tables:
- Products: Columns include ProductID, ProductName, CategoryID, UnitPrice, UnitsInStock.
- Categories: Columns include CategoryID, CategoryName.
- Sales: Columns include SaleID, ProductID, SaleDate, QuantitySold.
Inserted sample data into the Products and Categories tables for testing purposes.
Implemented SQL queries for adding, updating, and deleting products. Recorded product sales using SQL queries.
Implemented data integrity constraints, including foreign key constraints between Products.CategoryID and Categories.CategoryID.
Included basic data validation checks, such as ensuring unit price is positive and quantity sold is non-negative.
Created SQL queries to generate basic reports, such as total sales by product or category and current inventory status.
Provided documentation explaining the database schema, table structures, and sample queries for basic operations and reports.
Thoroughly tested SQL queries to ensure they perform as expected and handle edge cases gracefully.
Uploaded the project to GitHub, including SQL script files, documentation, and any additional resources.
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.