1. Data processing and information
A section of Information Technology, 9626
Listing 10 of 132 questions
Cynthia has created a database to store details of her friends in the UK and wants to include their home addresses. She will create a validation routine to check that the UK postcode of their address is in a valid format when it is entered into the database. UK postcodes must have an outward code and an inward code separated by a single space. The outward code is made up of the postal area and the postal district. The inward code also has two parts: the postal sector and the postal unit. A typical UK postcode is CB1 2EU. The whole postcode conforms to a format as shown by the examples in Fig. 2. UK Postcode Formats Outward Code Inward Code Area District Sector Unit Written as: Example 1: CB EU CB1 2EU Example 2: SW 1A AA SW1A 1AA Example 3: SW 1A AA SW1A 0AA Example 4: CV JQ CV4 8JQ Fig. 2 Using the information given above, describe what the validation routine would have to do in order to check that the entered postcode was in a valid format.
9626_s18_qp_31
THEORY
2018
Paper 3, Variant 1
View
An online store requires customers to create an account using its website. The online form for creating the account, with customer entries, is shown in Fig. 1. Create a Customer Account Note that all fields marked with * are required. Your first name* Your family name* Jasmine Singh Please enter a valid email ID Please re-enter your email ID Valid email address* Confirm email address* jasmine@singh.me jasmine@singh.me Please enter your DoB as I agree to the Terms and Conditions and to the Privacy Policy* Please check the box to show that you have read and agree to the terms. Password* Confirm password* *********** *********** Security question* Enter the answer* Mother’s first name Jaswinder Please select a question Enter a keyword for the answer Gender Date of birth (DoB)* Male Female month day year  Fig. 1 The data entered by the customer is checked for accuracy before it is submitted to the website. Describe, using the information shown in Fig. 1, how the data in the required fields (fields marked *) on the form could be checked. Describe one essential element that must be added to the form.
9626_s18_qp_32
THEORY
2018
Paper 3, Variant 2
View
Tick the most accurate statement referring to the use of a length check when validating data. ✓ It returns an error message if a data item is not in a lookup list. It checks to make sure a data item is within an upper limit and a lower limit. It checks that a data item consists of a set number of characters, not more or less. It is only used to check numbers. Tick the most accurate statement referring to the use of a check digit when validating data. ✓ It is used to check that the data in two fields correspond. It checks the number of digits. It is the digit added to the end of a long number after a calculation has been performed. It checks that a number is above a certain limit. The table shows data relating to a company’s products. The data can only take the values shown. Product number Weight 8.2 9.0 9.8 8.6 9.0 8.2 9.8 QY648 EA721 HH419 CG297 HE456 GC684 KZ638 Year patented A B Analyse the effectiveness of the use of type checks and format checks to validate this set of data. Do not refer to length checks or check digits in your answer.
9626_s21_qp_12
THEORY
2021
Paper 1, Variant 2
View
Julia is setting up a hairdressing business. She has recruited several staff. She is creating a database of all her staff and has written down all their details ready for entering into a computer. She will need to verify the data when it is entered. She has been told that she cannot use a parity check but should use visual verification and double data entry. By describing what is meant by a parity check, explain why it might not be suitable in this scenario. Compare the similarities and differences between the visual checking and double data entry methods of verification.
9626_s22_qp_12
THEORY
2022
Paper 1, Variant 2
View
A college uses a database to store student records. Each student has a unique ten-digit student number. The database stores the examination scores of each student. The maximum mark in each examination is 100. The database already has presence, existence and integrity validation checks built in. Describe three additional validation rules, using student number and examination scores as examples. For each rule, give a different reason why it can still allow inaccurate data to be entered. Rule 1 Reason 1 Rule 2 Reason 2 Rule 3 Reason 3
9626_s24_qp_13
THEORY
2024
Paper 1, Variant 3
View
Tick the four most accurate statements regarding validation and verification.  Verifying data is checking that data is correct. Validating data is checking that data is correct. Validation is the process of checking that the data entered into a system is the same as the source data. Visual verification is a type of verification. A range check is an example of verification. Validation is checking that data is sensible. A range check is the best check to make sure transposition has not occurred when typing in a bar code. Visual validation is a type of validation. Double data entry is a type of verification. A type check will prevent a letter of the alphabet being typed into a numeric field.
9626_w18_qp_12
THEORY
2018
Paper 1, Variant 2
View
Questions Discovered
132