Scribd
Upload
279 views5 pages

Level 6 Database Systems Cat 1

Assessment tool

Uploaded by

ketyangsan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
279 views5 pages

Level 6 Database Systems Cat 1

Assessment tool

Uploaded by

ketyangsan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 5

061006T4ICT

ICT TECHNICIAN LEVEL 6


IT/OS/ICT/CR/7/6
MANAGE DATABASE SYSTEMS
Sept. /Oct. 2024
Time: 3 Hours

TVET CURRICULUM DEVELOPMENT, ASSESSMENT AND CERTIFICATION


COUNCIL (TVET CDACC)

WRITTEN
ASSESSMENT
TIME: 3 HOURS
CANDIDATE INSTRUCTIONS

1. This paper has two sections A and B. Attempt questions in each


section as per instructions given in the section.
2. You are provided with a separate answer booklet.
3. Marks for each question are indicated in the brackets.
4. Do not write on the question paper

This paper consists of SIX (6) printed pages


Candidates should check the question paper to ascertain that all
pages are printed as indicated and that no questions are missing
Turn over
SECTION A (40 Marks)

Answer ALL questions in this section.

1.Describe each of the following components of a database


i. Stored procedures (2 Marks)
Are instructions and rules that help to design the database and to use the DBMS, users that operate and
manage the DBMS requires the procedures on how to use and run the DBMS.
ii. Tables (2Marks)
These are database objects used to store data in form of fields and record where fields represent the
columns and records are rows.
iii. Triggers (2 Marks)
A procedure that is automatically invoked by the DBMS in response to specified changes to the database
and it’s typically specified by the Database Administrator.
2. State the three levels of data abstraction in Database Management Systems. (3 Marks)
i. Physical Level/internal view: - is the lowest level that describes how the data are actually stored.
ii. Logical/Conceptual view:- Describes what data are stored in a database and what relationships exists
among those data.
iii. View Level/External view:- Describes only part of the entire database, exists to simplify the users
interaction with the database.
3. Describe three keys that can be used in database. (6 Marks)
i. Primary Key:- A field that is used to uniquely identify records in a database table.
ii. Foreign Key:- A primary key that appears as a filed in another different table, used create
relationship between tables.
iii. Candidate Key/Superkey:-
4. Explain two types of Data Independence in databases. (4 Marks)
i. Physical Data independence:- allows modification of the storage devices, file structure, location and
database without changing the definition of the conceptual view.
ii. Logical data indepence:- used to change the logic behind the logical level without affection the other
layers of the database.
5. Differentiate between active and passive data dictionaries (2 marks)
Active data dictionary is automatically updated by the dbms with every database access thereby keeping
its access information up to date whereas Passive data dictionary is not updated automatically and
usually requires a batch process to be run.
6. Explain two reasons for performing database testing. (3 Marks)

7. Mary developed a database for a company. Outline the four key stages she could have
followed when testing this database. (4 Marks)

8. Mike designed a database using an Entity Relationship Diagram (ERD). Using symbols,
describe three connotations of ERD he could use. (6 Marks)

9. There are four most basic operations in database which are the backbone for interacting
with database. State two of these database operations. (2 Marks)
10. SQL commands are often categorized based on the type of operation they perform within a
database. Outline the FOUR types of these commands. (4 Marks)

IT/OS/ICT/CR/7/6 Page 2 of 3
Sept/Oct 2024
SECTION B (60 MARKS)
Answer any THREE questions from this section.

11. Codd introduced the concept of normalization and what is now known as 1NF in
1970, He went on to define 2NF and 3NF in 1971
i. Define Normalization as used in database. (2 Marks)
ii. Explain FOUR benefits an organization would gain by normalizing its database.
(8 Marks)
iii. 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

Normalize the table above to;


1NF (3 Marks)
2NF (3 Marks)
3NF (4 Marks)
12. a) Explain six characteristics of Database Management System. (12 Marks)
b) A company has installed a database system for its operations. Explain four benefits
accrued from its use. (8 Marks)
13. a) Data Definition Language is used to bring objects into existence. Discuss five database
objects. (10 Marks)
b) Discuss five types of database security. (10 Marks)
14.a) Highlight four factors considered when choosing the type of database software to adopt.
(4 Marks)
b) The ACID properties of data transactions provide a mechanism to ensure the
correctness and consistency of data in a database. Explain each of these four properties.
(8 Marks)
c) Databases are designed based on various data models. Discuss four database models.
(8 Marks)

THIS IS THE LAST PRINTED PAGE.

Sept/Oct 2024
IT/OS/ICT/CR/7/6
Page 3 of 3

You might also like