Laundry Management System Database Design

0
93

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

Laundry Management System Database Design

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

Inquiries

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

Looking for more source code? Type your keyword here here!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.