0478_w24_qp_21
A paper of Computer Science, 0478
Questions:
11
Year:
2024
Paper:
2
Variant:
1
Login to start this paper & get access to powerful tools
6
An incomplete algorithm has been written in pseudocode to count the number of zeros stored in an array and total the non-zero values. 01 DECLARE A[1:50] : INTEGER 02 DECLARE C : INTEGER 03 DECLARE I : INTEGER 04 DECLARE T : INTEGER 05 I ← 0 07 FOR C ← 1 TO 50 08 IF A[C] 09 THEN 10 T ← T + 1 11 ELSE 12 I ← I + A[C] 13 ENDIF Complete the given pseudocode algorithm. Write the pseudocode to display, with suitable messages, the number of zeros stored in the array and the total of the non-zero values. Meaningful identifiers have not been used in the algorithm. Suggest suitable meaningful identifiers for: The array: A The variables: T C I
8. Programming  →  8.1. Programming concepts
8. Programming  →  8.2. Arrays
Open
8
A programmer is designing a program to check the length of a password and to check if the password input is the same as the stored password. The program requirements are: • input the password, Password • check if there are at least 8 characters in the password • check that the password is not the same as the stored password OldPass • output ‘accepted’ if both tests are completed successfully • otherwise, output ‘rejected’. Use the variable names given. Complete the flowchart for the program. START STOP The accepted password, Password, is to be written to the file MyPassword.txt Write pseudocode to: • open the file • write the accepted password to the file • close the file. Explain why the accepted password needs to be stored in a file.
7. Algorithm design and problem-solving  →  7. Algorithm design and problem-solving
8. Programming  →  8.1. Programming concepts
8. Programming  →  8.3. File handling
Open
9
An algorithm has been written in pseudocode to check if a temperature is in a given range. The temperature values used in the algorithm are correct. 01 REPEAT 02 OUTPUT "Please enter temperature " 03 INPUT Temp 04 IF Temperature = 999 05 THEN 06 IF Temperature > 38.0 07 THEN 08 OUTPUT "Temperature too high" 09 ENDIF 10 IF Temperature = 35.0 OR Temperature Correction Error 2 line number Correction Error 3 line number Correction Error 4 line number Correction Identify the temperature range used. Complete the trace table for the corrected algorithm using this data: 34.22, 36.1, 37.4, 38.0, 999, –1 Temperature OUTPUT
7. Algorithm design and problem-solving  →  7. Algorithm design and problem-solving
8. Programming  →  8.1. Programming concepts
Open
10
A shop that sells cheese has set up a new database table called CheeseStock to store details of the cheeses available for sale. Part of this table is given. ChNo Name InStock SupplierCode PricePerKg WeightKg CH01 American Yes XYZ 4.50 20.0 CH02 Brie Yes XYZ 7.50 21.0 CH03 Burrata No IMP 13.75 0.0 CH04 Camembert No ABC 16.85 0.0 CH05 Cheddar Yes ABC 5.00 50.0 CH06 Comté No SPC 7.35 0.0 CH07 Cottage Yes XYZ 4.50 3.0 CH08 Cream Yes XYZ 5.50 6.5 CH12 Emmental Yes IMP 2.75 1.5 CH15 Feta Yes IMP 12.75 12.0 CH16 Fontina Yes SPC 15.99 1.2 CH17 Gorgonzola Yes SPC 15.25 0.3 CH19 Gouda Yes SPC 7.99 2.5 CH21 Gruyère No SPC 16.75 0.0 CH22 Halloumi Yes IMP 4.75 15.0 CH23 Havarti No SPC 6.75 0.0 CH27 Manchego No IMP 13.99 0.0 CH30 Manouri No IMP 18.50 0.0 CH31 Mascarpone No SPC 12.99 0.0 State the number of records in this part of the database table. Give the name of the field that would be used for the primary key. State the reason for choosing this field for the primary key. Write the output from this structured query language (SQL) statement. SELECT ChNo, WeightKg FROM CheeseStock WHERE SupplierCode = 'ABC'; Complete this SQL statement to display only the name of all the cheeses that are out of stock. SELECT FROM WHERE ; Explain how one of the lines in your statement in part could be changed to display the same information.
9. Databases  →  9. Databases
Open
11
A running club has 200 members who compete in a 1-kilometre running competition every month. Members’ names are stored in the one-dimensional (1D) array MemberName[] Each member’s time, in seconds, for the 1-kilometre run will be stored in another one-dimensional (1D) array MemberTime[] The position of each member’s data in the two arrays is the same. For example, the member stored at index 10 in MemberName[] and at index 10 in MemberTime[] is the same. The running club awards a small prize to the members who have the top three times. The club also awards certificates to all members with a time under 240 seconds. Write a program that meets the following requirements: • allows members’ times to be input twice and verifies that the inputs match • sorts the arrays MemberTime[] and MemberName[] in ascending order of time • outputs the member names and times of the members with the top three times and identifies them as First, Second and Third • stores the names of all the members who will receive a certificate in the array MemberCertificate[] • outputs a message stating the number of certificates to be printed. You must use pseudocode or program code and add comments to explain how your code works. You do not need to initialise the data in the array MemberName[] You do not need to declare any arrays or variables; you may assume that this has already been done. All inputs and outputs must contain suitable messages.
7. Algorithm design and problem-solving  →  7. Algorithm design and problem-solving
8. Programming  →  8.1. Programming concepts
Open