NIBS/RUIRU/EXAM/MOCK/F005
061006T4ICT
ICT TECHNICIAN LEVEL 6
IT/OS/ICT/CR/7/6
DEMONSTRATE DATABASE MANAGEMENT SYSTEMS
MARCH 2025
FORMATIVE ASSESSMENT 1. 2 …..3
TERM 3
TVET CURRICULUM DEVELOPMENT, ASSESSMENT AND CERTIFICATION COUNCIL
(TVET CDACC)
WRITTEN ASSESSMENT
TIME: 3HOURS
INSTRUCTIONS TO CANDIDATE
1. This paper has TWO sections: A and B.
2. Answer ALL questions in section A and THREE questions from section B.
3. You are provided with a separate answer booklet.
4. Marks for each question are as indicated.
5. Do not write on the question paper.
This paper consists of five (5) printed pages) with Thirteen (13)Questions).
Candidates should check the question paper to ascertain that all pages are printed as indicated and
that no questions are missing.
Turn Over
NIBS TECHNICAL COLLEGE. Page 1 of 5 REV:0
NIBS/RUIRU/EXAM/MOCK/F005
SECTION A: (40 MARKS)
Attempt ALL questions in this section.
1. Outline Four components of a database management system. (4 Marks)
2. State the meaning of functional dependence in database management system
(2 Marks)
3. Differentiate between tuple and relations as used in RDBMS (2 marks)
4. An organization intends to acquire a database application to manage its big
data. Describe two advantages of database approach. (4 Marks)
5. The principal from Kina institute noticed that there was a lot of data duplication
of student’s details within the system. Identify two issues that may arise as a
result of data duplication. (4 Marks)
6. Highlight four characteristics of a well-defined database system. (4 Marks)
7. Elucidate four merits of a distributed database (4 Marks)
8. Identify four disadvantages of file-based system (4 Marks)
9. A database table has the following attributes:
• Student_ID
• Name
• Course
• Phone Number
• Email Address
a) Identify the Primary Key and explain its role. (4 marks)
b) Explain what happens if duplicate values are entered in the Primary Key field. (4 marks)
c) Differentiate between a Primary Key and a Foreign Key using an example. (4 marks)
Turn Over
NIBS TECHNICAL COLLEGE. Page 2 of 5 REV:0
NIBS/RUIRU/EXAM/MOCK/F005
SECTION B: (60 MARKS)
Attempt any THREE (3) questions in this section
10.Maureen level 6 student in computer sciences was task role of designing a library
Management system. She decided to start with conceptual model.
a) With aid of diagram Explain five types of attributed as used in Entity
Relational Diagram(ERD) within database system in an organization.
(10 Marks)
b) Define database security and explain two ways to protect a database from
unauthorized access. (4 Marks)
c) Discuss three security measures that database administrators use to ensure
data confidentiality and integrity. (6 Marks)
11. Code introduced the concept of normalization and what is now known as 1NF in
1970, He went on to define 2NF and 3NF in 1971
a) Define Normalization as used in database. (2 Marks)
b) Explain FOUR benefits an organization would gain by normalizing its database.
(8 Marks)
c) The table below is in de-normalized form;
Students _table
Student name D.O.B Course title Grade
Radull Collins 12.4.1990 Maths,chemistry A,C
Murvin akon 3.3.2000 Economics A
Rashid kayler 14.12.1998 Maths , biology B,B
Vivian Lukas 25.12.2003 Chemistry, physics C,B
Tania james 7.11.1995 Biology A
Caleb moses 19.12.2002 Maths B
Fatuma mustafa 1.1.2001 Biology, chemistry B,A
NIBS TECHNICAL COLLEGE. Page 3 of 5 REV:0
NIBS/RUIRU/EXAM/MOCK/F005
Normalize the table above to;
i) 1NF (3 Marks)
ii) 2NF (3 Marks).
iii) 3NF (4 Marks)
12.Explain TWO benefits of PRIMARY KEY in a database management system.
(4 Marks)
a) Discuss THREE levels of database design. (6 Marks)
b) Transform the ER diagram into a relational schema. (10 Marks)
13.
a) ICT department has been proposing the use of Database Management System
within the organization. Explain FOUR factors that should be considered before
implementing the proposed system (8
Marks)
b) Describe the following functional dependencies
i) Partial dependency (3 Marks)
NIBS TECHNICAL COLLEGE. Page 4 of 5 REV:0
NIBS/RUIRU/EXAM/MOCK/F005
ii) Transitive dependency (3 Marks)
c) The table below shows an excerpt of employee details at Semaj Company. Use it
to answer the questions that follows.
Employee Employee Department Department Department
name
Number name no manager
C935 John simon 102 Finance Mr cleopas
C678 Frank Lukas 101 Human resource Dr. machoka
C654 Joan kirui 103 Accounts Dr. Samuel
C922 Flora atieno 102 Finance Mr. cleopas
C987 Denis keli 104 marketing Miss risper
Identify the scenarios in the table that may lead to occurrence of each of the following
anomalies:
i) Update anomalies (2 Marks)
ii) Deletion anomalies (2 Marks)
iii) Insertion anomalies (2 Marks)
NIBS TECHNICAL COLLEGE. Page 5 of 5 REV:0
