• Two entities that are related require that a foreign key must have a matching primary key

(ii) Entity integrity

• Entity integrity specifies that the Primary Keys on every instance of an entity must be kept, must be unique and must have values other than NULL

(b) Describe how data integrity can improve the process of database management. (2 marks)

• Data integrity is the maintenance of, and the assurance of, data accuracy and consistency over its entire life-cycle and is a critical aspect to the design, implementation, and usage of any system that stores, processes, or retrieves data
• The overall intent of any data integrity technique is the same: ensure data is recorded exactly as intended (such as a database correctly rejecting mutually exclusive possibilities)

Uses – Any of the following:
• Game playing (chess, quiz, video games)
• Analytics (analyse buying patterns, predicting behaviours, predictive
text, financial markets)
• Image processing (recognising objects/patterns)
• Logistics (scheduling, order fulfilment)
• Control systems (cars, manufacturing, weapons, navigation)
• Expert systems (medical, mechanical, electrical diagnosis)
• Neural networks (simulating neuron behaviours as in brains)
• Natural languages processing (chatterbots, chatbots, speech
recognition)
• Robotics (dangerous situations, help aged or disabled)

Ethical issues – Any of the following:
• Take the work of humans, thereby affecting employment rates
• Is a computer to be trusted to make decisions (life-death)?

• If a computer discovers something that humans can’t prove, should it be
accepted as truth?
• Do AI machines have rights?
• Will people be comfortable interacting with machines that are
considered intelligent?

•  A graphical object on a computer screen that responds to move movement and allows the computer user to select and execute commands in graphical user interface operating systems

(b) Desktop

• It Is a special folder in the file system that is displayed when no other windows are open

1.What is meant by

    a)Analogue data

     b)Digital data                           (4 mks)

2. Distinguish between transcription and transposition types of errors and give an example of each  (4mks)

3. a)What are peripheral devices?  (1mk)

   b)Give two examples of peripheral devices  (1mk)

4a)What meant by the term user-friendly as used in software development? (1mk)

  b)Distinguish between the terms single-tasking and multi-user as used in operating systems  (2mks)

5.What actions should be taken in case of a fire outbreak in the computer laboratory?  (4mks)

6a) What is an Internet Service Provider?    (1mk)

  b) An employee in a business company is charged with the responsibility of putting the company advertisements on the Internet.

 i) State the professional title of the employee. (1mk)

ii) Give an example of software used by this employee to carry out the above task.    (1mk)

7.Differentiate between COM ports and LPT ports     (2mks)

8.Explain two ways in which ICT can enhance commerce.  (2mks)

9. Explain the following software terms:

    a) Portability       (1 mk)

    b) Modularity      (1 mk)

10. a) State two application areas of desktop publishing software. (2mks)

     b) Explain the following graphic terms:                                                                                     

     i) Rotate (1 mk)

    ii) Crop  (1mk)

12. a)List two arithmetic operations that can be performed on a row of numeric data in a word processing table.    (1 mk)

     b) In each case of (a) above, write the expression used.  (2mks)

13. List two methods of gathering information during the system development process   (2mks)

14.Name three types of optical disks.(3mks)

15.The diagram below shows a formatted plate surface of a storage disk.

            Shade and label:

            a)         one sector                                                                                ( 1mk)

            b)         One block                                                                                (1mk)

SECTION B (60 MKS)

Answer question 16 and any other three questions from this section in the  space provided

16 a) List two examples of:

       i) Third generation languages    (2mks)

       ii) Object oriented languages    (2 mks)

b) Draw a flowchart to compare three non-equal numeric values A, B, C and prints the largest of the three. (11 mks)

17 a) One of the functions of an operating system is job scheduling.  Explain what is meant by job scheduling.   (1mk)

    b)List and explain three types of user interfaces.                      (6 mks)

    c)Describe the following categories of software:

       i) Firmware                 (1mk)

       ii) Proprietary software  (1mk)

     d) a new company XYZ intends to go into the business of desktop publishing. Advise the company on three computer hardware system specification features to consider as a measure of enhancing performance. (6 mks)

18. a) distinguish between the following sets of terms as used in spreadsheets.        (2mks)

     i)Worksheet and workbook

     ii) Filtering and sorting

     b) State one way in which a user may reverse the last action taken in a spreadsheet package.        (1 mk)

     c)The following is a sample of a payroll. The worksheet row and column headings are marked  1, 2, 3, .  and A, B, C.  respectively