UNIVERSITY EXAMINATIONS: 2018/2019
EXAMINATION FOR THE DIPLOMA IN INFORMATION TECHNOLOGY
DIT306 PRINCIPALS OF DATABASE DESIGN
FULLTIME/PARTTIME
DATE: NOVEMBER, 2018 TIME: 2 HOURS
INSTRUCTIONS: Answer Question One and Any other Two.
QUESTION ONE
a)
(i) Discuss database issues (4Marks)
(ii) Define the following terms as used in databases Systems (4 Marks)
a) Databases.
b) views
c) Database Management Systems.
d) Schema.
e) Primary Key
b) Discuss the limitations of having a database system to manage organizational data. (6Marks)
c) With the use of a diagram, explain the layers of a three level Architecture (6 Marks)
d) Design an ERD depicting the following entities. Assign appropriate primary and foreign keys;
STUDENT (Name, Course, ID number, telephone number)
COURSE (Name, Capacity, Fees, Duration).
REGISTRATION (Date). (8 Marks)
QUESTION TWO (20 MARKS)
a) With the use of a diagram, explain the components of Database Management System (6 Marks)
b) Describe the term “Cardinality”. (2 Marks)
c) Describe the following data models by giving each its advantages and Disadvantages. (6 Marks)
a) Hierarchical Model
b) Relational Model
c) Network Model
d) State and discuss the controlled access to database views (3 Marks)
e) Define file based systems. What are the limitations of these systems? (3 Marks)
QUESTION THREE (20 MARKS)
a) Differentiate between logical data independence and Physical Data independence. (2 Marks)
b) State the Importance of Program Documentation (2 Marks)
c) Explain any three factors you would consider while designing and implementing a computerized
database system that will be used in banking sector. (6 Marks)
d) Explain the term “Normalization”as used in Databases systems. (2 Marks)
e) List and explain three objectives of database Normalization. (6 Marks )
f) State and Explain any TWO advantages of a client Server (2 Marks)
QUESTION FOUR (20 MARKS)
a) Describe database methodology process. (10 Marks)
b) Explain the following operators as used in RDMS. (5 Marks)
i. Null
ii. SELECT
iii. PROJECT
iv. JOIN
c) Explain any TWO Security threats of a database system. (2 Marks)
d) Stare and explain any three SQL statements (3 Marks)
QUESTION FIVE (20 MARKS)
a) Explain the functions of the following DBMS Kernel (4Marks)
i. DML Pre-Compiler.
ii. Database Manager.
iii. Data Files.
iv. Data Dictionary.
b) Discuss any four types of a database Manager (4 Marks)
c) What are the functions of Database Management Systems (5 Marks)
e) What are the properties of a relation? (4 Marks )
f) Explain any three Anomalies. (3 Marks)
