UNIVERSITY EXAMINATIONS: 2013/2014
ORDINARY EXAMINATION FOR THE BACHELOR OF SCIENCE
IN INFORMATION TECHNOLOGY
BBIT 107 DATABASE MANAGEMENT SYSTEMS
(DISTANCE LEARNING)
DATE: APRIL, 2014 TIME: 2 HOURS
INSTRUCTIONS: Answer Question ONE and any other TWO
QUESTION ONE: [30 Marks]
a) Define the following terms as used in database design and development.
i). Database [1 Mark]
ii). Data management [1 Mark]
iii). Knowledge [1 Mark]
iv). Information [1 Mark]
b) Describe any THREE ways of classifying databases. [6 Marks]
c) Describe SIX functions of a database administrator. [6 Marks]
d) Discuss THREE applications of distributed databases. [3 Marks]
e) Discuss any TWO security threats of a database system. [4 Marks]
f) Discuss the components of database environment. [5 Marks]
g) Describe the term data definition language (DDL). [2Marks]
QUESTION TWO: [20 MARKS]
a) Discuss THREE advantages and THREE disadvantages of object oriented database
models. [6 Marks]
b) Using your knowledge on object oriented database models and the case below answer
the questions that follow.
In a truck management system, each truck is assigned a driver .Each truck is used to
carry cargo to different destinations. The cargo consists of assortment of items. A
driver can only drive one truck at a time.
i). Identify the objects in this case. [3 Marks]
ii). Identify three attributes for each object [3 Marks]
iii). For each object identify at least three operations [3 Marks]
iv). Draw an object diagram [5 Marks]
QUESTION THREE: [20 MARKS]
a) Describe FOUR functions of a database management system (DBMS). [4 Marks]
b) Describe the THREE levels of database architecture. [6 Marks]
c) Discuss THREE components of a database management system (DBMS). [6 Marks]
d) Explain FOUR factors considered when selecting database management system
(DBMS). [4 Marks]
QUESTION FOUR: [20 MARKS]
a) Discuss THREE functions of a database view. [3 Marks]
b) Given the following relations use appropriate SQL statements to:
i). Display mean age of all the employees [2 Marks]
ii). Display the employee(s) whose first name begins with F and age is not 29.
[4 Marks]
iii). Display employee details if they do not work in human resource department.
[3 Marks]
iv). Create a view named employee departments to display full name and department
name [4 Marks]
v). Insert a new record in the employee table. [4 Marks]
QUESTION FIVE: [20 Marks]
a) Define the term normalization with respect to logical design. [2 Marks]
b) Describe three anomalies that are associated with bad database design. [6 Marks]
c) Use the form below to normalize it to third normal form. [6 Marks]
d) Describe the following functional dependencies.
i). Transitive dependency [3 Marks]
ii). Partial dependency [3 Marks]