Q.1.1.1
Thabo’s bakery employs a Customer Relationship Management (CRM) tool to oversee communication with the bakery's new customers in various locations.
(3)
Q.1.1.2
Thabo's bakery, facing egg shortages, subscribes to a meticulously researched combination of databases and analyst reports to manage its financial information.
(3)
Q.1.1.3
Thabo relies on a crowdsourced online video library to research and learn maintenance and troubleshooting tasks for the bakery's ovens and baking equipment.
(3)
Q.1.1.4
Thabo oversees updates to the mobile time tracking app used by employees to report their working hours.
(3)
Q.1.1.5
Thabo’s bakery needs an Information system to improve the delivery and transportation of both products and supplies.
(3)
Q.1.2
Recommend a cloud storage service provider Thabo can utilise for the business. Discuss four reasons and/or advantages to this approach for the business.
(10)
Q.1.3
Distinguish, with applicable examples, between Shareware and Freeware.
(5)
Question 1 (Marks: 30)
The Case Study below is the same as provided in Assignment 1. In this assignment, you will continue to provide guidance to Thabo regarding Information Systems. In addition to your module manual, you are recommended to conduct additional research.
Thabo operates a small bakery and currently manages inventory and sales through manual record-keeping. Due to recent challenges, particularly shortages in the egg supply, Thabo is concerned about efficiently handling customer orders while also addressing the issue of egg scarcity. You've proposed the implementation of an information system that enables customers to place orders online for either delivery or pickup. Despite the potential benefits, Thabo is hesitant about transitioning to a computerised information system and requires convincing about its advantages for the bakery, especially in navigating the current egg shortages.
4 / 5
Q.2.1
Provide the following to Thabo, so that he gets a better understanding of Databases:
Q.2.1.1
Describe the concept of a database in the context of Thabo’s bakery.
(3)
Q.2.1.2
Explain three advantages of using a relational database at the bakery.
(3)
Q.2.1.3
Besides Customer and Order tables, List any other two tables that could be added in Thabo’s bakery database.
(2)
Q.2.1.4
List any 3 fields that could be associated with each table listed above.
(6)
Q.2.1.5
Specify primary keys for each table listed in Q.2.1.3.
(2)
Q.2.1.6
Specify any foreign key for a table.
Identify the table and the Foreign key in that table.
(2)
Q.2.1.7
Populate each table listed in Q.2.1.3, with at least 3 records for each table.
(6)
Q.2.2
Using an infographic, present the hierarchical relationship among data, information and knowledge, with explanation and an example for each, applicable to the bakery. Ensure the data hierarchy is listed in a logical order from the lowest to the highest.
(15)
Q.2.3
What are the differences between physical and logical views of information. Explain using examples from the scenario.
(6)
Q.2.4
In your own words, explain a data warehouse then identify at least two (2) inputs and two (2) outputs of a data warehouse.
(5)
Question 2 (Marks: 70)
Thabo is eager about the potential implementation of a new information system for the bakery. In this segment, the objective is to assist Thabo in understanding essential database concepts and how they will prove beneficial for optimising the bakery's day-to-day operations. Additionally, the discussion will delve into specific aspects of the bakery's workflow, such as inventory management, customer orders, and recipe tracking, to showcase the comprehensive advantages offered by a well-structured database system.
5 / 5
Q.2.5
Q.2.5.1
Explain the concept of Big Data, along with the three (3) dimensions of Big data, using examples relevant to Thabo’s bakery.
(11)
Q.2.5.2
Provide your opinion, whether it’s necessary for Thabo to implement Big Data tools and technologies at this point in the business. Justify your opinion.
(4)
Q.2.6
You have explained to Thabo that he needs to consider implementing tools for Business Analytics for his business to allow him to look into the future and what might possibly happen in the future.
Explain to Thabo, in your own words, the concept of mobile analytics. Provide two (2) useful reasons for utilising mobile analytics
(6)
Mobile analytics is the process of collecting, measuring, and analyzing data from mobile devices and apps to gain insights into user behavior and trends. It helps businesses understand how customers interact with their mobile platforms and make data-driven decisions to improve user experience and drive business growth.
Two useful reasons for utilizing mobile analytics in Thabo's bakery could be:
1. Tracking customer behavior: By analyzing data related to customer interactions with the bakery's mobile platform, Thabo can better understand customer preferences, buying patterns, and satisfaction levels. This information can be used to tailor marketing strategies, improve product offerings, and enhance customer engagement.
2. Performance monitoring: Mobile analytics can provide real-time data on the performance of the bakery's mobile app, such as app usage, crashes, and load times. Thabo can use this information to identify and address any technical issues, optimize user experience, and ensure smooth operation of the mobile platform for customers.