UNIVERSITY EXAMINATIONS: 2013/2014
ORDINARY EXAMINATION FOR THE DIPLOMA IN
INFORMATION TECHNOLOGY
DIT 205 PRINCIPLES OF DATABASE DESIGN
DATE: AUGUST, 2014 TIME: 1½HOURS
INSTRUCTIONS: Answer Any Three Questions.
QUESTION ONE
a) Define the following terms as used in database design and development and give one
example in each case.
i). Entity [1 Mark]
ii). Database management systems [1 Mark]
iii). Strong Entity [1 Mark]
iv). Weak Entity [1 Mark]
b) Hazina Sacco uses the manual filing system approach instead of a database approach.
List any six limitations that come with Manual filing systems. [6 Marks]
c) Describe any TWOadvantages of Database approach [5Marks]
d) Highlight anyTHREE components of a database environment. [3 Marks]
e) Design a hierarchical database using the information below. [2 Marks]
QUESTION TWO
a) Describe the THREE levels of database architecture. [6 Marks]
b) Use the information below to answer the questions below.
Each DOCTOR must treat one or more PATIENTS. Each patient must be treated by a
doctor. Each PATIENT may take one or more MEDICATIONS. Each
MEDICATION is given to one PATIENT
i). Identify the entities in this case. [4 Marks]
ii). Represent the above information using IDEFIX and REIN85 ERD notations.
[10 Marks]
QUESTION THREE
a) Define the term Database design as used in database system [1 Mark]
b) Explain FOUR classifications of relationships based on Degree. [4 Marks]
c) Differentiate between the following as used in classification of relationships
i) Mandatory and Optionality
ii) Key attribute and Non-Key attribute
[4 Marks]
d) Identify FOUR main Factors considered when selecting the DBMS [4 Marks]
e) Write SQL statements on how you would create the following database [4 Marks]
i) Database name: SALES
ii) Database Tables include: SUPPLIER AND PRODUCT
f) Give any THREE examples of DBMS used in Databases. [3 Marks]
QUESTION FOUR
a) Explain the following Testing techniques [6 Marks]
i) Black Box Testing
ii) White Box Testing
iii) Acceptance Testing
b) Describe the process of software and hardware acquisition during database
implementation. [4 Marks]
c) State and explain any FIVE database security threats. [5 Marks]
d) For the above threats explain FIVE possible counter measure [5 Marks]
QUESTION FIVE
a) Define the following as used in Normalization
i. Functional dependency
ii. Partial Functional Dependency
iii. Transitive Functional Dependency
iv. Normalization
[4 Marks]
b) Identify THREE database anomalies [3 Marks]
c) Explain any three reasons why a database designer should could consider
normalization before creating a database. [3 Marks]
d) Normalize the following Report to Third Normal Form [10 Marks]
