0478/21 · Oct/Nov 2024
Download PDFFour operators and three types of operator are shown. Draw one or more lines from each operator to its correct operator type. Operator >= AND DIV + Operator type Boolean Arithmetic Logical
Identify three stages of the program development life cycle from the following list of words. analysis decomposition design input pseudocode testing variable 1 ........................................................................... 2 ........................................................................... 3 ...........................................................................
Describe three methods that are used to design and construct a solution to a problem. Method 1 .......................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... Method 2 .......................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... Method 3 .......................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... ..........................................................................................................................................................
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 06 ........................................................................................................ 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 14 ........................................................................................................
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 ................................................................................................................................................
Consider the logic circuit:
Write a logic expression for the given logic circuit. Do not attempt to simplify the logic expression. W = ...........................................................................................................................................
Complete the truth table from the given logic circuit.
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.
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.
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 11 THEN 12 OUTPUT "Temperature too low" 13 ENDIF 14 IF Temperature >= 35.0 OR Temperature <= 38.0 15 THEN 16 OUTPUT "Temperature normal" 17 ENDIF 18 ENDIF 19 WHILE Temperature = 999
Identify the line numbers of four errors in the pseudocode and suggest a correction for each error. Error 1 line number ................................................................................................................... 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
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 (d)(i) could be changed to display the same information.
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.