UNIVERSITY EXAMINATIONS: 2019/ 2020
EXAMINATION FOR THE DEGREE OF BACHELOR OF SCIENCE IN
INFORMATION TECHNOLOGY/ BUSINESS INFORMATION
TECHNOLOGY/ APPLIED COMPUTING/ SOFTWARE DEVELOPMENT/
INFORMATION SECURITY & FORENSCIS
BIT 1207A BBIT 205 BAC 1207 BSD 1205 BISF 1207 – PRINCIPLES OF
DATABASE SYSTEMS
FULL TIME/PART TIME/DISTANCE LEARNIG
DATE: MAY, 2020 TIME: 6 HOURS
INSTRUCTIONS: Answer Question One & ANY OTHER TWO questions.
SECTION B
QUESTION 1 (20 MARKS)
KCA University has just employed you as a Database Administrator. There are some departments which
has some computers and others use manual way of storing data. You first assignment is to setup a
programme on how KCA University will have a DBMS in next six months. Give an outline of at least 5
steps necessary, giving details for each step to achieve this task.
(20 Marks)
SECTION C
QUESTION 2 (20 MARKS)
There are several tools used for coming up with a DBMS in any organization.
a) Identity any Two possible methods for your organization (4 Marks)
b) Discuss similarities in both methods (8 Marks)
c) Discuss dissimilarities in both methods (8 Marks)
