QUESTION 1

1. Table 1, table 2 and table 3 are extracts of records, kept in a carpentry shop. Use the information to answer the questions that follow;
   

   CAPENTER _ID	CAPENTER NAME		CUSTOMER _ID	CUSTOMER NAME
   CAP_001	JAMES		CUST_01	MARY K.
   CAP_002	JOHN		CUST_02	DIANA K.
   CAP_003	ALEX		CUST_03	ALEX N.
   CAP_004	ISAAC		CUST_04	MARTHA K.
   CAP_005	MAURICE		CUST_05	SARAH W.

   
   Order TableCarpenter Table                                                                 Customer Table
   
   

   CARPENTER _ID	CUSTOMER _ID	ORDER _NO	ITEM ORDERED	MONTH	AMOUNT
   CAP_001	CUST _01	1721	Bench	January	18,000
   CAP_002	CUST _02	1722	Coffee table	January	25,000
   CAP_003	CUST _03	1723	Office table	January	10,000
   CAP_004	CUST _04	1724	Single bed	January	18,000
   CAP_005	CUST _05	1725	Arm chair	January	60,000
   CAP_001	CUST _01	1726	Double bed	February	75,000
   CAP_002	CUST _04	1727	Dining table	February	85,000
   CAP_004	CUST _03	1728	Arm chair	February	60,000
   CAP_001	CUST _02	1729	Double decker bed	February	72,000
   CAP_002	CUST _06	1730	Kitchen table	February	82,000
   CAP_004	CUST _02	1731	Bench	March	18,000
   CAP_003	CUST _06	1732	bench	march	18,000

   (1mk)
   1.  
      1. Using database application package, create a database file named;
      2. Create three tables named Carpenter Table, Customer Table and Order Table that will be used to store the above data. (10mks)
      3. Set the primary key for the tables                                                                           (2mks)
      4. Create relationship among the tables (2mks)                                                         
   2.  
      1. Create a data entry form for each table (3mks)
      2. Enter the data in Carpenter Table, Customer Table and Order Table respectively  (11mks)
   3.  
      1. Create a query named individual income to display the amount received from each customer every month.    (4mks)
      2. Create a database object that computers Total income for each month. Save the query as (6mks)
   4. Create a query named loyalty to compute the total number of orders made by each customer over the three months.         (3mks)
   5. Create a report to display order details, save the report as Order report (4mks)
   6. Print the three tables and the report (4mks)

QUESTION 2
Use a spreadsheet to manipulate data in the table below.

1. Enter the data in all bordered worksheet and auto fit all column. Save the workbook asmark 1        (15mks)
2. Find the total marks for each subject             (3mks)
3. Find total for each subject per stream using a function             (5mks)
4. Find mean mark for each student using a function                                                 (5mks)
5. Rank mean student in descending order using the mean             (5mks)
6. Create a well labeled column chart on a different sheet to show the mean mark of every student. Save the workbook as mark 2.             (7mks)
7. Using mark1, use subtotals to find the average mark for each subject per stream. Save the workbook as mark 3 (7mks)
8. Print mark 1,mark 2 and the chart

MARKING SCHEME

QUESTION 1

QUESTION 2

Presence of workbook 1mks
Correctly saved (correct name) 1mks
10 records correctly entered (5) ½*10     5mks
Auto fit columns                    @1/2*10        5mks
Presence of borders                                                 3mks

1. Subject totals using a function/formula ½*5
2. Total marks per stream                ½ *10
3. Mean mark for each student       ½ *10
4. Ranking for every student           ½ *10
5. Presence of a column chart          1mks
   Correct content                                 1mks
   Labeling x-axis                                  1mks
   Y-axis                                                  1mks
   Legend                                               1mks
   Title                                                    1mks
   Different sheet                                  1mks
6. Sorting of records subtotals        5mks
7. Average using subtotals       Y_Z*10
8. Printing the three sheets