Supply Management System Database Design with ERD
This Supply Management System Database Design with ERD or Database Design for Supply Management System with ERD and Tables is programmed using Java for the fastest and convenient monitoring of JB Blocks and Supplies. This system will help the owner to manage their products to avoid the unexpected problems.(ER Diagram for Product Supplies Management System)
JB BLOCKS AND SUPPLIES are owned by Jake Ann and Andrew Leyden. Their business is a hardware supplies, it consist of 7 employees to help them from their business. JB BLOCKS AND SUPPLIES accepting payments like good as cash, instalment and cash on delivery it depends on what client’s availability.
JB Blocks and Supplies was build last June 25, 2018 by the Leyden couple with the help of their own family and it goes well and their celebrating their 1st anniversary on 25th of June 2019. They offer household tools and located at Meñez Street Barangay 4 Himamaylan City Negros Occidental.(ER Diagram for Product Supplies Management System)
JB Blocks and Supplies have their own truck so that it’s not hard for them and to the customer to deliver the products, it’s free delivery for customers and sometimes they give discount to their solid buyers.
We all know that being new to the field of business and it’s not easy to run it without the help of computer. This system will minimize the unexpected problems during their monitoring, this system contains the quantity of the products added and deducted everyday so that the owner can monitor the remaining supplies and how many has been sold, and how many profit they gain for each product. (ER Diagram for Product Supplies Management System)
This will get the personal information of the client every time they have transaction so that they can verify the identity of the clients including it’s Name, Location, Id number. Also in this system includes the information of the employees and their hired dates, salary and employee Id so that the owner can monitor all employees on duty and to avoid a illegal transaction between employee and client or between both employee.(Database Design for Supply Management System with ERD and Tables)
Supply Management System Database Design with ERD : Features
- Manage Customer
- Stock Monitoring
Supply Management System Database Design with ERD : Data Dictionaries
TABLE 1 : TBLCUSTOMER
| FIELD NAME | DESCRIPTION | TYPE | LENGHT |
| Customer_Id (PK) | Customer Id number | Int | 11 |
| First_name | Customer first name | Varchar | 50 |
| Last_name | Customer last name | Varchar | 50 |
| City_address | Customer city address | Varchar | 50 |
TABLE 2 : TBLEMPLOYEE
| FIELD NAME | DESCRIPTION | TYPE | LENGHT |
| Product_id | Product id number | Int | 11 |
| Product_name | Product name | Varchar | 50 |
| Quantity | Quantity | Int | 11 |
| Price | Price | Int | 11 |
TABLE 3 : TBLPRODUCTS
| FIELD NAME | DESCRIPTION | TYPE | LENGHT |
| Product_id | Product id number | Int | 11 |
| Product_name | Product name | Varchar | 50 |
| Quantity | Quantity | Int | 11 |
| Price | Price | Int | 11 |
TABLE 4 : TBLSUPPLIER
| FIELD NAME | DESCRIPTION | TYPE | LENGHT |
| Supplier_Id (PK) | Supplier Id number | Int | 7 |
| Supplier_name | Supplier name | Varchar | 50 |
| Supplier_address | Address of supplier | Varchar | 50 |
TABLE 5 : TBLTRANSACTION
| FIELD NAME | DESCRIPTION | TYPE | LENGHT |
| Transaction_Id | Transaction Id number | Int | 11 |
| Customer_Id (FK) | Customer Id number | Int | 11 |
| Employee_Id (FK) | Employee Id number | Int | 11 |
| Products_Id (FK) | Products Id number | Int | 7 |
| Supplier_Id (FK) | Supplier Id number | Int | 7 |
Supply Management System Database Design with ERD : Entity Relationship Diagram
