Dit 205 Principles Of Database Design Question Paper
Dit 205 Principles Of Database Design
Course:Diploma In Information Technology
Institution: Kca University question papers
Exam Year:2014
UNIVERSITY EXAMINATIONS: 2013/2014
ORDINARY EXAMINATION FOR THE DIPLOMA IN
INFORMATION TECHNOLOGY
DIT 205 PRINCIPLES OF DATABASE DESIGN
DATE: AUGUST, 2014
TIME: 11/2HOURS
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]
Parent record
Child record
John Mutua
Harison James
Hannah Mutuku
John Mutua
KAX 456Y Toyota, KAX 457Q
Nissan
Harison James KAW 400T Toyota
Hannah Mutuku KBG 789P Toyota,
KBG 789P Toyota Kshs 500000
1
KAW 400T
Kshs 500000
Toyota
KAX 456Y Toyota Kshs 600000
KAX 457Q Nissan Kshs 700000
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
i) Black Box Testing
ii) White Box Testing
iii) Acceptance Testing
2
[6 Marks]
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]
Report
A report
Page
DreamHome
Customer Rental Details
1
Customer Number:
Property Property
Number Address
PG4 Box 123 NRB
PG16
Date:
Customer Name
CU034
John Mwendwa
Rent start Rent finish Rent 1-02-2010 1-02-2012 120000 CO123 Mary mutia
BOX 12 THIKA 02-02-2009 0 2-02-2013 200000 C096 Mariana Ouma
Un-normalized table
3
Owner
Number
19-02-2013
Owner Name
More Question Papers
Exams With Marking Schemes