DIT 205 – PRINCIPLES OF DATABASE DESIGN KCA Past Paper

UNIVERSITY EXAMINATIONS: 2020/2021
EXAMINATION FOR THE DIPLOMA IN INFORMATION
TECHNOLOGY
DIT 205: PRINCIPLES OF DATABASE DESIGN
DATE: NOVEMBER, 2021 TIME: 2 HOURS
Instructions: Answer Question ONE (COMPULSARY) and ANY other TWO questions.

QUESTION ONE [20 MARKS]
a) List any four factors a database designer should consider when selecting a DBMS system
in your organization. [4 Marks]
b) Wanguru Company Limited intends to introduce a new computerized system in order the
management of its employee’s records. Outline FOUR good features you would want to
see in the implemented Wanguru database system. [4 Marks]
c) KCA University uses the Database approach instead of a manual systems approach for keeping
records. Explain any four disadvantages of using manual database approach. [4 Marks]
d) Discuss FOUR components of a database management system (DBMS). [4 Marks]
e) Explain FOUR classifications of relationships based on Degree. [4Marks]
QUESTION TWO [15 MARKS]
a) Describe the following attributes and give an example in each case:
i. Derived Attribute
ii. Key Attribute
iii. Composite Attribute
iv. Single-Valued Attribute
v. Optional Attribute [5 Marks]
b) List three types of users associated with the database implementation [3 Marks]
c) Describe the following classes of database integrity and explain how they are enforced.
i). Entity integrity
ii). Referential integrity
iii). User defined Integrity [3 Marks]
d) Write a simple SQL statement that can be used to insert students details into the database
[4 Marks]
QUESTION THREE [15 MARKS]
The report below shows information about DreamHome rental details.

a) Normalize the report above to third normal form. [10 Marks]
b) State and explain three types of anomalies found in a database table. [5 Marks]
QUESTION FOUR (15 MARKS)
a) Define the following terms as used in database design and development and give one
example in each case.
i. Entity [2 Marks]
ii. Database Management System [2 Marks]
iii. Strong Entity [2 Marks]
iv. Weak Entity [2 Marks]
b) Design a Hierarchical Database Model based on the data below [5 Marks]

c) Identify and explain THREE factors to consider when selecting a DBMS system.
[2 Marks]

(Visited 222 times, 1 visits today)
Share this:

Written by