9618/13 · May/June 2026
Download PDFValidation and verification can be used to protect the integrity of data. Complete the description of methods of ensuring data integrity by writing the missing terms. ................................................................................. is a method of verification where the data is entered by a user and then manually compared to the original data to make sure that they are the same. A verification method used during data transfer calculates a value from the data which is transferred with the data. The receiver performs the same calculation and compares the result with the value transferred. This method of verification is ................................................................................. . There are several methods of data validation. ................................................................................. check compares the data entered to a list of possible values that can be entered. If the data is not one of these values it is rejected. ................................................................................. check can be used to make sure data entered has the correct combination of letters, numbers and symbols. For example, a code may need to be two capital letters, one number followed by one symbol. ................................................................................. check is used to make sure the correct quantity of characters has been entered. For example, a name must be more than one character and less than or equal to 100 characters.
Complete the truth table for the given logic circuit.
State two logic gates that are not in the circuit in 2(a).
An animation is a sequence of bitmap images with a sound recording played at the same time.
The sound is recorded with a sampling resolution of 2 bytes. State what is meant by a sampling resolution of 2 bytes.
Explain how the data for the bitmapped images are encoded.
The bitmap images have a bit depth of 2 bytes. Each image is 2048 pixels wide by 1536 pixels high. One second of video contains eight individual bitmap images. There is no sound recording in this part of the video. Calculate an estimate for the file size of one second of the video in mebibytes (MiB). Show all of your working.
The sound and images are compressed independently before being transmitted over the internet to public cloud storage. Explain the different ways that lossless compression can be used to compress the images and the sound file.
State what is meant by a public cloud.
Give two benefits to the animation creator of using public cloud storage for the animation.
A database needs designing for a school library. The library stores data about books including the author, title, category and number of pages. The library will also store data about the students and the books they have borrowed. The data needs to include the student’s name and student’s class. Books are borrowed for 14 days. A book is late if it has not been returned within the 14 days. The database needs to store whether the book is late, or not late.
Create a 3-table design for the library database normalised to Third Normal Form (3NF). Give your table design in the format: TableName(Field1, Field2, Field3, …) A primary key is underlined with a solid line. A foreign key is underlined with a broken line.
Explain the reasons why the library database should enforce referential integrity.
The school is also creating a database to store data about the departments, the staff and classes in the school. The database is called SCHOOLDATA. The database has four tables: STAFF(StaffID, FirstName, FamilyName, DepartmentID) DEPARTMENT(DepartmentID, DepartmentName, DepartmentLeader) CLASS(ClassID, YearGroup, SubjectCode) SUBJECT(SubjectCode, SubjectName, DepartmentID) The table shows some sample data for SUBJECT. SubjectCode | SubjectName | DepartmentID CS1 | Computer Science IGCSE | ITCS CS2 | Computer Science IAS-level | ITCS MA3 | Mathematics IGCSE | MTS ME4 | Media IGCSE | ITCS The Structured Query Language (SQL) scripts to create the database and the table SUBJECT are shown. 01 CREATE DATA BASE SCHOOLDATA; 02 CREATE TABLE SUBJECT( 03 SubjectCode VARCHAR NONULL, 04 SubjectName VARCHAR 05 DepartmentID VARCHAR, 06 PRIMARY KEY (SubjectCode), 07 FOREIGN KEY (DepartmentID) REFERENCES (DepartmentID) 08 ); The SQL scripts contain four errors. Give the line number of each error and the corrected line.
Write an SQL script to return each department’s name and the number of subject codes for that department. The result needs to include a suitable field name for the number of subject codes. Order the results in ascending order of department name.
A student uses a laptop for school work. The laptop contains system software including an Operating System (OS) and utility software.
Hardware management is one key management task that the OS performs. Identify two tasks the OS performs as part of hardware management.
Identify two other key management tasks that the OS performs.
A disk formatter is an example of utility software. State the purpose of utility software in a computer.
Describe the purpose of a disk formatter.
The student is writing a computer program in a high-level language. The student imports routines from program libraries into their program. Define the term program library.
Describe one benefit of the student using a Dynamic Link Library (DLL) instead of a non-Dynamic Link Library.
Draw one or more lines to match each denary number with its equivalent unsigned binary, hexadecimal or Binary Coded Decimal (BCD) value(s).
Complete the binary addition. Show all of your working. 110101001111 +111111001111
Convert the two’s complement integer 011010110001 into denary.
Tick (✓) one box to identify the smallest integer that can be represented by a 16-bit two’s complement integer.
A program is written in assembly language.
Complete the table by writing the name of each mode of addressing.
Explain how bit manipulation can be used to monitor or control a device.
Identify one similarity and one difference between a right logical shift and a right arithmetic shift.
A computer is used to record sound.
The computer has Programmable Read Only Memory (PROM). Complete the table by naming and describing two other types of ROM.
The sound is recorded using a microphone. Describe the principal operation of a microphone.
The computer outputs the sound through external speakers. The computer transfers the data to a buffer before the speakers output the sound. Describe the purpose of the buffer.