Unit 2 Rev
Unit 2 Rev
Unit 2 Rev
1. Tick one box in each row to identify if the statement is about validation , verification or both.
2. The table AUDIOPARTS stores the part number, description, cost and quantity in stock of the items
sold by a music shop.
............................................................................................................................................. [1]
Page |1
Remedial computer science grade 10 10/12/21
(b) Identify the field that is most suitable to be a primary key and give a reason for your choice.
Fieldname .................................................................................................................................
Reason .....................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................[2]
(c) Write a SQL script to show the items where the quantity in stock is fewer than 10. Show all the fields
from the database table in descending order of cost.
(d) Write a SQL script to count the number of items where the quantity in stock is greater than 10.
(e) Write a SQL script to calculate the total cost of items where the quantity in stock is greater than 10
but less than 50.
i) PartNum ……………………..
(g) State an appropriate validation check that can be used for each field:
i) PartNum ……………………..
3. Parity checks are often used to check for errors that may occur during data transmission.
Tick ( ✓) to show whether the following three bytes have been transmitted correctly or incorrectly.
Page |2
Remedial computer science grade 10 10/12/21
(b) A parity byte is used to identify which bit has been transmitted incorrectly in a block of data.
The word “F L O W C H A R T” was transmitted using nine bytes of data (one byte per character). A
tenth byte, the parity byte, was also transmitted.
The following block of data shows all ten bytes received after transmission. The system uses even parity
and column 1 is the parity bit.
(ii) Explain how you arrived at your answer for part (b)(i).
.............................................................................................................................. .............
.............................................................................................................................. .............
.............................................................................................................................. .............
.............................................................................................................................. .........[2]
.............................................................................................................................. .....................
.............................................................................................................................. .................[1]
(d) A parity check may not identify that a bit has been transmitted incorrectly.
.............................................................................................................................. .....................
.............................................................................................................................. .....................
.............................................................................................................................. .................[1]
Page |3
Remedial computer science grade 10 10/12/21
A 7-digit number has an extra digit on the right, called the check digit.
• the remainder gives the check digit (if the remainder = 10, the check digit is X)
(a) Calculate the check digit for the following number. Show all your working.
4 2 4 1 5 0 8 …
.............................................................................................................................. .....................
.............................................................................................................................. .....................
.............................................................................................................................. .....................
3 2 4 0 0 4 5 X
Circle below correct if the check digit is correct OR incorrect if the check digit is incorrect.
correct incorrect
.............................................................................................................................. .....................
.............................................................................................................................. .....................
.............................................................................................................................. .....................
.............................................................................................................................. .....................[3]
(c) Explain, using example, 4 types of errors that can be identified using Check digits.
.............................................................................................................................. .....................
.............................................................................................................................. .....................
.............................................................................................................................. .....................
.............................................................................................................................. .....................[4]
Page |4
Remedial computer science grade 10 10/12/21
5. Four 7-bit binary values are transmitted from one computer to another. A parity bit was added to
each binary value creating 8-bit binary values. All the binary values have been transmitted correctly.
(a) Tick (✓) to show whether an Even or an Odd parity check has been used for each binary value.
i. Describe how a checksum can be used to check that the data has been transmitted correctly.
ii. Describe how Echo check can be used to check that the data has been transmitted correctly.
iii. Describe how ARQ can be used to check that the data has been transmitted correctly.
5. A) Five statements about serial half-duplex data transmission are shown in the table below.
Tick (3) to show whether each statement is true or false.
(B) When data are transmitted from one device to another, a parity check is often carried out on
each byte of data. The parity bit is often the leftmost bit in the byte.
(i) If a system uses even parity, give the parity bit for each of the following bytes:
Page |5