Database Design Project For Monitoring Management System

    0
    1152

    Database Design Project For Monitoring Management System

    This Feeds Supply Monitoring Management System Database Design Project with ERD, Tables is designed for Final Year Requirements DBMS Mini projects.

    The Feeds Supply was founded year 2010. Due to Boar Services that the family owns they decided to add another business that is related to their first business.

    This supply management System is made to lessen their manual work especially on making big transactions to customers. This will secure all the data and information of customers as well as the transactions towards the client. If the item is unavailable the system will immediately notify the owner. This will help them a lot in monitoring their products because it is more convenient than using manual writing for the transaction. This will also avoid mistakes in monitoring your products. This will give you the exact number of products that are available and the products that were bought by your costumers.

    Instead of computing everything through the calculator and encode the products that they bought by means of paper and ballpen this will you calculate and review each product. Each item has its own respective price located at the bottom of the product. This will avoid using a lot of time to find the exact price of each product.

    Past transactions can browse too. If you want to review something about your clients or the products they bought the system will automatically flash past transactions according to the data you want to take.

    As per the products the supplier price will be shown in the system and also the market price. This will determined their profit. This will help them monitor their products as well as their profit. Adding the transaction for supplier and the owner will be one of the features of this system.

    Features:

    • Monitor Products
    • Monitor records of customer
    • Monitor daily transactions

    Data Dictionaries

    TBL1:TBLCUSTOMER

    Field Name Description Type Length
    Customer_id Customer ID number int 10
    Fname First name of customer varchar 50
    Lname Last name of customer varchar 50
    Address Customer Address varchar 90

    TBL2:TBLEMPLOYEE

    Field Name Description Type Length
    Employee_id Employee ID number int 10
    Fname Employee First Name varchar 50
    LName Employee Last Name varchar 50
    Age Age of Employee int 5
    Address Address of Employee varchar 50
    Contact_number Contact Number of Employee varchar 20

    TBL3:TBLORDER

    Field Name Description Type Length
    Order_id Order ID number int 10
    Product_id Products ID number int 10
    Date_order Date ordered of customer varchar 50
    Quantity Customer suggested products int 10
    Price Price of the products int 30
    Status Available or not varchar 30

    TBL4:TBLPRODUCTS

    Field Name Description Type Length
    Product_id Product ID number int 10
    Product_name Name of the product varchar 90
    Product_brand Brand of Product varchar 90
    Quantity Quantity of Product varchar 10
    Price Price of the Product varchar 10

    TBL4:TBLSUPPLIER

    Field Name Description Type Length
    Supplier_id Supplier ID number int 10
    Product_id Product ID number int 10
    First_Name First Name of the Supplier varchar 90
    Last_name Last name of supplier varchar 90
    Supplier_Address Address of the Supplier varchar 90
    Contact_number Contact number of the supplier varchar 30
    Received Recieved date of Product date  

    Entity Relationship Diagram  for Feeds Supply Monitoring Management System in Database design Project

    Feeds Supply Monitoring Management System entity diagram show how the systems entity with and their function with each other.

    Database Design Project For Monitoring Management System Document Here.

    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.