UNIVERSITY EXAMINATIONS: 2018/2019
EXAMINATION FOR THE DEGREE OF BACHELOR OF SCIENCE
IN INFORMATION TECHNOLOGY/ BACHELOR OF BUSINESS IN
INFORMATION TECHNOLOGY/ BACHELOR OF SCIENCE IN
APPLIED COMPUTING
BIT1207A DATABASE SYSTEMS PRINCIPLES
APRIL 2019 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. (2 Marks)
(b) With respect to database 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 Atomicity (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 (3 Mark)
QUESTION TWO
(a) (i) What is ERD? (2 Marks)
(ii) Study the scenario below:
A university has a large number of courses in its catalog. Each course may have one
or more other courses as prerequisites, or may have no prerequisites.
Draw an ERD diagram showing all possible attributes together with unique identifier.
(10 Marks)
(b) (i) Discuss four important database security features (4 Marks)
(ii) What are constraints? Discuss three benefits of constraints (4 Marks)
QUESTION THREE
(a) Discuss normalization. Show why it 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)
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) (i)What is a View? (2 Marks)
(ii) Demonstrate how you can create a view from a table. (4 Marks)
QUESTION FIVE
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;
STU-ID SURNAME OTHERNAMES COURSE FEES
ST-001 KILONZO PETER BSC-IT 4000
ST-002 MUKONZI JANE BCOMM 4500
ST-003 MWANGI ADREW BSC-IT 4000
ST-004 HURRY PAUL BSC-IT 4000
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)
