End of semester I examination for the degree of bachelor of science and information technology

ICS 2206 DATABASE SYSTEMS SUP
UNIVERSITY EXAMINATION 2013/2014

END OF SEMESTER I EXAMINATION FOR THE DEGREE OF BACHELOR OF

SCIENCE AND INFORMATION TECHNOLOGY
ICS 2206: DATABASE SYSTEMS
SUPPLEMENTARY/SPECIAL EXAMINATION
DATE:.................................................... TIME: …………………….

INSTRUCTIONS

ANSWER QUESTION ONE AND ANY OTHER TWO QUESTIONS
Question One (30mks)

(a) Define the following terms used in DBMS

(i) Database

(ii) Database systems

(iii) Database Management System

(iv) Table

(v) File. (10mks)

(b) Describe any three database objects (6mks)

(c) Outline the steps one would follow to carry out the following operations

(i) Set up a pass word to protect your database

(ii) Set a particular field to be the primary key

(iii) Define a relationship

(iv) Automate a field entry

(v) Insert a row (10mks)

(d) Explain ways how to get assistance while working on Ms. Access. (4mks)


Question Two

(a) Explain any five factors to consider before purchasing a DBMS. (5mks)

(b) Describe a DBMS (4mks)

(c) (i) Define the term normalization (2mks)

(ii) State advantages of normalization (4mks)

List disadvantages of normalization (2mks)

(d) Draw an input mask for: P.O. BOX 00100 43245 Nairobi

P.O. BOX 00100 433567 Nairobi

P.O. BOX 00100 43347 Westgates

Question Three

(a) Explain the steps followed in designing a database (6mks)

(b) State the functions of database management system (4mks)

(c) State the importance of setting an input mask (2mks)

(d) I. Describe the symbols of an input mask (8mks)
Question Four

(a) State the advantages introduced by Database approach as opposed to file based system

(6mks)

(b) Explain the following field properties

(i) Caption

(ii) Allow zero length

(iii) Defolt value

(iv) Validation rule

(v) Validation text (10mks)

(c) Define the term relationship and demonstrate three types of relationships. (4mks)