NSC Information Technology Caring for and managing data: 4.1 A loyalty program at stores

Question

4.1 A loyalty program at stores is a way in which invisible data capturing can take place.

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.

4.1.2 Give ONE reason why a company would want to capture invisible data on the purchases made by cardholders.

4.1.3 Except for card readers and credit cards, name TWO other mechanisms of invisible data capturing.

4.2 The company uses a database to store details of their customers.

4.2.1 State TWO ways of ensuring the validity of captured data.

4.2.2 How can two customers with the same name and surname be distinguished in the database?

4.3 The company attempted to improve the design of their database.

4.3.1 It was found that some of the data was repeated in the database.

(a) What is the term given to the unnecessary repetition of data across multiple records?

(b) An update anomaly can occur when data is repeated unnecessarily. Explain how an update anomaly takes place.

4.3.2 A relationship between tables can be created rather than repeating data in different tables. Identify the type of relationship presented in EACH of the following diagrams:

(a) Worker ↔ Job

(b) Company ↔ Customers

4.4 The database CollectionDB used by the recycling company consists of two related tables, tblClients and tblCollections. The details of collections for recycling are saved in table tblCollections.

Field Name       Data Type      Description (Optional)
ClientID          Short Text     The ID of the client dropping off items for recycling
CollectionDate    Date/Time      The date of the collection
CollectionTime    Date/Time      The time of the collection
CollectionWeight  Numeric        The weight of the collection

4.4.1 Name the type of key formed when multiple fields are used together as the primary key.

4.4.2 Suggest another key field that can be created in tblCollections instead of using the three fields as the primary key.

4.4.3 The field ClientID also serves as the foreign key in table tblCollections.

What will the data type of the primary key field in table tblClients be?

4.4.4 Referential integrity is enforced between the two tables tblCollections and tblClients. Explain the term referential integrity.

4.4.5 The accounts department uses parallel data sets to store the data they work with.

Indicate whether the following statements related to parallel data sets are TRUE or FALSE. Write only ‘true’ or ‘false’ next to the question numbers (4.4.5(a) to 4.4.5(d)) in the ANSWER BOOK.

(a) Multiple copies of the data are kept.

(b) Referential integrity is observed when a data set gets damaged.

(c) The data is reliable only if it contains references to records in the primary/one table.

(d) Parallel data sets are used when mining data.

4.1 A loyalty program at stores is a way in which invisible data capturing can take place - NSC Information Technology - Question 4 - 2022 - Paper 2

Worked Solution & Example Answer:4.1 A loyalty program at stores is a way in which invisible data capturing can take place - NSC Information Technology - Question 4 - 2022 - Paper 2

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.

4.1.2 Give ONE reason why a company would want to capture invisible data on the purchases made by cardholders.

4.1.3 Except for card readers and credit cards, name TWO other mechanisms of invisible data capturing.

4.2.1 State TWO ways of ensuring the validity of captured data.

4.2.2 How can two customers with the same name and surname be distinguished in the database?

4.3.1 (a) What is the term given to the unnecessary repetition of data across multiple records?

4.3.1 (b) An update anomaly can occur when data is repeated unnecessarily. Explain how an update anomaly takes place.

4.3.2 (a) Identify the type of relationship presented in the diagram: Worker ↔ Job.

4.3.2 (b) Identify the type of relationship presented in the diagram: Company ↔ Customers.

4.4.1 Name the type of key formed when multiple fields are used together as the primary key.

4.4.2 Suggest another key field that can be created in tblCollections instead of using the three fields as the primary key.

4.4.3 What will the data type of the primary key field in table tblClients be?

4.4.4 Explain the term referential integrity.

4.4.5 (a) Multiple copies of the data are kept.

4.4.5 (b) Referential integrity is observed when a data set gets damaged.

4.4.5 (c) The data is reliable only if it contains references to records in the primary/one table.

4.4.5 (d) Parallel data sets are used when mining data.

Join the NSC students using SimpleStudy...