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)
all updates are provided in real-time. keep checking to get maximum benefits.