-
The following car details are to be entered in a database: Make, Date-of-manufacture, colour, and cost.
a) Prepare a suitable database structure showing field names and their field data types
b) Explain how you index the data such that cars of the same make and colour are together.
c) Write a statement that can be used to select cars of colour green.
d) Give an instruction that would:
i) Select cars whose cost is between 500,000/= and 1,000,000/=
ii) Determine the average cost of all cars.
Date posted:
June 6, 2019
-
Differentiate between Fill and stroke
Date posted:
June 6, 2019
-
Differentiate between Change case and drop cap.
Date posted:
June 6, 2019
-
Differentiate between Margins and column guides.
Date posted:
June 6, 2019
-
Differentiate between pasteboard and printable page.
Date posted:
June 6, 2019
-
Why is layering very useful in a desktop publisher?
Date posted:
June 6, 2019
-
Name the two most common protocols for the Internet, and state their functions.
Date posted:
June 6, 2019
-
Mention two examples of email software.
Date posted:
June 6, 2019
-
Briefly describe four factors contributing to Internet access and growth in Kenya.
Date posted:
June 6, 2019
-
Differentiate between data security and data integrity.
Date posted:
June 6, 2019
-
Computer systems need maximum security to prevent an unauthorized access. State six precautions that you would expect an organization to take to prevent illegal access to its computer-based systems.
Date posted:
June 6, 2019
-
Give four rules that must be observed in order to keep within the law when working with data and information.
Date posted:
June 6, 2019
-
An individual has a right to demand guarantee to privacy of personal information stored on a computer. Give three such types of information.
Date posted:
June 6, 2019
-
Clearly differentiate between data collection and data capture.
Date posted:
June 6, 2019
-
Name the examples of industries and business organizations that extensively use distributed processing systems.
Date posted:
June 6, 2019
-
Explain the concept of multiprogramming
Date posted:
June 6, 2019
-
State at least four advantages of storing data in computer files over the manual filing system
Date posted:
June 6, 2019
-
In a computer based information system, state the purpose of the computer files, and give one example where such a file may be required in a school.
Date posted:
June 6, 2019
-
What are low-level languages? Give their features.
Date posted:
June 6, 2019
-
Examine two features of fourth generation languages (4GLS)
Date posted:
June 6, 2019
-
Describe 5 factors to be considered while choosing a programming language.
Date posted:
June 6, 2019
-
Explain Runtime (execution) error.
Date posted:
June 6, 2019
-
Explain Logical Errors.
Date posted:
June 6, 2019
-
Explain Syntax errors.
Date posted:
June 6, 2019
-
Draw a simple flowchart diagram to illustrate the FOR-DO structure.
Date posted:
June 6, 2019
-
The gross salary of employees of Mutson Chemist is based on the Basic and additional benefits. Employees with more than 10 year’s experience get an additional pay of 10% of their basic salary. Bonuses are given as per employees’ sales of the month as:
>200,000 15%
100,000 – 200,000 10%
Below 100,000 5%
Draw a flowchart for the program that will calculate Gross salary and output each employee’s Basic salary, gross salary and all benefits.
Date posted:
June 5, 2019
-
State one disadvantage of the Traditional approach in system development
Date posted:
June 5, 2019
-
You are required to develop a registration system for a particular school. State
two ways in which you would gather the information required for the system development.
Date posted:
June 5, 2019
-
Identify two disadvantages of Observation method used in fact-finding.
Date posted:
June 5, 2019
-
Explain the importance of using automated methods in fact finding.
Date posted:
June 5, 2019