KCSE Computer Studies Paper 2 and 3: Questions and Answers
1. (a) Create a database called SCHOOL. (2 Marks) (b) Create three tables Examination, DOS and BOARDING with the fields as shown below. (10 Marks) (c). Create a relationship between the three tables and enforce integrity. (6 Marks) (d). Enter the data items in the given tables three tables. (15 Marks)
(e) Design a query that would display the following fields as shown below and write down the formulae for getting the total score and criteria for extracting the records below (10 Marks)
(f) Design a report that would sort the following in ascending order in the order of the following fields, Total score, KCPE Score, SName the Admission Number and the report should display all the fields. Save the report as administration (5 Marks) (g) Print, administration and admin (2Marks)
0 Comments
|
We Would Love to Have You Visit Soon! |
Hours24 HR Service
|
Telephone0728 450425
|
|
8-4-4 materialsLevels
Subjects
|
cbc materialsE.C.D.E
Lower Primary
Upper Primary
Lower Secondary
Upper Secondary
|
teacher support
Other Blogs
|