GitHub - harshiiash/Inventory-Management-System: Inventory management software is a software system for tracking inventory levels, orders, sales and deliveries. It can also be used in the manufacturing industry to create a work order, bill of materials and other production-related documents.

harshiiash / Inventory-Management-System Public

Notifications You must be signed in to change notification settings
Fork 3
Star 3

Inventory management software is a software system for tracking inventory levels, orders, sales and deliveries. It can also be used in the manufacturing industry to create a work order, bill of materials and other production-related documents.

3 stars 3 forks Branches Tags Activity

Star

Notifications

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 1 Commit
IMS.class		IMS.class
IMS.java		IMS.java
Readme.txt		Readme.txt

Repository files navigation

User Id: admin
Password : password
SQL commands required before program execution
create database IMS;
use IMS;
create table product(productid int NOT NULL AUTO_INCREMENT,productName varchar(30),purchasePrice int,salePrice decimal(8,2),productQty int,PRIMARY KEY (productId));
create table sale(saleID int NOT NULL AUTO_INCREMENT,productID int, price decimal(8,2),date date,saleQty int,PRIMARY KEY(saleId),FOREIGN KEY (productID) REFERENCES product(productID) ON DELETE CASCADE ON UPDATE CASCADE );