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
COMPUTER STUDIES PP2 QUESTION PAPER ON SPREADSHEETS AND DATABASE MODEL05122022003
COMPUTER STUDIES REVISION KITS 2022 TERM 2 PAPER 2 SPREADSHEETS AND DATABASE MODEL1709202200417/9/2022
|
Can't find what you are looking for? Don't worry, Use the Search Box Below.
Primary Resources
College Resources
|
Secondary Resources
|
Contact Us
Manyam Franchise
P.O Box 1189 - 40200 Kisii Tel: 0728 450 424 Tel: 0738 619 279 E-mail - sales@manyamfranchise.com |