Supply Management System Database Design with ERD

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 NAMEDESCRIPTIONTYPELENGHT
Customer_Id (PK)Customer  Id numberInt11
First_nameCustomer  first nameVarchar50
Last_nameCustomer  last nameVarchar50
City_addressCustomer  city addressVarchar50

TABLE 2 : TBLEMPLOYEE

FIELD NAMEDESCRIPTIONTYPELENGHT
Product_idProduct id numberInt11
Product_nameProduct nameVarchar50
QuantityQuantityInt11
PricePriceInt 11

TABLE 3 : TBLPRODUCTS

FIELD NAMEDESCRIPTIONTYPELENGHT
Product_idProduct id numberInt11
Product_nameProduct nameVarchar50
QuantityQuantityInt11
PricePriceInt 11

TABLE 4 : TBLSUPPLIER

FIELD NAMEDESCRIPTIONTYPELENGHT
Supplier_Id (PK)Supplier Id numberInt7
Supplier_nameSupplier nameVarchar50
Supplier_addressAddress of supplierVarchar50

TABLE 5 : TBLTRANSACTION

FIELD NAMEDESCRIPTIONTYPELENGHT
Transaction_IdTransaction Id numberInt11
Customer_Id (FK)Customer  Id numberInt11
Employee_Id (FK)Employee Id numberInt11
Products_Id (FK)Products Id numberInt7
Supplier_Id (FK)Supplier Id numberInt7

Supply Management System Database Design with ERD : Entity Relationship Diagram

Database Design for JB BLOCKS & SUPPLIES Monitoring Management System
Database Design for JB BLOCKS & SUPPLIES Monitoring Management System

For More Database Design Examples

Leave a Comment