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

Database Design Project for Bakery Management System