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

(i) State the name of this protocol.   HTTPS 

(ii) Identify how this protocol changes the data to transmit the data securely.

• It encrypts it
• It applies encryption algorithm
• It applies an encryption key

(i) Unexpectedly halts the program. Run time (execution)

(ii) The program produces the wrong output.  Logical
 (b) Another error can result from incorrectly using the rules or grammar of the programming language.

(i) Name this error. Syntax

(ii) State when this error is detected.

Syntax error is detected during translation into executable code / attempted to run but fails

• Simple technology is needed to develop both hardware and software.
• Digital devices are more reliable, small in size and use less power as compared to analog devices.
• Devices that read, process or output data in digital form are used in computers and other digital devices such as calculators.

• It dictates the speed at which data is transferred between these components and enables the sequential execution of instructions in the correct order.
• generates a timing signal that is used to synchronize communication between CPU components and the rest  of the computer system

• Fibre optic cable would be used because it has a higher bandwidth, allowing faster communication in the main part of the network. It is also more secure as it cannot be tapped.
• Firewalls filter the data in and out of a network. Each packet is examined against the filter rules and if a packet is flagged, it is dropped. Only data packets that satisfy the filter rules are allowed through the firewall, thus providing a layer of security for the network.
• A satellite system would be better as it does not rely on wifi, cellular etc. It is not subject to interference and is reliable in remote conditions
• Radio-frequency identification (RFID) uses electromagnetic fields to automatically identify and track tags attached to objects. An RFID system consists of a tiny radio transponder, a radio receiver and transmitter. When triggered by an electromagnetic interrogation pulse from a nearby RFID reader device, the tag transmits digital data, usually an identifying inventory number, back to the reader. This number can be used to track inventory goods..

Advantages

• on-line catalogues can be viewed
• much larger choice of products
• product reviews obtainable before purchase
• orders placed over internet any time day or night
• download software purchased straight away
• good and services usually cheaper on the internet
• programs that can search for best price/cheapest
• very fast placing an order has been placed as customer name, address
• and credit card details are stored so no need to re enter
• buy goods from anywhere in the world
• no need to go to shop/save travelling time

Disadvantages

• spam
• need a credit card to shop on-line/not everyone has a credit card
• hackers could retrieve credit card numbers and use them to buy goods
• security fears - of giving credit card number over the internet/fraud
• goods must be delivered/can not have the goods immediately
• can not touch/handle/see the goods

• Authenticity
• Users' needs
• Availability of documentation
• Cost
• Compatibility
• Upgradability
• Portability

• It is an address to a resource on the internet

(a)State what is meant by the terms:

Parallel data transmission

• 8 bits/1 byte/multiple bits sent at a time  
• using many/multiple/8 wires/lines

Serial data transmission

• one bit sent at a time over a single wire

• Distributed data processing is where computers located in physically separate location transmit data after processing to a server computer that updates the master file. Time-sharing on the other hand is where various terminals transmit data to be processed by a central computer's CPU. Each terminal's tasks are allocated a time slice of the CPU

1. Virus scanning / Anti-virus. Used to locate and delete viruses / scans and compares files with databases of known viruses.
2. Firewall: checks data packets / examines source address / filters out unexpected packets.
3. Back up. Copies data onto a separate storage device for use if the original data is lost or corrupted.

• Users need to ensure that their software is licensed

A manager wishes to replace the current manual system with a computerized one. Describe three areas that must be evaluated to justify the replacement  (6 marks)

• Technical feasibility

• Does the current technology suffice

• Economic feasibility

• Benefits outweigh costs/ whether the project is cost effective

• Schedule feasibility

• Can it be done within the schedule

Headache, back and neck pain may result from the use of computers. State how each of them can be minimized (2mks)

• Proper lighting
• Regular breaks
• Use of antiglare
• Correct position of the screen
• Ergonomic furniture

Students of a school intended to elect their school Captain by secret ballot.  State three ways in which computers can be used to improve the election process                           (3mks)

• Registrations of voters
• Voter identification
• Actual voting
• Tallying

• 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

• it has a header that contains the destination address, the packet number, and the originator’s address
• it has a payload
• it has a trailer.

Dual input of data

• Two inputs are compared by the system and any discrepancies are reported (and not stored.)
• Data input once, either printed out or checked on the screen and  errors corrected

 Rules are given to the processor

• Only accept A, B, C, D, E, F, G i.e Any other input rejected.

Drop-down list/radio buttons

• Provides only valid inputs, so no other validation is required

• Serial is the transmission of data one bit at a time/through one wire
• Parallel is the transmission of data more than one bit at a time/many wires
• Simplex is the transmission of data in one direction only
• Duplex is the transmission of data in both directions simultaneously

• It ensures that each row has a unique and non-null primary key