Salon Management System Database Design Project
This is a sample of Salon Management System Database Design Project, It includes database schema design, Database tables and ERD for the management system for the salon.
Backgound
Salon Management System has a manual system that sometimes causes the customer to be annoyed or be bored because of the slow services. Some customers just leave the salon because they don’t know if it’s already their turn or not also the salon doesn’t have a waiting area where people can sit and wait for their turns.
That is the reason for the proponent why they want to develop the salon management system. The system could lessen the bored and annoyed looks from the customers on the salon and also the system could help to improve the services of the said salon.
Salon Management System is focused on how to improve the system services of the salon. It is a stand-alone system that can be accessed by the admin which is the owner and the employees of the salon. They need to have a computer to access the system. The admin can keep track of the inventory of products and add accounts of the incoming employees while the user will perform the queuing and the billing.
Salon Management System Database Design Features:
- Artist person skilled at a particular task
- Billing process of making out or sending the invoice
- Inventory complete listing of merchandise or stock
- Product article or substance that is manufactured or refined for sale
Entity Diagram of Salon Management System
Data Dictionaries
Table 1: tblcustomer
| Field Name | Description | Type | Length |
| Customer id | Customer ID number PK | Int | 11 |
| Customer name | Customer name | Varchar | 30 |
| Address | Customer address | Text | 30 |
| Contact number | Customer contact number | Int | 30 |
| Age | Customer age | Int | 30 |
| Payments | Customer payments | Int | 50 |
Table 2: tblemployee
| Field Name | Description | Type | Length |
| Employee id | Employee id | Int | 11 |
| Employee name | Employee name | Varchar | 50 |
| Employee number | Employee number | Int | 12 |
| Address | Employee address | Text | 100 |
| salary | Employee salary | Int | 30 |
| Job title | Employee job title | Varchar | 50 |
Table 3: tblservices
| Field Name | Description | Type | Length |
| Services id | Services id number | Int | 11 |
| Treatment | treatment name | varchar | 50 |
| quality | Quality number | varchar | 50 |
Table 4: tbltransaction
| Description | Type | Length | |
| Transaction id | transaction id | Int | 50 |
| Customer id | Customer id | int | 50 |
| Customer name | Customer name | Varchar | 100 |
| Bill amount | Amount of bill | int | 30 |
Table 5:tblbills
| Field Name | Description | Type | Length |
| Bill id | bill id | Int | 11 |
| Customer id | Customer id | Int | 100 |
| Bill amount | Bill amount | varchar | 30 |
| Price | Price | varchar | |
Conclusion
This Salon Management System Database Design Project is a requirement in the DBMS mini Project. if you want to develop your own Salon Management System, you can upgrade this database design to suit your requirements.