Photo AI
A data capturer captures all organisational data - NSC Information Technology - Question 4 - 2019 - Paper 2
Question 4
A data capturer captures all organisational data. 4.1.1 Explain what the GIGO principle is. 4.1.2 Name TWO types of checks to ensure that the captured data is vali... show full transcript
Worked Solution & Example Answer:A data capturer captures all organisational data - NSC Information Technology - Question 4 - 2019 - Paper 2
Step 1
Explain what the GIGO principle is.
Answer
The GIGO principle stands for "Garbage In, Garbage Out." It emphasizes that the quality of output is determined by the quality of the input. If incorrect or low-quality data is entered into a system, the results generated will also be flawed or misleading.
Step 2
Name TWO types of checks to ensure that the captured data is valid.
Answer
-
Format Check/Input Mask: This ensures that the data entered follows a specified format, such as a phone number having a specific number of digits.
-
Range Check/Validation Rules: This type of check ensures that the data falls within predefined limits, such as a person's age being between 0 and 120.
Step 3
What does the concept logical integrity of data refer to in general?
Answer
Logical integrity of data refers to the correctness and consistency of the data within a database. It ensures that the data accurately represents the real-world entities and relationships it is supposed to depict, thus maintaining data accuracy and reliability.