COMPUTER STUDIES (Practical)

FORM THREE- TERM THREE

Time 2 ½ HOURS

Name: …………………………………………………......…… AdmNo: ……….……

School: …………………………………………………………... Class: …………………

Candidate’s Signature: …….………...................................... Date: …...…………….

INSTRUCTIONS TO CANDIDATES
• Indicate your name, admission number and stream at the top right of each printout.
• Write your name and admission number on the CD-R OR CD-RW
• Write the name and version of the software used for each question attempted in the answer sheet.
• Passwords should not be used while saving in the storage medium.
• Answer all the questions.
• All questions carry equal marks
• All answers must be saved in your storage medium
• Make a printout of the answers on the answer sheets provided.
• Hand all the printouts and the storage medium.
QUESTIO MAXIMUM SCORE SCORE
N

ONE 50

TWO 50

TOTAL 100

Candidates should check the question paper to ascertain that all pages are printed as indicated
and no questions is missing.

Page 1 of 4
 1. KwetuMotors is a company that sale motor vehicles to its customers all over the country. Create a
database named KwetuMotors with the following three tables: (10 marks)
Stock Table Sales Details Table Customer Details Table
V_IC Cd InvoiceNo ID No
Model Description VehicleId CustomerName
CountryOfManufacture SaleDate DateOfBirth
YearOfManufacture Customer TelephoneNo
Cost
Quantity
(a) For each of the tables above set appropriate primary keys as well as data types (5 marks)
(b) create the relationship among the tables and enforce referential integrity. (3 marks)
(c) Create Model Form, Sales Form and Customer Form to be used to enter data in the three
Tables (3 marks)
(d) Set a validation rule and appropriate validation text for the quantity field so that it only
accepts values between 0 and 10 (2 marks)
(e) Use the three forms created in (c) above to enter the data below in the respective tables
(10 marks)

Stock Table

V_Id ModelDescription Country Year Cost Quantity

M001 Alfa-Romeo German 2000 1,350,000 2
M100 Ferrari England 1990 1,950,000 1
M110 Aston Martin German 2010 2,200,000 3
M223 Jaguar Japan 1980 2,100,000 1
M202 Cardilac German 1990 2,000,000 2

Customer Table

ID Number Name DateOfBirth Telephone

112211 Peter James 10/02/2000 0711889922
221133 Christine Nyakawera 04/05/2001 0111887766
331122 Emily Contesh 12/24/1980 0223344556
443321 Peterson Williams 03/13/1979 0334455668
212380 Millicent Wainex 02/15/1982 0504679922

Sales Table

Invoice No VehicleID SaleDate Customer

INV01 M202 12/23/2022 212380
INV03 M110 03/06/2023 221133
INV02 M001 02/05/2023 112211
INV05 M223 04/20/2023 443321
INV04 M100 12/24/2022 331122

Page 2 of 4
 (f) Create a query named GHighClass to give V_Id, Description, Customer Name and
SaleDate for vehicles manufactured in German and costing more than 1,500,000 (4 marks)
(g) Create a query named Quarter_1 to give the V_Id, Customer Name, Customer and Year of
Sale for all the vehicles sold in the year 2023 (4 marks)

(h) Create a report named Sales_Report to give the V_Id, Description, Sale amount and
customer name. The report should display the total sales amount (4 marks)
(i) Print the following:

Stock, Customer and Sales tables (3 mark)

GHighClass query (1 mark)
Sales_Report (1 mark)

2. a) Using a word processing software type the following document as it appears and save it as
DBMS (31 marks)

DATABASE MANAGEMENT SYSTEM

W
What is a database management system?
hen you use word processing software, you develop a document. When you use
spreadsheet software, you develop a workbook or spreadsheet. When you use personal
information management software, you develop a phone book or appointment
calendar. The same is true in a database environment-you use software to develop a
database. A DBMS is the software you use to specify the logical organization for a database and access it.

A DBMS contains five important software components

 DBMS engine
 Data definition subsystem
 Data manipulation subsystem
 Application generation subsystem
 Data administration subsystem

The DBMS engine allows you work with database from a logical point of view, without worrying about
physical and technical details. It accesses the database and data dictionary on the storage device.
The data definition subsystem helps to create and maintain data dictionary and file structure.
The data manipulation subsystem helps you add, change and delete information in the database.
The application generation subsystem facilities include tools for creating data entry screens, programming
languages, and interfaces to programming languages used.

Page 3 of 4
The data administration subsystem is used by database administrator for backup and recovery, security
management, queries and maintenance of the database.
Below is an example of a flat file that can be better presented using a DBMS:

D I G I TA L C O M P U T E R S P E C I F I C AT I O N S
S/No. RAM (MB) Hard Disk Processor Monitor Type Cost
SPEED TYPE
1 128 20 GB 2.4 GHz INTEL CRT 35,000
2 256 40 GB 2.8 GHz CERELON TFT 50,000
3 1024 80 GB 3.0 GHz INTEL TFT 60,000
TOTAL 1408

b) Double underline the title and change the line colour to red (2 marks)
c) Set the distance of the drop cap from the text to 0.1 cm (1 mark)
d) Set the character spacing for the table title to 150%, expanded by 5 points (3 marks)
e) Use a formula to calculate and format the total cost as shown (2 marks)
f) Format the third paragraph starting with the words “The DBMS engine allows…..” to two
columns with a line in between the columns (2 marks)
g) Set the top and bottom margins to 1.3 cm, the left and right margins to 1.27cm (2 marks)
h) Insert a footnote to define the initials DBMS (2 marks)
i) Space the whole document to 1.5 line spacing (2 marks)
j) Create a footer and a header with your name and admission number respectively (2 marks)
k) Print the document (1 mark)

Page 4 of 4