PAN AFRICA CHRISTIAN UNIVERSITY
EXAMINATIONS PAPER
PAN AFRICA CHRISTIAN UNIVERSITY
BACHELOR OF BUSINESS INFORMATION TECHNOLOGY AND
BACHELOR OF SCIENCE IN INFORMATION TECHNOLOGY
END OF SEMESTER EXAMINATION
DEPARTMENT: COMPUTING AND INFORMATION TECHNOLOGY
COURSE CODE: BIT106/BCIT106
COURSE TITLE: DATABASE SYSTEMS
CAMPUS: ROYSAMBU
EXAM DATE: THURSDAY,XXXX,APRIL,2023
TIME: 8:00AM -11:00AM
INSTRUCTIONS
This exam script has TWO (2) sections.
Read all questions carefully before attempting.
Answer All questions in Section A and any other Three questions in
Section B.
Write only your student number on the answer booklet provided.
Page 1 of 7 © Copyright 2023 All Rights Reserved PAC University
, PAN AFRICA CHRISTIAN UNIVERSITY
EXAMINATIONS PAPER
SECTION A
(Answer ALL questions in this section)
Question 1:
a) Eldo-Systec Co Ltd has been registering huge losses due to inefficiencies
associated with its manual database systems. The company has decided to
computerize its database system in order to improve its service delivery.
Assuming that you have been hired to set up the new database solution,
advise the company about:
i. Two criteria that should be used in selecting the most suitable database
management system for the company. [2 Marks]
ii. Two approaches that should be used to secure database management
systems on the web.
[2 Marks]
b) Use the table below to answer the questions that follow.
StaffID F. Departme Salary
Name nt
001 Peter ICT 35,000
002 Mary Leadership 50,000
003 Abraha ICT 44,000
m
Staff table
Write SQL expression to:
i. Display Staffid, FName and department of all staff who earn salary above
40,000.
[2
Marks]
Page 2 of 7 © Copyright 2023 All Rights Reserved PAC University
EXAMINATIONS PAPER
PAN AFRICA CHRISTIAN UNIVERSITY
BACHELOR OF BUSINESS INFORMATION TECHNOLOGY AND
BACHELOR OF SCIENCE IN INFORMATION TECHNOLOGY
END OF SEMESTER EXAMINATION
DEPARTMENT: COMPUTING AND INFORMATION TECHNOLOGY
COURSE CODE: BIT106/BCIT106
COURSE TITLE: DATABASE SYSTEMS
CAMPUS: ROYSAMBU
EXAM DATE: THURSDAY,XXXX,APRIL,2023
TIME: 8:00AM -11:00AM
INSTRUCTIONS
This exam script has TWO (2) sections.
Read all questions carefully before attempting.
Answer All questions in Section A and any other Three questions in
Section B.
Write only your student number on the answer booklet provided.
Page 1 of 7 © Copyright 2023 All Rights Reserved PAC University
, PAN AFRICA CHRISTIAN UNIVERSITY
EXAMINATIONS PAPER
SECTION A
(Answer ALL questions in this section)
Question 1:
a) Eldo-Systec Co Ltd has been registering huge losses due to inefficiencies
associated with its manual database systems. The company has decided to
computerize its database system in order to improve its service delivery.
Assuming that you have been hired to set up the new database solution,
advise the company about:
i. Two criteria that should be used in selecting the most suitable database
management system for the company. [2 Marks]
ii. Two approaches that should be used to secure database management
systems on the web.
[2 Marks]
b) Use the table below to answer the questions that follow.
StaffID F. Departme Salary
Name nt
001 Peter ICT 35,000
002 Mary Leadership 50,000
003 Abraha ICT 44,000
m
Staff table
Write SQL expression to:
i. Display Staffid, FName and department of all staff who earn salary above
40,000.
[2
Marks]
Page 2 of 7 © Copyright 2023 All Rights Reserved PAC University
