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.
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
Table 1: tblcustomer
|Customer id||Customer ID number PK||Int||11|
|Customer name||Customer name||Varchar||30|
|Contact number||Customer contact number||Int||30|
Table 2: tblemployee
|Employee id||Employee id||Int||11|
|Employee name||Employee name||Varchar||50|
|Employee number||Employee number||Int||12|
|Job title||Employee job title||Varchar||50|
Table 3: tblservices
|Services id||Services id number||Int||11|
Table 4: tbltransaction
|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|
|Bill id||bill id||Int||11|
|Customer id||Customer id||Int||100|
|Bill amount||Bill amount||varchar||30|
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.