Computer Studies Paper 3, May/June 2015

Question 1

  1.  Using a database application program, create a database called SUPERMARKET.
  2.  Create a table called Beverages with the following data:
  3. Product Name           Product ID     Quantity Per Unit                  Unit Price (N)
    Tea                              1                      20 bags per box                       120.00
    Chocomilo                   2                      100 cubes per pack                  300.00
    Chocolate drink          39                    750ml per bottle                      370.00
    Decaf Coffee              38                    75g per bottle                          263.00
    Ovaltine                      43                    500g per tin                             346.00
    Nescafe                       76                    30g per tin                               230.00

  4. (i)         Create a report as shown below:
  5. Product Name

     

    Product ID

     

    Quantity per Unit

     

    Unit Price (N)

     Tea                             1                      20 bags per box                       120.00
    Chocomilo                   2                      100 cubes per pack                  300.00
    Chocolate drink          39                    750ml per bottle                      370.00
    Decaf Coffee              38                    75g per bottle                          263.00
    Ovaltine                      43                    500g per tin                             346.00
    Nescafe                       76                    30g per tin                               230.00

    (ii)        Use your full name and index number as the footer in the report.

  6. Save your work on a suitable storage media. Print out the hard copy of your report and submit.
  7. On your print out, use ink to list the types of data in the record.

 

Observation

The expected answers were:
(a)        Creating a database called SUPERMARKET.                                                         

(b)        Creating a table called Beverages.                                                                             

(c)        (i)         Creating a report for Beverages.                                                        

            (ii)        Inserting candidate’s full name and index number                                       

(d)       Printing of report.                                                                                                      

(e)        Listing of the types of data in the record on your print-out.                                     
            -           Text
-           Number

The candidates were required to use a database program to answer the question. A number of candidates were able to input data correctly but majority of the candidates used wrong application to answer the question. Only a few candidates attempted the question correctly.