TotalStockManagementSystem

Description:

Total Stock Management System is the practice of ordering, storing, tracking, and controlling in-out stock of any organization by the use of information technologies.The purpose of this software is to maintain the stock of our college. The main advantage of this software is that it is robust, responsive, user friendly and also an hybrid application.

Technology Used:

• XAMPP server
• PHP
• MySQL
• HTML
• CSS
• Bootstrap
• JavaScript
• jQuery

Use Case Diagram:

Data Flow Diagram:

Level-0

Level-1

Level-2, Registration and Login

Level-2, Insert Category And Add Item

Level-2, User Requisition

Level-3, Departmental Requisition

E-R Diagram:

Database Schema:

All Database Tables:

Category Master:

Subcategory Master:

Registration:

Login:

Item Code:

Item Entry Data:

Item Entry Data:

User Requisition:

Departmental stock:

Department In-charge Requisition:

Old Items Stock:

Database Triggers:

Item Quantity Update:

Dispatch Item:

Screen Shot:

Login

Registration

Landing Page

Item Register Page

Landing Registration Form

Landing Registration Form