Special Notes:

• For a more comprehensive understanding of the project specifications, kindly refer to the final page of the "ProjectBrief" document.s.

• While originally intended as a group effort, the challenges posed by COVID-19 restrictions necessitated remote collaboration. As a result, the project was undertaken and executed individually.

• To gain insight into the SQL queries formulated to extract data for the assignment questions, please refer to the attached Word document provided below..

(https://github.com/MiclAnglz/HairSalonDatabase/blob/main/DB_Assignment%202%20(final).docx)

HairSalonDatabase

DBMS Major Assignment - Microsoft SQL Spring Semester Database Management and Design

Task: Develop a comprehensive Microsoft SQL database solution for a fictional beauty salon, encompassing the creation of a Global Relation Diagram (GRD) and an Entity-Relationship Diagram (ERD) enriched with detailed entity dependencies, multiplicities, and entity relationships.

Database Requirements:

1. Staff Information:

Maintain a repository of all staff members along with their respective job positions within the beauty salon.

2. Therapist Specialization and Rates:

Distinguish among the staff members who serve as therapists and outline the rates associated with specialized therapies they offer. Notably, not all therapists provide specialized therapy, and the hourly rates can vary between therapists.

3. Treatments Catalog:

Catalog all available treatments offered by the salon, including their corresponding prices.

4. Customer Profiles:

Store comprehensive details of both regular customers and walk-ins, encompassing attributes such as contact information (phone number, email, name), and treatment history.

5. Treatment Records:

Record details for each customer's treatment, capturing information such as the specific treatment received, date of treatment, price paid, and the therapist responsible.

6 Entity Relations:

Establish clear relationships among the different entities, ensuring accurate representation of their associations and interactions within the salon's operations.

7. Entity Dependencies and Multiplicities:

Thoroughly define the dependencies between various entities, outlining their corresponding multiplicities to facilitate a comprehensive understanding of data relationships.

In total of seven tables were mecreated to effectively capture the diverse aspects of the beauty salon's operations, providing a robust foundation for the database solution.