UNIVERSITY EXAMINATIONS: 2015/2016
EXAMINATION FOR THE DIPLOMA IN BUSINESS/ INFORMATION
TECHNOLOGY
DBIT301 DATABASE MANAGEMENT SYSTEM
DATE: AUGUST 2016 TIME: 1½HOURS
INSTRUCTIONS: Answer Any THREE Questions.
QUESTION ONE
a) Define the following terms as used in database design and development.
i). Data [1 Mark]
ii). Database management systems [1 Mark]
iii). Information [1Mark]
iv). Primary Key [1 Mark]
b) Describe any THREE attributes for each of the following entities below and choose one of
your attributes as the identifier for the entities:
i. Customer
ii. Student [6 Marks]
c) Describe any FIVE Disadvantages of file based systems [5 Marks]
d) Highlight any THREE components of a database environment. [3 Marks]
e) Explain any TWO security threats of a database system. [2 Marks]
QUESTION TWO
a) Using examples in each case, explain any five types of attributes as used in database systems.
[10 marks]
b) Discuss the implementation of distributed databases system in our society today.
[5 marks]
2
c) List the FIVE advantages of a distributed database system as implemented above.
[5 Marks]
QUESTION THREE
a) Describe FOUR examples of a database management system (DBMS). [4 Marks]
b) Using a hierarchical database model, design the following scenario. [6 Marks]
c) Define the following as used in Object oriented database model
i. A class
ii. Object
iii. Behavior [6 Marks]
d) List down any FOUR types of entities as used in Conceptual design of a database system
[4 Marks]
QUESTION FOUR
a) Define the term Relationship as used in relational databases. [2 Marks]
b) State and explain THREE classifications of relationships [3 Marks]
c) Explain FOUR classifications of relationships based on Degree. [4 Marks]
d) Write SQL statements on how you would create the following: [4 Marks]
i) Database Tables include: SUPPLIER AND PRODUCT [6 Marks]
e) Define the term Link as used in relationship database models. [1 Mark]
f) State and explain any Three SQL statements showing syntax in each [6 Marks]
QUESTION FIVE
a) Define the following as used in Normalization
i. Functional dependency
ii. Partial Functional Dependency
iii. Transitive Functional Dependency
iv. Normalization [8 Marks]
b) Explain any three reasons why a database designer should could consider normalization
before creating a database. [2 Marks]
c) Differentiate between Mandatory and Optionality. [2 Marks]
d) List down the FOUR types of ERD Notations. [4 Marks]
e) Explain any three types of normalization forms [2 Marks]
f) Give any two access methods in a database system [2 Marks]
