Database Answers Logo Hairdressers at Work
Cinema Cinema
Home Ask a Question Data Models FAQs SQL Scripts Search Site Map  
This Page defines the Requirements for a Database for a Hairdressing Salon.
It contains four Sections :
1. Things of Interest
2. How these Things are related
3. Characteristics of these Things
4. User Scenarios
  1. The Things of Interest include :-
    • Appointments
    • Clients
    • Payments
    • Salon Treatments
    • Staff

  2. How are these Things related :-
    • A Client can make, change or cancel one or many Appointments
    • An Appointment is made with a Staff Member, e.g. a Stylist, by a Client.
    • An Appointment is for a specified Date, Time and Duration.
    • A Client can be given a specified Salon Treatment.
    • Over a period of time, a Client can be given a number of different Treatments.

  3. Characteristics of these Things :-
    • A Client has :-
    • First Name, Last Name, Address, Home Phone Number, Email Address, Height, Weight, Date of Birth.

  4. User Scenarios :-
    1. The Client can select a Staff Member from those available.
    2. The Client will choose a Treatment from a List.
    3. The price of a Treatment will depend on the level of Staff member who gives the Treatment.

Barry Williams
Principal Consultant
Database Answers

[ Home Page | Ask Us a Question | Day in the Life | Email Us | FAQs | Site Map ]

© IceBreaker WebDesigns 2001