Laundry Management System Database Design

This Laundry Management System Database Design is a system which provides easy and convenient in making services and hassle free for the customers in bringing their used clothes going to laundry. It is an application with important and basic information.

Nowadays, people always want an easy and effortless in every individuals. As a great deal as viable they rely on the accomplishment of their normal works in technology.

Laundry Management System Database Design

This Laundry Management System allows you to make life easier for the user, yet still manage the entire shop ranging from sorting or counting all the way to invoicing.

It enables customer management and prepare deliveries and invoice of the customers. The admin provides the functions such as Create, Edit, View, Delete and Search Customer included in all customer information. Admin can able to create an invoice and also can see a last all invoices for a particular customer.

This System allows you to make life easier for the user, yet still manage the entire shop ranging from sorting /counting all the way to invoicing. It enables customer management and prepare deliveries and invoice of the customers.

The admin provides the functions such as Create, Edit, View, Delete and Search Customer included in all customer information. Admin can able to create an invoice and also can see a last all invoices for a particular customer.

Also customer’s information is secured, as a specific customer id is allocated per registration online to avoid contrasting information. Admin can deliver cloths depending on the status (Ready, Pending, Delivered), Different Color show Different status, can also take remaining payment and generate an invoice for taking payment.

The aim of this Laundry Management System is to allow the staff to work with ease and greater efficiency, determine the number of clothes collected, in relation to their owners, as this also helps the users fix a date for the collection of their clothes.

Laundry Management System Database Design Features:

• Manage customer
• Manage user
• Monitor the Delivery
• Generate Reports

Entity Relationship Diagram of Laundry Management System

Laundry Management System Entity Relationship Diagram shows the system entity relationship in each entity and their supposed functions in each relationship

Diagram of Laundry Management System

Data Dictionaries

Table 1: tblbill

Field Name	Description	Type	Length
Bill_Id	Bill Id number	Int	7
Customer_Id	Customer Id number	Int	7
Bill_Amount	Bill Amount	Int	11
Quantity	Quantity of Clothes	Varchar	30
Price	Price Of Laundry	Int	5

Table 2: tblcustomer

Field Name	Description	Type	Length
Customer_Id	Customer Id number	Int	7
First_Name	Customer First Name	Varchar	30
Last_Name	Customer Last Name	Varchar	50
Age	Customer Age	Int	2
Address	Customer Address	Text
Phone_number	Customer Contact Number	Varchar	11
Gender	Customer Gender	Varchar	10

Table 3: tbldelivery

Field Name	Description	Type	Length
Delivery_Id	Delivey Id number	Int	7
Employee_Id	Employee Id number	Int	7
First_Name	Customer First Name	Varchar	30
Last_Name	Customer Last Name	Varchar	30
Address	Customer Address	Text

Table 4: tblemployees

Field Name	Description	Type	Length
Employee_Id	Employee Id number	Int	7
First_Name	Employee First Name	Varchar	30
Last_Name	Employee Last Name	Varchar	30
Job_Title	Employee Job Title	Varchar	30
Phone_Number	Employee Number	Varchar	13
Email	Employee Email	Varchar	30
Address	Employee Address	Text
Gender	Employee Gender	Varchar	10
Salary	Employee Salary	Int	11
Age	Employee Age	Int	2

Table 5: tblservices

Field Name	Description	Type	Length
Service_Id	Service Id number	Int	7
Service_Name	Services Name	Int	30
Price	Service Price	Int	5

Table 6: tbltransaction

Field Name	Description	Type	Length
Transaction_Id	Transaction Id number	Int	7
Customer_Id	Customer Id number	Varchar	7
Delivery_Id	Delivery Id	Varchar	7
First_Name	Customer First Name	Int	30
Last_Name	Customer Last Name	Text	30
Phone_number	Customer Contact Number	Varchar	15
Bill_Amount	Customer Bill	Varchar	5

Table Key

Table Name	Field Name	Key Type
Bill	Bill_Id	PK
Customer	Customer_Id	PK
Delivery	Delivery_Id	PK
Employees	Employees_Id	PK
Services	Services_Id	PK
Transaction	Transaction_Id	PK

Conclusion

This system is made to cater the needs of customer that is why I come up with this pick-up and delivery services to give more efficiency and more convenient to the easy life style of the customer.

For More Database Design Examples

• ER Diagram for Sales and Inventory System Database Design
• Ordering System Database Design with ERD
• ER Diagram for Water Refilling Station System Database Design
• Database Design for High School Enrollment System
• Database Design for Customer Management System
• Database Design Project for Inventory Management System

Inquiries

If you have any questions or suggestions about Laundry Management System Database Design, please let me know by dropping your comment below.