HIGHER EDUCATION PROGRAMMES

Academic Year 2025: January - June

Formative Assessment 1: Systems Development 3 (HSYD300-1)

NQF Level, Credit: 6, 30

Weighting: 40%

Assessment Type: Structured Questions

Educator: Stephen Maduveko

Examiner: Ralph Mavhunga

Due Date 27 March 2025

Total 100 Marks

Instructions

1. This paper consists of four (4) questions.

2. It is based on chapters 1 – 13 of your textbook

3. Submit the code solutions for questions 1 - 4 in one pdf document

4. A Copyleaks Report will be issued via ColCampus once the assignment is

submitted. Please ensure that you follow the correct steps when uploading your
assignment, to ensure that the Copyleaks Report is correctly issued. If the
incorrect document is uploaded, or if no Copyleaks Report is issued, a mark of
zero (0) will be awarded. If the Copyleaks Report indicates that a 30%
similarity/plagiarism score has been exceeded, 25% of the assessment total
will be deducted from the final grade.

1 HSYD300-1-Jan-Jun2025-FA1-RM-V3-06012025
Learning outcomes assessed in this assessment:

• Understand the theory of material design and its effects on the GUI.
• Understand the structure of PHP
• Variables and constants
• Benefits of using predefined constants in programming
• Variable access and scopes
• The flow of logic in a PHP program through dry running/code inspection
• Operation and behaviours of common PHP functions
• Error handling
• String manipulation
• Function definition and function calling
• Return values from functions
• PHP file processing
• Arithmetic operators, function definitions and function calls

Question 1 [25 marks]

You are tasked with designing a PHP-based product management system for an e-
commerce platform. The system will allow users (store owners) to manage their
product inventory with functionalities for adding, editing, deleting, and viewing
products. Additionally, the system should calculate the total price based on product
quantities and prices, helping the store owner assess stock value.

Required

Design an e-commerce product management system that allows users to:

1. Add products: Input product name, description, price, and quantity.

2. Edit products: Modify existing product details.
3. Delete products: Remove products from the system.
4. View product list: Display all products in a table format.
5. Calculate total price: Compute the total price based on product quantities and
prices.

2 HSYD300-1-Jan-Jun2025-FA1-RM-V3-06012025
Rubric

Criteria Marks
HTML structure: Create a basic HTML layout with forms, tables, and 5
buttons.
PHP logic: Implement PHP code to handle form submissions, data 2
processing, and display.
Data storage: Use an array to store product information. 5
Control structures: Employ conditional statements (if-else, switch) and 2
loops (for, while) to control program flow.
Functions: Define functions for common tasks like adding, editing, 7
deleting, and displaying products.
Data validation: Ensure user input is valid non-empty price and numeric 2
for price).
Error handling: Implement error handling mechanisms to prevent 2
unexpected behaviour.

Question 2 [25 marks]

Design an application that calculates the speed required for a car to catch up with
another car that is 40 kilometres ahead. The user should input the car's speed ahead
and the time that has elapsed since the car started. Additionally, the application
should:

• Store historical calculation data in a multidimensional array.

• Use functions for calculations and data manipulation.

• Format the results for a clear presentation.

• Save calculation data to a file for future reference.

3 HSYD300-1-Jan-Jun2025-FA1-RM-V3-06012025
Rubric

Criteria Marks

Multidimensional arrays: Use multidimensional arrays to store historical 4

calculation data.

Functions: Define calculations, data manipulation, and file operations 5

functions.

String handling: Format the calculated speed with appropriate units and 4
decimal places.

File handling: Create and write calculation data to a file (e.g., txt). 4

User input: Handle user input (e.g., speed of car ahead, time elapsed) 4
and validate it.

Error handling: Implement error handling mechanisms to prevent 4

unexpected behaviour.

Question 3 [30 marks]

You are tasked with designing a game called "Leap of the Frog" with a MySQL
database. In this game, players help a frog cross a river by timing its jumps based on
the leaves that fall onto the river. The river has several positions, and the frog can only
jump to positions where a leaf has landed. The goal is to get the frog safely across the
river as quickly as possible.

Ultimately, you are required to design an application that simulates a frog attempting
to cross a river. The frog starts on one bank (position 0) and needs to reach the
opposite bank (position X+1). Leaves fall from a tree onto the river, and the frog can
only jump to positions covered by leaves. Given an array A representing the positions
of falling leaves over time, determine the earliest time the frog can cross the river.

4 HSYD300-1-Jan-Jun2025-FA1-RM-V3-06012025
Database Structure:

Create a MySQL database table named leaf_positions with the following columns:

• id (INT, AUTO_INCREMENT, PRIMARY KEY): Unique identifier for each leaf

position record.

• time (INT): Time in seconds when the leaf falls.

• position (INT): Position where the leaf falls.

Rubric

Criteria Description Marks

Database Design Correctly creating the leaf_positions table 10
with the required columns: id, time, and
position.

Proper use of data types (INT,

AUTO_INCREMENT, PRIMARY KEY) for
each column.
Game Logic and Simulation Implementation of a correct and efficient 10
algorithm to determine the earliest time the
frog can cross the river based on the
leaf_positions data

Implementing error handling and validation

User Interface Creating an intuitive and user-friendly 5
interface for players to interact with the
game
Code Quality Writing well-structured, clean, and readable 5
code that follows best practices

5 HSYD300-1-Jan-Jun2025-FA1-RM-V3-06012025
Question 4 [20 marks]

You are tasked with designing an Olympic fantasy game. In this game, players assume
the role of an Olympic event manager responsible for recording, organising, and
managing the results of various Olympic competitions. The goal is to manage and
retrieve results efficiently, ensuring the accuracy and timeliness of the records.

As an HSYD300-1 student, design an Olympic fantasy game with the specifications

outlined above and other additional features listed below that allow users to:

1. Input results: Enter the athlete's name, event, and result for each Olympic
competition.

2. View results: Display a list of all recorded results, sorted by event or athlete.

3. Search results: Search for results based on athlete name, event, or result.

4. Update results: Modify existing results.

5. Delete results: Remove results from the system.

Rubric

Criteria Marks
HTML forms: Create HTML forms with appropriate input fields (text, 5
number, select) for data entry.
PHP data handling: Use PHP to retrieve and process form data, validate 5
input, and interact with the database.
HTML5 enhancements: Utilize HTML5 features like required, placeholder, 2
datalist, and input types (e.g., date, time) for enhanced user experience.
User tracking: Implement session tracking to store user preferences and 3
maintain session information.
HTTP authentication: Use HTTP authentication (e.g., Basic, Digest) for 2
password-protected areas.
Database: Create a MySQL database table to store Olympic results data. 3

6 HSYD300-1-Jan-Jun2025-FA1-RM-V3-06012025