Supply Management System Database Design with ERD

    0
    164

    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
    PricePriceInt11

    TABLE 3 : TBLPRODUCTS

    FIELD NAMEDESCRIPTIONTYPELENGHT
    Product_idProduct id numberInt11
    Product_nameProduct nameVarchar50
    QuantityQuantityInt11
    PricePriceInt11

    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

    Looking for more source code? Type your keyword here here!

    LEAVE A REPLY

    Please enter your comment!
    Please enter your name here

    This site uses Akismet to reduce spam. Learn how your comment data is processed.