• Access Controls: Authentication of users in order to access files
• Performing regular patches of updates
• creating secure accounts with required privileges
• scrutinizes all incoming and outgoing packets of data through a firewall
• encryption of data, during transmission
• Log files to detect any breach

download speed :
– speed at which information/data is transferred FROM server/Internet
– speed at which information/data is transferred TO the user’s computer
upload speed :
– speed at which information/data is transferred FROM user’s computer
– speed at which information/data is transferred TO the Internet/server

• less errors on input
• requires less storage space
• validation
• quicker to input
• quicker to find

• hexadecimal is easier (for humans) to read (than binary);
• numbers are displayed in a more compact way (in hexadecimal than in binary);
• it is quicker to type in (hexadecimal numbers than binary numbers);
• it reduces the risk of typing errors (in hexadecimal numbers than binary numbers);

– software that can be used to design new products/amend existing products
– makes use of features such as 2D, 3D, wire frames, library of parts, links to CAM

Give three different applications that make use of CAD.

– aerospace
– architecture
– designing cars
– designing consumer goods
– chemical/nuclear plant design
– designing electronic circuit boards
– ergonomic design
– landscape/garden design

Name three specialist input/output devices used in CAD.

– large monitor/screen with hi-res
– touch screen
– plotter
– space mouse/space ball/4D device
– 3D glasses (in some applications)
– light pen
– graphics tablet
– 3D printer
– 3D scanner

One to one  - Each record in the parent table has exactly one related record in the child table, and vice versa.

One to Many -  Each record in the parent table can have multiple related records in the child table, but each record in the child table is related to only one record in the parent table

Acme company needs to ensure that if they are reselling the drives they wipe the drive (this should be done regardless of the destruction of the drive) to the DoD standard.

• Disassemble the drive by pulling it apart the drive so that the data would not be accessed
• Destroy the metal disk either by drilling holes so it cannot be read
•  Encrypt drives with passwords that are not accessible
• Degaussing the hard drives
• Use specialized overwriting software

This would ensure that any software cannot be used to locate files.

• A barcode is one-dimensional while a QR code is two dimensional
• Barcodes are a set of vertical lines and QR code contains squares
• QR codes can be read from any angle . Barcode is only above or below and lined up horizontally

Parallel

• sending data from a computer to a printer
•  internal data transfer (buses)

Serial

• connect a computer to a modem

(i) Incorrect use of language, e.g. PLINT instead of PRINT
(ii) A mistake in the structure of the solution, e.g. a jump goes to the wrong line
(iii) Inappropriate arithmetic is used, e.g. division by 0 is attempted

• They are small and fit in a small storage space
• They are portable hence can be carried when need to be used outside the office
• Low power consumption
• Have rechargeable batteries

• By use of an ergonomic keyboard
• She should take regular breaks from her computer and stretch her joints
• She should use standard furniture with an upright backrest to reduce strain on the back

• It transfers data signals from one node directly to another in the network without broadcasting

Advantages

• It is quicker to type commands
• Little memory needed
• Little processing power needed

Disadvantages

• Commands have to be typed precisely
• There is a large number of commands to be learnt
• It is not user friendly
• The user has to remember commands
• Users cannot transfer data between applications

Trojan (horse); a program which misleads the user into thinking it is another

piece of software which, when run, executes another program;

Spyware; a program which records data such as usernames and passwords on

a host system and forwards the information to a third party;

Adware; code embedded or attached to program files which will persistently

show adverts (that attempt to generate revenue);

Worm; code which will run autonomously and replicates itself on a host system;

Ransomware; a program that encrypts user’s data to make it unreadable until

they pay for the key;

Remote Access Tool (RAT); allows access to control and monitor a computer

from a remote network location;

Rootkit; malware that has managed to gain ‘root’ admin privileges;

Bots/Zombies; a program installed on a computer that performs a job for the

remote owner of the bot/zombie such as sending spam or sending web requests

to perform a DOS or attacking a computer system;

Scareware; malware that tells you something is wrong with your system in an

attempt to get you to make a purchase;

Keylogger; a program that monitors/records a user’s keystrokes in order to steal

passwords/confidential details;

Benefits

• The user is not restricted to the predetermined options//the GUI uses icons and set menus
• The user has more control over the computer settings//in GUI computer settings are protected from the user
• Uses less memory than GUI
• Requires less processing power for the interface
• More processing power is made available for the task

Drawbacks

• The commands used have to be learnt
• The commands used have to be remembered
• The commands used have to be typed in/entered exactly
• Have to remember the exact path/correct name of application
• More prone to errors on data entry Commands have to be typed in//in a GUI can use touchscreens/mice
• Tends to be used by specialist people//GUI is more user-friendly and can be used by non-experts

device: beeper/loud speaker
use: to indicate barcode correctly read/error in reading barcode
device: (LCD) screen/monitor
use: to show prices and other information about goods
device: touch screen
use: to show prices and other information about goods/to select items that need to be
weighed/identified
device: weighing machine
use: to find weight of loose items (e.g. fruit) to enable pricing
device: (magnetic) card reader/CHIP and PIN reader
use: to read customer’s debit/credit card/enable customer to pay for goods using a
credit or debit card
device: printer
use: to print receipts

17. a) i) Explain the term search as used in the Internet.                                            [2]

A web based application that locates items or information from the World Wide Web

ii) Peter intends to download a movie from the Internet. State the three factors that may determine the total time taken to complete the download.                                           [3]

• Size of the video/format
• The bandwidth of the media/speed of network/network traffic
• Type of browser software
• Background activities running in the computer
• Restrictions enforced in the computer/firewall/antivirus
• Speed of the computer/CPU speed
• Size of RAM

b) Wakulima online is an organization that runs a web based system for assisting farmers to obtain market for their produce. State four technological reasons that may cause a farmer not to access the organization’s system.                                                                                  [4]

• Poor network/lack of connection
• Software failure in the system

• Hardware failure
• Lack of access rights
• System overload/hanging
• Lack of skills/disability/illiteracy
• Lack of power supply

c) Explain a situation when each of the following Desktop Publishing program features may be used when creating a publication:

i. Cropping                                                                                                               [2]

Applies to graphics – used to trim/remove/hide some portions in the graphics

ii. Transparency                                                                                                         [2]

Used to make background of a graphic to be clear/visible

d. List two areas where infrared waves are used in data communication.                             [2]

18. a) List four activities of the planning stage of systems development.                             Ignore this question, marks redistributed elsewhere

b) Explain a circumstance when each of the following feasibility studies are carried out during systems development.

i. Technical                                                                                                               [3]

Done to determine whether technology exists to support the proposed solution

ii. Economic                                                                                                              [3]

Done to determine whether the proposed solution is economically viable

iii. Schedule                                                                                                               [3]

Done to determine whether the proposed system can be done within an acceptable time.

c) Table 1 and Table 2 are related tables in a database. Use them to answer the questions that follow.

Table 1

Table 2

i. Identify the appropriate primary key for each table.                    [2]

Table 1 – Dept code, Student Registration No

ii. Explain two benefits of enforcing referential integrity in the database. [4]

• No record can be added in Table 2 if its corresponding record in Table 1 does not exist
• No record in Table 1 can be deleted without first deleting the corresponding record in Table 2
• Reduces data redundancies/ensures integrity
• Prevents deletion of related table

19. a) Describe each of the following validation checks as used in data processing.

i. Preserve check                                                                                                      [2]

Ignore this question, marks redistributed elsewhere

ii. Data type check                                                                                                    [2]

Ensure correct type of data is entered for the field

iii. Check digit                                                                                                           [2]

This is a number added/calculated by the computer to a binary number. The check digit ensures correct transmission of the binary number.

b. Write each of the following abbreviations in full:

i) BCD                                                                                                                                    [1½]

Binary Coded Decimal

ii) EBCD                                                                                                                                 [

This question was thrown out and marks redistributed elsewhere

iii) ASCII                                                                                                                    [1½]

American Standard Code for Information Interchange

c) Using 10-bits binary number system, perform the following decimal operation using two’s complement.                                                                                                                                   [6]

12910 - 12810

+129 = 00 1000 0001

128 = 00 1000 0000

-128 = 11 0111 1111 (ones complement)

                            +1

          11 1000 0000 (Twos complement)

129- 128

     00 1000 0001

+ 11 1000 0000

 100 0000 0001

Hence = 00 0000 00012 or 12 (the overflow bit is ignored)

give uninterrupted path through the system of linked traffic lights/
green link - wave
turn all lights to red
activate emergency generator
alarm