The company named Reduce e-waste collects data from users to make informed business decisions - NSC Information Technology - Question 4 - 2022 - Paper 2
Question 4
The company named Reduce e-waste collects data from users to make informed business decisions.
4.1 A loyalty program at stores is a way in which invisible data capt... show full transcript
Worked Solution & Example Answer:The company named Reduce e-waste collects data from users to make informed business decisions - NSC Information Technology - Question 4 - 2022 - Paper 2
Step 1
4.1.1 Give another example of invisible data captured about a customer during purchases, other than their personal details such as name, surname and address.
96%
114 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
One example of invisible data captured about a customer is their purchasing habits or preferences. This can include insights such as which products they frequently buy or the times of day they usually make purchases.
Step 2
4.1.2 Give ONE reason why a company would want to capture invisible data on the purchases made by cardholders.
99%
104 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
A company may want to capture invisible data to predict and plan other products to stock, based on the purchasing behaviors of their customers.
Step 3
4.1.3 Except for card readers and credit cards, name TWO other mechanisms of invisible data capturing.
96%
101 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Two mechanisms of invisible data capturing include:
Online activities such as web searches and online purchases.
Security camera footage that provides insights into customer behavior in stores.
Step 4
4.2.1 State TWO ways of ensuring the validity of captured data.
98%
120 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Two ways to ensure the validity of captured data are:
Format check, which verifies that the data entered meets a predetermined format.
Data type check, which confirms that the data entered adheres to the expected data type.
Step 5
4.2.2 How can two customers with the same name and surname be distinguished in the database?
97%
117 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Two customers with the same name and surname can be distinguished in the database by allocating each customer a unique primary key, like a Customer ID.
Step 6
4.3.1(a) What is the term given to the unnecessary repetition of data across multiple records?
97%
121 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The term given to the unnecessary repetition of data across multiple records is data redundancy.
Step 7
4.3.1(b) An update anomaly can occur when data is repeated unnecessarily. Explain how an update anomaly takes place.
96%
114 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
An update anomaly occurs when a record cannot be changed at a single entry but has to be changed at multiple entries. This leads to inconsistencies and potential data integrity issues if one or more records are not updated simultaneously.
Step 8
4.3.2(a) Identify the type of relationship presented in the diagram: Worker has Job.
99%
104 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The relationship presented in the diagram 'Worker has Job' is a One-to-One relationship.
Step 9
4.3.2(b) Identify the type of relationship presented in the diagram: Company has Customers.
96%
101 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The relationship presented in the diagram 'Company has Customers' is a One-to-Many relationship.
Step 10
4.4.1 Name the type of key formed when multiple fields are used together as the primary key.
98%
120 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The type of key formed when multiple fields are used together as the primary key is called a Composite or Compound key.
Step 11
4.4.2 Suggest another key field that can be created in tblCollections instead of using the three fields as the primary key.
97%
117 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Another key field that could be created in tblCollections is 'CollectionNumber' or any suitably chosen new field.
Step 12
4.4.3 What will the data type of the primary key field in table tblClients be?
97%
121 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The data type of the primary key field in table tblClients will be Short Text, as it typically identifies clients using a unique identifier.
Step 13
4.4.4 Explain the term referential integrity.
96%
114 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Referential integrity ensures that the data in the foreign key of one table corresponds to a valid entry in the primary key of another table, preventing orphaned records and maintaining consistency across the database.
Step 14
4.4.5(a) Indicate whether the following statements related to parallel data sets are TRUE or FALSE: Multiple copies of the data are kept.
99%
104 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
True.
Step 15
4.4.5(b) Indicate whether the following statements related to parallel data sets are TRUE or FALSE: Data integrity is enhanced when a data set goes missing.
96%
101 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
False.
Step 16
4.4.5(c) Indicate whether the following statements related to parallel data sets are TRUE or FALSE: Parallel data sets are used when mining data.
98%
120 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
