UNIVERSITY EXAMINATIONS: 2015/2016
EXAMINATION FOR THE DIPLOMA IN INFORMATION
TECHNOLGY
DIT 205 PRINCIPALS OF DATABASE DESIGN
DATE: AUGUST 2016 TIME: 1
½HOURS
INSTRUCTIONS: Answer Any THREE Questions.
QUESTION ONE
a) Define database design and explain the importance of a Good Design [3 Marks ]
b) State and explain any FOUR advantages of DBMS [6 Marks]
c) Define the term Kernel [2 Marks]
d) Explain the following functions of the DBMS Kernel [4 Marks]
i. Catalog/ Data dictionary
ii. Indices
iii. DDL compiler
iv. DML Precompiled
e) Client Server manages user interface and runs applications. State any TWO
advantages of a client Server [2 Marks]
e) Define Views and state TWO benefits. [3 Marks]
QUESTION TWO
a) Some DBMS supplied with home PC office packages give everyone who opens
database unrestricted access. This is unacceptable in a business environment. Explain
how the Database Administrator (DBA) controls access to an organization’s database.
[4 Marks]
b) Differentiate the following terms [6 Marks]
i. Logical schema and Physical schema
ii. Database System and Database Management System
iii. Network Model and Hierarchical Model
c) Define the following terms as used in Relational Model [6 Marks]
i. Domain
ii. Degree
iii. Mapping cardinality
d) What are the properties of a relation [4 Marks]
QUESTION THREE
a) Explain the meaning of EACH of the following terms: [3 Marks]
i. Domain Integrity
ii. Composite Attribute
iii. Third Normal Form (3NF).
b) Define the following terms as used in data modeling [3 Marks]
i. A data model
ii. Logical models
iii. Conceptual models
c) Relational database Models is Perceived by user as a collection of tables for data
storage. Describe advantages of Relational Database Models [5 Marks]
d) Explain the following DDL Statement [3 Marks]
i. SELECT
ii. UPDATE
iii. DELETE
e) SQL stands for Structured Query Language. It is the most commonly used relational
database language today. Explain any THREE SQL functions [6 Marks]
QUESTION FOUR
a) Define a database development Methodology [10 Marks]
b) Define file based systems [2 Marks]
c) What are the Four Limitations of File Based Approach [4 Marks]
d) State any FOUR example of Database application [4 Marks]
QUESTION FIVE
a) Describe THREE advantages of the database approach to managing data for an
organization. [6 Marks]
b) State and explain any four countermeasures to database Threats [4 Marks]
c) SQL is a “non-procedural” language, meaning a program is not typically written in
“straight SQL”. SQL accomplishes many powerful tasks with a mere seven
statements: State and explain any three of the SQL statements. [6 Marks ]
d) Explain the following major CREATE statements [2 Marks]
i. CREATE SCHEMA
ii. CREATE VIEW
e) Differentiate between the following Relational Keys [2 Marks]
i. Candidate Key and Primary Key
