cameroon gce advanced level June 2025 ICT 3
cameroon gce advanced level June 2025 ICT 3
TASK A: DATABASE (20 MARKS)
A student is presented with the flat–file containing meeting details as displayed below. It contains a summary of
the financial situation of mates from a quarter meeting in Bamenda who have moved to different towns in
Cameroon.
The activities of this meeting are shown in Table 1 below.
Table I: Financial Transactions
| MID MNamc Amount TType | MAdd | TID ODate 001 11/10/2022 |
||
| M10 Mbong 5000 LOS Lyonga 10000 |
Saving | Buca | ||
| Loan | Bamenda 003 08/09/2022 | |||
| M10 Mbong | 12000 | Loan | Buca | 010 15/07/2022 |
| 020 Otia | 2500 | Loan | Wum | 013 23/10/2022 |
015 Omar 6000 Saving Garoua 005 30/07/2022
L05 Lyonga 5000 Loan refund Bamenda 004 15/07/2022
S04 Susan 7500 Saving Douala 008 23/10/2022
020 Otia 3000 Saving Wum 006 31/05/2022
L12 Linus 15000 Loan refund Bertoua 002 12/09/2022
Gil Getrude 4500 Saving Yaounde 007 08/09/2022
30/07/2C
M10 Mbong 2500 Loan Buea 011 —
12/09/20
T07 Tita 6500 Saving Maroua 012 –2
MID = Member ID, MAdd = Member Address, TType= Transaction Type,1ID = Transaction ID,
ODate = Operation Date.
The student decided to normalise the flat file into three (3) relations namely:
Meniber( M\D, MName, MAdd)
Transaction(J\D,TType, Amount)
Opercition( M\D,TID, ODate)
1. From the table structures above, develop the Member table in the space below. (3 marks)
State the key for each of 3
^tables (2 marks)
fable
| Member | Primary key/Compositc key |
| Transaction |
Operation
4. State the appropriate data type of MID and ODate.
MID
ODate:
3 CS *^defined r‘ate c*atahase above. management Populate all system the tables , create taking a database data fromcalled TableFinanceDB 1 above. containing
– R Diagram for the database in the space below. Indicate the cardinalities in the diagram.
(2 marks)
(2 marks)
(3 marks)
Implement the relationship in the database created.
Create a query to display members who have taken loans. Your query should include the amount
loaned and the date loaned. Save the query as LoanF.
Print the Operation table and the LoanF query only.
7.
(4 marks)
TASK B: SPREADSHEET (17 MARKS‘!
This task is based on raw data found in a workbook named TriftJLoan in your candidate folder. The workbook
contains two sheets namely ACTIVITIES: and STATS. The workbook is designed to manage the finances of a
savings and loans meeting that runs for a period of 12 months. At the end of the 12 months period the interest on
loans is calculated using the formula Simple Interest=Principal amount *Rate*Time and the savings is paid back
to the members together with some interest.
Open the workbook and answer the questions below:
Do the following activities in the ACTIVITIES sheet,
Enter a formula in cell F2 to calculate the total savings for Mbong. Copy the formula to get the total savings of
other members. Write down the formula used in call F5.
I .
F5: (2 marks)
When members take loans, their interest per month is calculated depending on the status of the member. Category
1 (Catl ) members pay an interest rate of 1.5% on the loan taken, while Category 2 (Cat2) members pay 2.5%.
Enter a formula in cell G12, to determine the interest on the loan taken by Mbong at the end of the 12 month
period. Also compute the interest on loan for all the other members. Write down the formula used in cell G12.
2.
(3 marks)
At the end of the session, a compensation of 1% of your total savings is given to you as interest. Enter a formula
to calculate the compensation for Mbong in cell H2 and also do similarly for other members.
Write down your formula for cell H10.
G12:
3.
(2 marks)
Enter a formula in cell 12, to determine the amount owed by Mbong. Copy the formula to calculate the
debt of all the other members. Write down the formula used in cell 16.
4.
(2 marks)
