You have been hired by a small online bookstore called ReadMore to help improve their order processing system.

The current process works as follows:

1. A customer file in an online order form with book and shipping details.
2. The system validates the input (e.g. all fields filled, address format correct).
3. If the input is valid, the order is saved to the Orders database.
4. A confirmation email is sent to the customer.
5. If any details are missing or invalid, an error message is displayed, and the user is asked to try again.

A local public library is creating a database to manage its book loans. The system will track books, library members, and loan transactions to help staff know who has borrowed what and when items are due back.

A retail business is transitioning from using a series of disconnected spreadsheets and paper invoices to a centralised cloud-based business management system. The system will store key information such as customer contact details, purchase history, payment data, and stock levels at each retail location.

Previously, staff accessed customer information from their individual devices or emailed versions of spreadsheets to each other. This led to issues such as inconsistent records, duplicated files, and occasional unauthorised access to customer details.

Intelligent systems are increasingly used to automate decisions in areas such as employment, surveillance, and personalised recommendations.

You are part of a student team tasked with developing a new school event management system. The system will allow students and staff to create, manage, and register for school events. The school has limited time and budget, but the system must be user-friendly and adaptable to future needs.

I-Can-Swim academy is a start-up enterprise offering course in a range of cybersecurity fields. The classes available are determined by the following criteria:

Age Range:

• 10 – 15 years:
  • Class Available: Turtle
  • Skills Covered: Offensive training only
  • Cost: $100
• 16 – 21 years:
  • Class Available: Dolphin
  • Skills Covered: Offensive or Defensive training
  • Cost: $150
• Over 21 years:
  • Classes Available: Orca, Dolphin, and Turtle
  • Orca Class:
    • Skills Covered: Both offensive and defensive training
    • Cost: $400
  • Dolphin Class:
    • Skills Covered: Defensive training only
    • Cost: $150
  • Turtle Class:
    • Skills Covered: Offensive training only
    • Cost: $100

An extract of the information stored in the company's database tables is shown.

Customers

Class

When working with data, it is important to understand the different types of data and how they are used. It is equally necessary to ensure that data is collected, stored and presented in ways that are accurate and free from bias.

During your Enterprise Project, you were required to research, source, organise and store data.

A company aims to utilise a spreadsheet to develop a decision support system that will optimise its employee promotion process. The company's promotion decisions are based on three key performance metrics for each employee. A higher score indicates a more eligible candidate for promotion.

The punctuality score:

If an employee maintains an attendance record with fewer than the lateness threshold arrivals in a quarter, they earn 10 points. Otherwise, they receive zero points. The threshold for late arrivals should be entered as data in the spreadsheet, allowing adjustments based on future policy changes.

The project experience score:

Employees earn points based on the number of projects they have successfully completed. The table below shows the points assigned according to the number of projects completed.

The performance review score:
Each employee undergoes a performance review and receives a score out of 100.

The spreadsheet shows one employee, Fred Nerk, and his performance.

Momentum Gym Group operates gyms across both metropolitan and regional areas in Australia. In 2023, the company has collected data on membership sign-ups, class attendance, and equipment usage.

An interactive dashboard has been developed to support management in identifying usage trends and forecasting future needs. The company is now exploring ways to integrate an intelligent system, such as AI-driven class scheduling or predictive maintenance alerts based on equipment usage patterns.