Question 1
- Using a database application program, create a database called SUPERMARKET.
- Create a table called Beverages with the following data:
- (i) Create a report as shown below:
- Save your work on a suitable storage media. Print out the hard copy of your report and submit.
- On your print out, use ink to list the types of data in the record.
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
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.
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.