Salon Management System Database Design Project

    0
    1288

    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

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

    LEAVE A REPLY

    Please enter your comment!
    Please enter your name here

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