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 / 5Q.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)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.
Q.2.1.1
A database in the context of Thabo's bakery is a structured collection of data that is organized in a way that allows easy access, management, and retrieval of information related to the bakery's operations. It can include information such as customer details, inventory levels, sales data, and recipes.
Q.2.1.2
- Improved data organization and management: A relational database allows for the efficient storage and retrieval of data, making it easier to track inventory, manage customer orders, and analyze sales data.
- Data integrity and consistency: By using a relational database, Thabo can ensure that data is accurate and consistent across all tables, reducing the chances of errors or discrepancies.
- Enhanced data security: With a relational database, Thabo can implement strict access controls and permissions to protect sensitive information, keeping the bakery's data secure from unauthorized access.
Q.2.1.3
- Supplier table
- Employee table
Q.2.1.4
For the Supplier table:
- Supplier ID (Primary Key)
- Supplier Name
- Supplier Contact Information
For the Employee table:
- Employee ID (Primary Key)
- Employee Name
- Employee Role
Q.2.1.5
- Supplier table: Supplier ID
- Employee table: Employee ID
Q.2.1.6
If we consider the Supplier table in relation to the Employee table, the foreign key would be Supplier ID in the Employee table, linking back to the Supplier ID in the Supplier table.
Q.2.1.7
Supplier table:
- Supplier ID: 001, Supplier Name: ABC Suppliers, Supplier Contact Information: 123-456-7890
- Supplier ID: 002, Supplier Name: XYZ Distributors, Supplier Contact Information: 987-654-3210
- Supplier ID: 003, Supplier Name: Bakery Essentials, Supplier Contact Information: 555-123-4567
Employee table:
- Employee ID: 001, Employee Name: John Doe, Employee Role: Baker
- Employee ID: 002, Employee Name: Jane Smith, Employee Role: Cashier
- Employee ID: 003, Employee Name: Mike Johnson, Employee Role: Sales Manager
Q.2.2
(Infographic description to be included)