UNIVERSITY EXAMINATIONS: 2016/2017
EXAMINATION FOR THE DEGREE OF BACHELOR OF SCIENCE IN
INFORMATION TECHNOLOGY
BIT1207 DATABASE SYSTEMS PRINCIPLES
FULL TIME/PART TIME/DISTANCE LEARNING
SPECIAL/SUPPLEMENTARY EXAMINATION
DATE: JULY, 2017 TIME: 2 HOURS
INSTRUCTIONS: Answer Question One & ANY OTHER TWO questions.
QUESTION ONE – Compulsory (Total Marks: 30)
(a) Define a relational database system and give two examples (4 Marks)
(b) With respect to information management, compare the following concepts;
(i) Data security and Integrity (2 Marks)
(ii) Tuple and attribute (2 Marks)
(iii) File based system and DBMS (2 Marks)
(iv) MySQL and SQL (2 Marks)
(v) Cardinality and multiplicity (2 Marks)
(c) There are three default database schemas that found in MYSQL namely information-schema,
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)
(f) In (e) above, what is more important and why (1 Mark)
QUESTION TWO (20 MARKS)
a) i) Define the term ‘SQL’ with reference to database systems (2 Marks)
ii) Distinguish between DDL and DML commands (2 Marks)
b) Use the table (STUDENT) below to answer the questions that follow;
i. Write SQL statement to create the above table: STUDENT (3 Marks)
ii. Write SQL statement to insert data new record number 5. Use your own data
(3 Marks)
iii. Write SQL statement to change ‘KILONZO’ to ‘KALONZO’ in record 1.
(3 Marks)
iv. Write SQL statement to list all details for those doing BSC-IT (3 Marks)
v. Write SQL statement to add Fees for all those student doing BSC-IT (4 Marks)
QUESTION THREE (20 MARKS)
(a) Below is a list of potential entities for a KCA University database;
– Student
– Lecturer
– Courses
Draw an ERD diagram showing all possible attributes together with Primary Key and Foreign
Key. (10 Marks)
(b) (i) What is atomicity? (2 Marks)
(ii) Discuss four important database security features (4 Marks)
(iii) What are constraints? Discuss three benefits of constraints (4 Marks)
QUESTION FOUR (20 MARKS)
(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) (i) What is a View? (2 Marks)
(ii) Demonstrate how you can create a view from a table. (4 Marks)
QUESTION FIVE (20 MARKS)
(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)
