Database Design Project for Bakery Management System

    0
    245

    Database Design Project for Bakery Management System

    This article of Database Design Project for Bakery Management System or Bakery Management System Database Design with ERD help to minimize the work of employee in the shop. These system tackles the shop challenges in one integrated system, meeting your inventory, processing, distributing and accounting needs(Database Design for Bakery Management System with Tables).

    The project is about making a database for the bakery management system to make the record of the employees, purchase, product, customer or retailer. It is built to store all the information of products, handling employee information, easy search for products, feedback directly, creating and managing inventory.

    The basic aim of these project is to provide the search, delete, record and updating facilities which would be much more efficient and less time consuming. The software will allow the owner to maintain their entire record in one place which will be easy to manage(Database Design for Bakery Management System with Tables).

    And these project comprise of the list of all product display with different classification able to the owner be aware to the product availability. The Glady’s Bakery Management System was establish in the year 2000, month of March by Glady Mae Escotal and family.

    These is located in Brgy. Magballo, Kabankalan City. These shop compose of five employee, two for cashiering and managing the shop, two for baking and one for maintaining the shop clean( Bakery Management System Database Design with ERD ).

    Features

    • Make the transaction faster
    • Reach the customer satisfaction
    • Purchase and Inventory Control
    • Managing the flow of transaction between the customer and employee
    • Record all the details of the product

    Database Dictionaries

    Table 1: tblcustomer

    Field Name Description Type Length
    Customer_ID Customer ID number int   10
    Fname Customer Fname Varchar 10
    Lname Customer Lname Varchar 10
    Purchase Product Product Purchase of the Customer   Varchar 10

    Table 2: tblproduct

    Field Name Description Type Length
    Product_ID Product ID number int 10
    Product Name Name of the Product Varchar 10
    Color Product Color Varchar 10
    Description The Description of the Product   Text   30
    Price Price of the  Product   int   10
    Availability Number of Product int 10
    Size Size of the Product int 10

    Table 3: tblemployee

    Field Name Description Type Length
    Employee_ID Employee ID Number   int   10
      Name Name of the Employee   Varchar   30
      Salary Monthly salary of employee   Int   10
    Job Title Assigned Work Varchar 30
    Hire Date Date  when Employee Hired   int   10

    Table 4: tblsales

    Field Name Description Type Length
    Sales_ID Sales ID number int 10
    Customer Name Name of the Customer   Varchar 15
    Product Name Name of the Product   Varchar 15
    Price Price of the Product int 10
    Date Purchase Date of the Transaction   int   10
    Quantity Number of item purchase   int   10

    Entity Relationship Diagram

    Database Design Project for Glady<code data-lazy-src=

    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.