UNIVERSITY EXAMINATIONS: 2018/2019
EXAMINATION FOR THE DEGREE OF BACHELOR OF SCIENCE
IN INFORMATION TECHNOLOGY/ BACHELOR OF BUSINESS IN
INFORMATION TECHNOLOGY
BIT 1207A: DATABASE SYSTEMS PRINCIPLES
FULLTIME/PARTTIME/DISTANCE LEARNING
DATE: DECEMBER 2018 TIME: 2 HOURS
Instructions
o Answer question ONE and any other TWO.
o Question One carry 30 marks, others 20 marks each.
QUESTION ONE. (COMPULSORY)
(a) Define relational database system. (3 Marks)
(b) With respect to information management, compare the following concepts;
(i) Data security and Integrity (4 Marks)
(ii) Tuple and attribute (4 Marks)
(iii) File based system and DBMS (4 Marks)
(c) There are three default database schemas that found in SQL namely informationschema, mysql and test. Discuss each showing its role in DBMS. (6 Marks)
(d) Describe any four disadvantages of the file-based systems (4 Marks)
(e) Discuss the five components of the database management system (5 Marks)
QUESTION TWO
(a) Read the scenarios below and come up with an ERD diagram showing all possible
attributes together with PK.
“A company has several departments. Each department has a supervisor and at
least one employee. Employees must be assigned to at least one, but possibly
more departments.”
(6 Marks)
(b) (i) What is data integrity (2 Marks)
(ii) Discuss four important database security features (4 Marks)
(iii) What are constraints? Discuss three benefits of constraints (4 Marks)
QUESTION THREE
a) i) Define the term ‘SQL’ with reference to database systems (2 Marks)
ii) Distinguish between data definition and data manipulation (2 Marks)
b) Use the table (STUDENT) below to answer the questions that follow;
i. Write SQL statement to create the above table: (4 Marks)
ii. Write SQL statement to insert data new record number 5. Use your own data
(4 Marks)
iii. Write SQL statement to change ‘KILONZO’ to ‘KALONZO’ in record 1 .
(4 Marks)
iv. Write SQL statement to list all details for those doing BSC-IT (4 Marks)
QUESTION FOUR
(a) Discuss three levels of database design. (6 Marks)
(b) Write short notes on the following topics: (8 Marks)
(i) Data warehouse
(ii) Data mining
(iii) Client/Server database
(iv) Web database
(c) Discuss three dependencies’ used during normalization (6 Marks)
QUESTION FIVE
(a) Discuss normalization. Show why its is important in database design and demonstrate
how it is done. Include UNF, 1NF, 2NF and 3NF (10 Marks)
(b) Discuss, with the help of a diagrams, the database life cycle. (10 Marks)
