UNIVERSITY EXAMINATIONS: 2019/2020
EXAMINATION FOR THE DIPLOMA IN BUSINESS INFORMATION
TECHNOLOGY
DBIT 301: DATABASE MANAGEMENT SYSTEM
DATE: MAY, 2020 TIME: 6 HOURS
INSTRUCTIONS: Answer ALL Questions
SECTION B: 20 MARKS
QUESTION ONE
The KCA University student hostel placement Office receives many applications from new and
continuing students requesting for an apartment accommodation on campus. The campus
housing apartments are located in five different locations and each apartment has about 250
accommodation rooms. Each apartment falls into one of the apartment categories. An apartment
category is determined based on the location and the available services such as availability of hot
water services, in-built furniture etc.
For effective service delivery, the hostel placement Housing Office keeps information about the
students that have applied for in-campus housing facilities, but have not been assigned to an
apartment yet. However, KCA University does not allow a KCA student to book more than one
apartment and at any given time, an accommodation room can only accommodate one student.
Required:
1. Using the information provided in the scenario above, develop a conceptual ER model
using Peter Chen notations for the KCA University Housing Office database. State any
assumptions you need to make in order to develop a compete diagram. [8 Marks]
2. Critically evaluate the strengths and weaknesses of adopting the KCA University students
hostel placement system [6 Marks]
3. Discuss six security threats to the University students hostel placement system and for
each discussed security risk, propose effective security counter measure [6 Marks]
SECTION C: 20 MARKS
QUESTION ONE
A. A database is said to be efficient, if it performs operations in an unambiguous way.
Database operations can be performed efficient by normalizing the database. Normalizing
a database means that, the tables in a database are organized in a well-structured manner
that reduces the generation of redundant data as well as ensure that data dependencies
make sense.
Required: In reference to the above statement, using a computerized online exam student
registration system as an example, discuss three major database anomalies DBA need to
address while designing and implementing database systems [10 Marks]
B. KCA University wants to implement a computerized database system for tracking all books in the
library.
Required:
(i) Explain four benefits KCA University may derive from implementing the computerized
database system [8 Marks]
(ii) Discus two disadvantages of using the database system at KCA university [2 Marks]