Inventory Management System — Original College Project

New Delivery Item

Manage Supply

ID	Unit	Description	Stock

ID Unit Description

Manage Deleted Records

ID	Unit	Description	Stock

Manage Department

ID	Description

ID Description Added Records Deleted Records

Manage Employee

ID	Department	First	Middle	Last	Age	Gender

Department ID First Name Middle Name Last Name Age Gender Added Records Deleted Records

Assign Item

Available Supply

ID	Unit	Description	Stock

Limit Supply

ID	Department	Item ID	Description	Quantity

ID Department Item Description Item Quantity Added Records Deleted Records

Transaction

Department Employee Transaction ID. . . . . Limit Search Item

ID	Unit	Description	Stock	Quantity

Add ID	Transaction No.	Department	Employee	Item No.	Unit	Description	Stock	Quantity

Manage Admin

Username	Password

Username Password Added Records Deleted Records

Delivery Report

ID	Item ID	Unit	Description	Stock	Quantity	Date Received

Transaction Report

Department

Transaction No.	Department	Date

Transaction No.	Department	Employee	Item	Unit	Description	Stock	Quantity