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
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
An example of invisible data captured about a customer during purchases is their purchasing habits or preferences, such as how often they buy a specific product.
Step 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 would want to capture invisible data to predict or plan other products to stock, which helps in inventory management and enhances customer satisfaction.
Step 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 tracking (such as web searches) and GPS navigation data.
Step 4
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 include conducting format checks and performing range checks on the data.
Step 5
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 by assigning a unique identifier or primary key to each customer.
Step 6
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
An update anomaly can occur when data is repeated unnecessarily. Explain how an 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 change in one instance of data requires a corresponding change in multiple entries; if one entry is updated and others are not, it leads to inconsistent data.
Step 8
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 is a 'One-to-Many' relationship, as a worker can have multiple jobs.
Step 9
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 is also a 'One-to-Many' relationship, as a company can have multiple customers.
Step 10
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 is called a 'Composite' or 'Compound' key.
Step 11
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 can be created in tblCollections is 'CollectionNumber' or an autoincrement field.
Step 12
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.'
Step 13
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 a foreign key field must already exist as an entry in the table where the field is the primary key, thus maintaining accuracy and reducing errors.
Step 14
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
Indicate whether the following statements related to parallel data sets are TRUE or FALSE. Data redundancy is minimized when a data set gets changed.
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
Indicate whether the following statements related to parallel data sets are TRUE or FALSE. Data parallel sets can lead to confusion 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!
Answer
True.
Step 17
Indicate whether the following statements related to parallel data sets are TRUE or FALSE. Parallel data sets are useful when mining data.
97%
117 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
