cameroon gce advanced level June 2026 ICT 3
cameroon gce advanced level June 2026 ICT 3
Here is the extracted and structured content from the second exam paper image:
TASK A: DATABASES (28 Marks)
This task is based on three tables containing data of Cameroon Development Cooperation (CDC).
The tables are contained in a database named Personnel stored in your candidate folder.
Carefully study the database tables below and perform the tasks as instructed.
-
Employee(StaffNo, Surname, First_Name, Department, Age, Absence) -
Emp_Salary(Staff_No, Dept_ID, Salary) -
Department(Dept_ID, Department)
Open the database named Personnel from your Candidate Folder and carefully study the database objects and contents.
1. Determine the following table elements after normalization.
-
Primary keys: ______________________________________________________________________________
-
Foreign key: _______________________________________________________________________________
-
Composite keys: ____________________________________________________________________________
-
Table containing composite keys: _____________________________________ (4 marks)
2. Complete the table below
| Employees table | Emp_Salary table | Department table | |
| Number of records | |||
| Number of attributes | |||
| Number of key fields | |||
| Number of fields |
(4 marks)
-
3. Study the structure of the three tables and implement the keys identified above. (2 marks)
-
4. Create a relationship between the three tables.
-
Take a screen capture of the active relationship window.
-
Open the Word document My Screen shots in your candidate folder and paste your screen capture. (3 marks)
-
-
5. Open the table Emp_Salary in design view and make the following changes.
-
a) Add caption to the
Dept_IDfield to read Dept_Ref. (2 marks) -
b) Format the
Salaryfield to currency and select the currency Euro. (2 marks) -
c) Add a Validation text to read, “Salaries cannot be less than 200000 or more than 500000.” (1 mark)
-
Take a screen capture of the field properties of Salary in the
Emp_Salarytable while in the design view and paste in the My Screen Shots Word document. -
Save the changes made.
-
Switch to Datasheet view and Print a copy of Emp_Salary table.
