Get premium membership and access revision papers, questions with answers as well as video lessons.

Database Systems Question Paper

Database Systems

Course:Diploma In Information Technology

Institution: Bungoma Technical Training Institute question papers

Exam Year:2009

STAGE II EXAMINATION FOR DIPLOMA IN INFORMATION
TECHNOLOGY
DATABASE SYSTEMS
DATE: DECEMBER 2009 TIME: 1½HOURS
INSTRUCTIONS: Answer any THREE questions
QUESTION ONE [20 MARKS]
a) Describe the process of selecting a database management system product. [8 Marks]
b) Define the term transaction design. Describe three types of transactions. [4 Marks]
c) Describe any THREE applications of database views. [6 Marks]
d) Differentiate between cardinality and degree as used in relational databases. [2 Marks]
QUESTION TWO [20 MARKS]
a) DBMS software has a number of functions as a component of database system. Describe any
FOUR of them. [8 Marks]
b) Explain any two components of a database management system. [2 Marks]
c) Describe any THREE database security threats and suggest the possible countermeasures.
[6 Marks]
d) Describe the term application design. [4 Marks]
QUESTION THREE [20 MARKS]
a) Describe any two roles of data dictionary. [2 Marks]
b) Describe the term concurrency control with regard to databases. [4 Marks]
c) Explain why prototyping is a necessary step in database development life cycle. [5 Marks]
2
d) Explain any two properties of a primary key. [4 Marks]
e) Explain why requirements collection and analysis is important during the process of database
design. [5 Marks]
QUESTION FOUR [20 MARKS]
a) Explain the three phases of database design. [6 Marks]
b) Database implementation is the physical realisation of the database and application designs.
Outline the activities involved during this phase. [5 Marks]
c) Explain the following terms as used during the process of database development.
i. Database
ii. Economic feasibility
iii. Normalization [6 Marks]
d) Describe the term second normal form in database normalization. [3 Marks]
QUESTION FIVE [20 MARKS]
a) Explain the term referential integrity. [1 Mark]
b) Describe the three types of relationship types you can use in a database. [3 Marks]
c) Explain four disadvantages of file based systems. [8 Marks]
d) Outline the functions of data administrator [8 Marks]

Database Systems Question Paper

More Question Papers

Popular Exams