$1$ HPXS$200-1-$Jan$-$Jun$2024-$SA$1-$RM$-$V$2-0612203$

Academic Year $2024$: January $-$ June

Summative Assessment $1$: Praxis $2($HPXS$200-1)$

NQF Level, Credits: $6,20$

Weighting: $50\%$

Assessment Type: Project

Educator: Luvuyo Ngcobo

Examiner: Ralph Mavhunga

Due Date: $10$ June $2023$

Total: $70$ Marks

Instructions

$1.$ Your submission should be a PDF document for your database design section and

a MySQL file for showing your database.

$2$ HPXS$200-1-$Jan$-$Jun$2024-$SA$1-$RM$-$V$2-0612203$

Question

One sunny afternoon, your close friend, Dominic, the proud yoga studio owner, arrives at your

doorstep in distress. She recently embarked on a journey to digitise her business by hiring a web

developer to create a website for her yoga studio. Regrettably, the developer vanished into thin

air, leaving her financially and professionally in a precarious situation. Knowing your knack for

design and technological expertise, Dominic comes to you with a plea for help resurrect her online

aspirations. She shares with you the following user requirements, which mirror her studio's needs:

Homepage Introduction:

Dominic envisions a welcoming homepage for her yoga studio's website. This page briefly

introduces the studio, its philosophy, and its services.

Detailed Service Pages:

Each yoga service provided at the studio should have its dedicated page. These service pages

should include comprehensive descriptions, class schedules, instructor profiles, and pricing

information.

Online Booking System:

Dominic places significant importance on convenience for her clients. She wishes for an online

booking system that allows her students to easily select a service, pick a convenient date and

time for their yoga class, and check class availability. Once their choices are made, the website

should display the total cost for the selected class and request confirmation from the student.

$3$ HPXS$200-1-$Jan$-$Jun$2024-$SA$1-$RM$-$V$2-0612203$

Payment Gateway:

An integral part of the website is an integrated payment gateway. This will permit clients to

complete their booking by paying for their classes online through credit or debit cards, ensuring a

seamless experience.

In her quest to bring order to the studio, Dominic hands over a spreadsheet she's been using to

manage her classes manually.The spreadsheet contains columns for the student's name, contact

details, selected service, date and time of the class, and the amount paid. Dominic expects this

spreadsheet to serve as the foundation for the database design of the website.

With Dominic's hopes and dreams now in your hands, you're tasked with weaving these elements

into a beautifully designed and fully functional website for her yoga studio, ensuring a seamless

experience for her students and a renewed sense of digital vitality for her business.

You are required to:

$1.$ Use your knowledge to determine the business rules.

$2.$ Design the appropriate database for Dominic$$s beauty salon.

$3.$ Draw the ER diagram to determine how the database tables are related.

$4.$ Create a MySQL file for the database and create the database tables. For each table, add at

least three $(5)$ made$-$up records.

$5.$ Write a summary of any assumptions that you made in designing. Include any changes that

are different from the requirements stated above, and justify those changes.

Use the rubric at the end of this document to guide you.

$3$ HPXS$200-1-$Jan$-$Jun$2024-$SA$1-$RM$-$V$2-0612203$

$4$ HPXS$200-1-$Jan$-$Jun$2024-$SA$1-$RM$-$V$2-0612203$

Rubric

No Criteria Requirements Total

Marks

$1$

Database

$(25$ marks$)$

All appropriate database tables are shown in the MySQL database file $($

up to $15$ marks$)$

Each of the tables has appropriate columns $($up to $5$ marks$)$

The tables have made up records as per instruction $($up to $5$ marks$)$

$25$

$2$

Working

$(20$ marks$)$

Documentation shows how the user did the snormalisations of the table

columns to end up with the tables. $($up to $5$ marks$)$

There is a clear ER diagram showing the relationship between the tables

$($up to $10$ marks$)$

Normalisation was done thoroughly, and inefficiencies in data recording

sminimised

$($up to $5$ marks$)$

$20$

$3$

Style

$(5$ marks$)$

The student has used a naming convention for tables and columns, i$.$e$.,$

field names are in correspondence with their function $(3$ marks$)$

There is consistency in the naming style, e$.$g$.,$ if the student uses camel

cases for column names, then all column names have camel case, etc.

$(2$ marks$)$

$5$

$4$

Documentation

$(20$ marks$)$

The documentation professionally communicates any justified changes

made to the initial requirements and any assumptions made in the

design. There is also communication on the description of the database

tables. $($up to $10$ marks$)$

The student also stated the business rules for the database. $($up to $10$

marks$)$

$20$