Frozen Foods Ordering System Database Design

Frozen Foods Ordering System Database Design

Frozen foods ordering system database design is a database used for business. The main purpose of this database project is to make the ordering transaction fast with accuracy, to keep and secure the order records, to avoid delay of pick- up of the ordered products and most especially, is to promote the products.The following are the company’s goal in reaching the best service they can give to their valued customers. A direct customer is a customer that will call the company directly and place an order.This type of client is usually an independent person, who orders small amounts and are unlikely to receive a discount on their purchases. All profits on a sale made to direct customers, goes directly to the company, without dividing or sharing profits or paying commissions.A wholesale customer is very similar to a direct customer. They also buy directly from the company but will buy meals in bulk and receive a discount on their purchases. 

Frozen Foods Ordering System Database Design Features:

  • Products (Add, View, Update)
  • Orders (Confirm, Cancel)
  • Manage Users (Add, List, Update)
  • Customer Profile
  • Product Purchases by Supplier
  • Purchase Orders
  • Employees profile
  • Customer (direct customer, wholesale customer)

Entity Relationship Diagram of Frozen Foods Ordering System

In relational databases, all the required data is collected and divided into selected tables. This is to ensure that the data is stored in an organized manner, which will make it easier to track through records in the database.This eliminates the problems often encountered when all the information is written in a single line or record, or when all information is saved in a certain sheet, for example, an Excel spreadsheet.After all the tables with their different information categories within the tables have been designed and populated within the tables, the tables are linked via relationships.The relationships are established by a decided table primary key, which is present in the specific table, as well as present in another table, as a foreign key.The relationship between two tables is illustrated by a line joining two or more of these tables. At the end of a joining line, the manner in which the two tables have been joined is also indicated.This is visible in the diagram below and these manners include, one-to-one -, one-to-many – and many to many relationships.

Diagram of Ordering System

Frozen Foods Ordering System Database Design
Frozen Foods Ordering System Database Design
This form of data modeling was used to set the system requirements for the database that were determined throughout the project. The ERD assisted the project team with the design of the IS and was used as a plan throughout the construction thereof. It served as a map which could be followed and was often referred to.

Data Dictionaries

          Table 1: tblcustomers

Field NameDescriptionTypeLength
IDCustomer ID numberInt11
Customer_idNumber of Customersvarchar90
First_NameFirstName of Customervarchar90
Last NameLastName of Customervarchar90
City_addressCustomer City Addressvarchar90
AddressCustomer Full addressvarchar90
AgeAge of Customerint2
Phone numberContact number 0f Customervarchar11
ZipcodeCustomer city address zipcodevarchar11
 

Table 2: tblemployee

Field NameDescriptionTypeLength
Employee_idEmployee ID numberInt7
First_NameEmployee Firstnamevarchar50
Middle NameEmployee Middle Namevarchar50
Last NameEmployee Last Namevarchar50
AgeAge of Employeeint2
AddressAddress of Employeevarchar50
Contact_numberContact Number of employeevarchar11
Email_AddressEmail Address of employeevarchar50
 

Table 3: tblorder

Field NameDescriptionTypeLength
Order_IdOrder ID numberInt7
Products_idProducts ID numberint7
Date_orderDate ordered of customervarchar30
QuantityCustomer suggested productsInt1
PricePrice of the productsint11
Date ClaimClaim date of customervarchar30
Order TypePick- up or cash on deliveryDate30
StatusAvailable or not availableDate30
Order_NumberOrder number of productsvarchar50
Customer_IdCustomer ID numberint7
 

Table 4: tblpayments

Field NameDescriptionTypeLength
Payment_IdPayment ID numberInt7
Order_NumberOrder number of productsvarchar30
Customer_IdCustomer Id numberInt7
Date_OrderDate ordered of customerVarchar30
Claim_dateClaim date of customerInt11
Payment_MethodPayment method of customerVarchar30
QtyCustomer suggested productsInt1
PricePrice of the productsint11
 

Table 5: tblproducts

Field NameDescriptionTypeLength
Products_IdProducts ID numberInt7
Products_NameName of the Productsvarchar90
Product_TypeTypes of Productsvarchar90
DescriptionProducts descriptionVarchar90
QuantityQuantity of productsVarchar1
On_HandAvailable or not availableDate1
PricePrice of the productsVarchar11
 

Table 6: tblsupplier

Field NameDescriptionTypeLength
Supplier_IdSupplier  ID numberInt7
Supplier_NameName of Suppliervarchar50
Supplier_AddressAddress of suppliertext
Contact_numberContact number of suppplierVarchar11
Email_AddressEmail address of supplierVarchar50
 

Table 7: tbltransactions

Field NameDescriptionTypeLength
Transaction_Idtransaction ID numberInt11
Customer_IdCustomer id numberint7
Employee_IdEmployees id numberint7
Order_IdOrder id numberint7
Products_IdProducts id numberint7
Supplier_idSupplier id numberint7
 

Table Keys

Table NameFieldnameKey Type
tblemployeeEmployee_IdPK
tbltransactionTransaction_IdPK
tblcustomersCustomer_IdPK
tblordersOrder_IdPK
tblproductsProducts_IdPK
tblsupplierSupplier_IdPK
  

Table Keys

Table NameFieldnameKey Type
tblemployeeEmployee_Id
tbltransactionTransaction_Id
tblcustomersCustomer_IdFK
tblordersOrder_IdFK
tblproductsProducts_Id
tblsupplierSupplier_Id
 

This Frozen food ordering system Database design is created by 

ADONES E. EVANGELISTA

Run Quick Virus Scan for secure Download

Run Quick Scan for secure DownloadYou can download Complete Source code with database design here: Online Ordering System

1 thought on “Frozen Foods Ordering System Database Design”

  1. Hi po admin..paki help po ako sa system namin na E-commerce po using php, bootstrap, etc. .. Di ko po alam kung panu simulan eh.. Please.. Please po.. Thank you..
    Btw, I’m ferdilyn..I’m 3rd year IT student..

Leave a Comment