Database Design for Grocery Management System -| ERD| TABLES

This Database Design for Grocery Management System designed to handle grocery stock in, restock, sales, returns, purchase and other stuff.

Point of Sales and Inventory System Database Design stable revenue system are reasons in which the grocery store offer more jobs and opportunities to engage inside the earning activities.

Database Design for Silver Cross Grocery Management System

History

The Silver Cross Grocery was establish in the year of 2015, in the month of June.

The business was owned by Mr. Manuel Silver Cross and he name it after the name of his lastname which is the “Silver Cross”.

These is located at Brangay 8, Isabela Market,Isabela, Negros Occidental.

These Grocery are Composed of 5 Employees, two (2) for Sales Lady, one (1) Bagger who maintaining the customers things, one (1) cashier and one (1) manager who manage the business.

The cashier is the one who records the transactions of the business.

They are manually record the transaction on a piece of book.

In order to make this business become easier, we made Database Design for Grocery Management System Project which they can manage the transaction of their business more effectively and efficiently. In over all this system will gives to the customer and to the owner a convenience timed and easiest way to manage their business.

Introduction

Database Design for Grocery Management System is to help automatic the process the purchasing product, billing and to make the purchased transaction fast with accuracy, to keep and secure the sales records.

It helps the employee and the owner to easily manage or manipulate the transaction of the business.

It will avoid wasting of time just to write all the important information and data of the business transaction and customer.

My system processes and stores all the data or information of the business.

This system is made using java with relationship to Php/MyAdmin. The database of the system will store all the information such as customer, employee, product, sales, and payments. My simple silver cross grocery management allows the user to record the item or sales that is being reserve or order by the customer. On the Cashier system, the user or the authorized person can only login as staff administrator.

FEATURES for Grocery Management System Database Design

Manage products
Stored all the data
Manage customer
Monitor the number of customer

Data Dictionaries

Table 1: customertbl

Fieldname	Description	Type	Length
Customer_id	Customer ID Number	Int	11
firstname	Customer Firstname	Varchar	50
lastname	Customer Lastname	Varchar	50
Purchase_Product	Product Purchase	Varchar	11

Table 2: Employeetbl

Fieldname	Description	Type	Length
Employee_ID	Employee ID Number	Int	50
Name	Employee Name	Varchar	50
Hire_Date	Date of Hired	Date	11
Salary	Employee Salary	Int	11
Job_title	Employee Job Title	Varchar	50

Table 3: Producttbl

Fieldname	Description	Type	Length
Product_ID	Productt ID Number	Int	11
Name	Name of Product	Varchar	75
Availability	Available of Product	Int	11
Price	Price of Products	Int	11

Table 4: Salestbl

Fieldname	Description	Type	Length
Sales_ID	Sales ID Number	Int	11
Fname	Firstname of Customer	Varchar	75
Product_name	Name of Product	Varchar	50
Price	Price of the Products	Int	11
Quantity	Quantity of Products	Int	11
Date_Purchase	Date of Purchase	Date	11

Table 5: Paymenttbl

Fieldname	Description	Type	Length
Payment_ID	Payment ID Number	Int	50
Name	Name of Product	Varchar	50
Cost	Products Cost	Int	50
Stock	Products Stock	Int	50
Description	Description of a Product	Varchar	50

Entity Relationship Diagram

Sample ERD Project for Grocery Management System

Database Design Project for Silver Cross Grocery Management System

For another free material on database design.