Salon Management System Database Design Project

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

Salon Management System Database Design Project
Salon Management System Database Design Project

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.

Related Articles you may Like

Leave a Comment