Inventory Management System

A Database Management System project built as part of the B.Sc Computer Science curriculum.

📌 Project Overview

The Inventory Management System is designed to streamline inventory tracking and improve the efficiency of stock management across multiple stores and brands. The system ensures organized data storage, robust querying capabilities, and logical data relationships through normalization and relational schema design.

🧠 Features Implemented

• ER Diagram & Relational Schema Design
• Creation of 15+ normalized tables using Oracle SQL
• Use of various SQL operations:
  • DML & DDL commands
  • Arithmetic & Logical operators
  • Comparison & Set operators
  • Group, Character, Numeric & Date functions
  • Subqueries & Joins
• Proper constraints (Primary Key, Foreign Key) applied
• Sample data inserted for demonstration (3+ rows per table)

🗃️ Tables Created

• category, product, brand, store, customer_details
• payment, customer_cart, belongs_to, stored_inside, stored_in
• filled_in, billed_for, provider_phone, store_phone, customer_mobile

🧮 Sample SQL Usage

• Joins: Natural, Inner, Left
• Functions: power(), sqrt(), ceil(), floor(), round(), length(), initcap(), substr(), months_between(), add_months(), last_day() etc.
• Set Operations: UNION, INTERSECT
• Subqueries: Nested SELECT for filtered retrieval

📊 Example Queries

-- Arithmetic operation
UPDATE payment SET gst_amt = tamt + gst;

-- Logical operation
SELECT * FROM category WHERE cid IN (1001, 1005, 1009) AND category_value = 10;

-- Join
SELECT sid, sname, phone_no FROM store_phone NATURAL JOIN store;