Database Design Project for Bakery Management System

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`s Bakery Management System
Database Design Project for Glady’s Bakery Management System

For More Database Design Examples

Leave a Comment