0478_s23_qp_23
A paper of Computer Science, 0478
Questions:
11
Year:
2023
Paper:
2
Variant:
3
Login to start this paper & get access to powerful tools
5
Four descriptions of validation checks are shown. Draw one line to link each description to the most appropriate check. Not all checks will be used. Description Check Write an algorithm in pseudocode to make sure that an input for the variable Length is between 15 and 35 inclusive. The code must iterate until a valid input has been made and the code must include appropriate messages. to check that the data entered is an integer check digit format check length check presence check type check to check that some data has been entered to check that the data entered has an appropriate number of characters to check that an identification number contains no errors
2. Data transmission  →  2.2. Methods of error detection
7. Algorithm design and problem-solving  →  7. Algorithm design and problem-solving
Open
6
An algorithm has been written in pseudocode to allow 100 positive numbers to be input. The total and the average of the numbers are output. 01 Counter 02 Total 03 WHILE Counter > 100 DO 04 INPUT Number 05 IF Number > 0 06 THEN 07 Total Total + Counter 08 Counter Counter + 1 09 ENDCASE 10 ENDWHILE 11 OUTPUT "The total value of your numbers is ", Total 12 OUTPUT "The average value of your numbers is ", Total / 100 Identify the four errors in the pseudocode and suggest corrections. Error 1 Correction Error 2 Correction Error 3 Correction Error 4 Correction Describe the changes you should make to the corrected algorithm so that a count-controlled loop is used to allow 100 positive numbers to be input. You do not need to rewrite the algorithm.
7. Algorithm design and problem-solving  →  7. Algorithm design and problem-solving
Open
7
The flowchart represents an algorithm. An input of –1 will terminate the algorithm. START Total INPUT Value STOP Five1 IS Value = –1 ? Value DIV 5 Value / 5 No OUTPUT "Rejected" OUTPUT Total IS Five1 = Five2 ? IS Ten1 = Ten2 ? No No Yes Yes Yes Five2 Value DIV 10 Ten1 Total + Value Total Value / 10 Ten2 Complete the trace table for the input data: 5, 50, 52, 555, 57, 500, –1, 5500, 55 Total Value Five1 Five2 Ten1 Ten2 OUTPUT Describe the purpose of the algorithm.
7. Algorithm design and problem-solving  →  7. Algorithm design and problem-solving
Open
10
A database table called Site1 stores details of some holiday homes at a holiday park. The database shows the type of home, number of guests, whether it is privately owned and the weekly rate to hire it. Name Type Private Rate$ NumberGuest Bay Lodge Lodge NO Bay View Cabin NO Blue Skies Cabin NO Cliff View Cabin NO Coppice Lodge Lodge NO Green Lodge Lodge NO Henry Cabin YES Hikers’ Rest Retreat NO Poppy Cabin NO Summer Joy Retreat YES Valley View Cabin NO West Lodge Lodge YES State the number of fields and the number of records in this database table. Fields Records Describe the purpose of a primary key. The database uses the data types: • alphanumeric • character • Boolean • integer • real • date/time. Complete the table to show the most appropriate data type for each field. Field Data type Type Private Rate$ NumberGuest Give the output that would be produced by the structured query language (SQL) statement: SELECT Name, NumberGuest, Rate$ FROM Site1 WHERE NumberGuest >= 10;
9. Databases  →  9. Databases
8. Programming  →  8.1. Programming concepts
Open
11
A two-dimensional (2D) array Contacts[] is used to store names and telephone numbers. All the data is stored as strings. The array must have the capacity to store 100 contacts in the form of: • column 1 – contact names as: last name, first name for example: Smith, John • column 2 – telephone numbers. The variable CurrentSize shows how many contacts are in the array. Write a program that meets the following requirements: • display a menu of choices: ○ enter new contact details ○ display all the contact details ○ delete all the contact details • validate the menu input • allow up to a maximum of five new contacts to be added to the array at any one time • do not allow more than 100 contacts in total • after new contacts have been added, sort the array by contact name, as long as there are at least two contacts in the array • output the whole of the array • delete the contents of the array. You must use pseudocode or program code and add comments to explain how your code works. You do not need to declare any arrays, variables or constants; you may assume that this has already been done. All inputs and outputs must contain suitable messages. You do not need to initialise the data in the array Contacts[] and the variable CurrentSize
8. Programming  →  8.2. Arrays
8. Programming  →  8.1. Programming concepts
Open