Database Design for Ordering and Delivery Management System

https://itsourcecode.com/free-projects/database-design-projects/database-design-for-ordering-and-delivery-management-system/

This Database Design for Ordering and Delivery Management System is a solution for easy ordering and delivering system. Ordering Management System Database Design with ERD became build the use of JAVA Application .The prime motive of this database is to make the order transaction speedy and smooth for the customers, to maintain and secure the order records, to keep away from postpone of transaction of ordered products maximum especially, is to show and promote it the products(Database Design Tables for Ordering Management System Project).

Ordering and Delivery Management System Database Design

The System for Ordering and Delivery Management Database Design will guide the customers for entire transaction that ensures the orders will deliver properly without hesitations. This system runs efficiently and smoothly, helps to save details and generate various reports.

It provides an easiest way for transaction and it helps to improve employee productivity and strengthen corporate security by controlling official data. Assisting customers in efficient way and provides accurate information.

This system is designed with features that helps the supervision and promotion of different facet of a business more efficiently, which is fit for ordering and delivery system to boost sales and prevent losses.

FEATURES:

• Good and effective servicing
• Manage customer
• Manage orders
• Manage payments
• Manage delivery

DATA DICTIONARIES

Table 1: tblemployee

FIELD NAME	DESCRIPTION	TYPE	LENGTH
Emp_fname	Firstname of employee	Varchar	50
Emp_lname	Lastname of employee	Varchar	50
Emp_ID	Employee id	Int	11
Address	Address of employee	Varchar	500
Contact	Contact number	Varchar	50

 Table 2: tblcustomer

FIELD NAME	DESCRIPTION	TYPE	LENGTH
Cust_name	Name of customer	Varchar	50
Cust_id	Customer id	Int	30
Cust_Address	Customer address	Varchar	500
Cust_contact	contact number	Varchar	50

Table 3: tblproduct

FIELD NAME	DESCRIPTION	TYPE	LENGTH
Prod_id	Product id	Int	11
Prod_name	Name of product	Varchar	50
Flavors	Flavors	Varchar	50
Price	Price	Double

  Table 4: tbluser

FIELD NAME	DESCRIPTION	TYPE	LENGTH
User_id	User id	Int	11
User_name	Name of user	Varchar	50
Password	Password	Varchar	50
First_name	Firstname of user	Varchar	50
Last_name	Lastname of user	Varchar	50
Contact number	Phone number	Varchar	50
Address	Address of user	Varchar	500

Table 5: tbltransaction

FIELD NAME	DESCRIPTION	TYPE	LENGTH
Pending_number	Pending number	Int	11
Prod_id	Product ID	Int	20
Cust_id	Customer ID	Int	20
Flavors	Flavors	Varchar	50
Price	Price	Double
Quantity	Quantity	Int	20
Total_price	Total price	Double
Date	Datetime	timestamp

  Table 6: tblpending

FIELD NAME	DESCRIPTION	TYPE	LENGTH
Pending_number	Pending number	Int	11
Prod_id	Product ID	Int	20
Cust_id	Customer ID	Int	20
Flavors	Flavors	Varchar	50
Price	Price	Double
Quantity	Quantity	Int	20
Total_price	Total price	Double
Date	Datetime	timestamp

ENTITY RELATIONSHIP DIAGRAM

Database design for cake ordering and delivery management system

Conclusion

This Management System for Ordering and Delivery Database Design is made to lessen issue and to manage difficulties in the future.