DSS Coursework 1: Data-Driven Performance Evaluation for Hair Salon

This assignment involves the creation of a Decision Support System (DSS) designed to evaluate the performance of hair stylists in a salon. The project includes the design of several database tables, including a 'Customers' table with fields for customer details, a 'Ranking the customers' table for performance metrics based on various factors, and an 'Appointment' and 'Booking' table to record appointment and booking details. The DSS aims to provide a holistic evaluation of hair stylists, considering factors beyond just sales, such as customer referrals, appointment frequency, and cancellation rates. The project also addresses the need for data-driven insights to inform marketing strategies for a new baby product e-commerce business. The goal is to understand consumer behavior and the effectiveness of social media marketing efforts. The assignment uses data analysis to create an Instagram-based DSS to track marketing performance.

Customers Table:
P/F FIELD NAME DATA TYPE FIELD
SIZE
NOTES
Name Varchar 20 This field holds full name of a
customer.
Contact int Contact column store every
contact number of a customer.
BirthDate date Birth Date field store every date
of birth of a customer.
CurrentAge decimal This field store current age of
the customer.
Days_Till_BirthDate int This column can generate how
many days are remaining for
birthdays
Date_joined date Date joined table defined the
join date of a customer.
Duration_as_member Decimal This column define the duration
time of a member.
30_Days_before_membership date This field indicate date before 30
days before of their membership.
Ranking the customers:
P/F FIELD NAME DATA TYPE FIELD SIZE NOTES

Name Varchar2 This field indicates the
full name of a customer
Amount spent to
date
decimal This field reflect the total
amount that a customer
spent.
Point int Points column indicate
the total point of a
customer.
No of referrals int Total number of referrals
are shown in this field.
Points int This field indicate the
point of customer. This
point is based on total
number of referrals.
Frequency of
appointments
int This field indicates the
total number of
appointment frequency
Points int This point are given
based on appointment
frequency
Number of
cancellation
int Total number of
cancellation can store
here
Points int Based on cancellation

Total points int Total points reflect here
Member char 20 This field indicate the
Member type.
Actions varchar 200 Actions based on total
points.
Appointment Table:
P/F FIELD NAME DATA TYPE FIELD SIZE NOTES
P Appoint_ID Int Appointment id is store
in this field.
Appointment_Date Date Details of date of
appointment are store in
this field.
Description varchar Description of the
appointment are store in
this field.
Booking Table:
P/F FIELD NAME DATA TYPE FIELD SIZE NOTES
Booking_ID Int Booking id store in this

field.
Booking_Date Date Booking date are store in
this field.
Booking_Type varchar Type of this booking are
store in this field.