UNIVERSITY EXAMINATIONS: 2018/2019
EXAMINATION FOR THE DIPLOMA IN BUSINESS INFORMATION
TECHNOLOGY
DBIT301 DATABASE MANAGEMENT SYSTEMS
DATE: AUGUST, 2019 TIME: 2 HOURS
INSTRUCTIONS: Answer question One and ANY other two questions.
QUESTION ONE [20 MARKS]
(a) Outline four reasons for user resistance during database system implementation
[4 Marks]
(b) State four components of a technical documentation report [4 Marks]
(c) Explain six reasons for changing from manual systems to computerized database
systems [6 Marks]
(d) Explain four components of a DBMS [4 Marks]
(e) Using a simple illustration, explain the following components of a database:-
(i) Field [2 Marks]
(ii) Record [2 Marks]
(iii)File [2 Marks]
(f) Explain three qualities of a good database system [6 Marks]
QUESTION TWO [20 MARKS]
(a) Outline five functions of a database administrator in a database system [5 Marks]
(b) Write SQL/ MYSQL statements that would be used to perform each of the following in a
table named Lecturers in a database:-
(i) Display all the fields from the table which has the qualification field name as
Masters [3 Marks]
Page 2 of 3
(ii) Display the fields Lecturer ID and Lecturer Gender for the lecturers who have
lecturer ID as 100 [3 Marks]
(iii)Delete from the table all records with Lecturer Name Janet [3 Marks]
(iv)Display all the fields from the table whose age field values ranges from 40 to 56
[3 Marks]
(v) Display the structure of the lecturers table [3 Marks]
QUESTION THREE [20 MARKS]
(a) Discuss three disadvantages of using a database system in an organization [3 Marks]
(b) List and explain three DDL commands supported by MYSQL/ SQL [6 Marks]
(c) With the aid of well labeled illustrations, describe any three database models [9 Marks]
(d)Define the term “DBMS” [2 Marks]
QUESTION FOUR [20 MARKS]
(a) Explain the term “normalization” as used in database systems [2 Marks]
(b) Discuss four benefits of database normalization [8 Marks]
(c) Consider the following relational schemas:
Borrower (borrowerIDNumber,firstname);
Book (bookNumber, author, publisher, borrowerIDNumber, title)
Required:
(i) Write SQL/ MYSQL statements to create the relations [4 Marks]
(ii) From the above created relations, write queries in SQL/ MYSQL to:
(i) Find the titles of the books borrowed by the borrower whose
borrowerIDNumber is 34 [3 Marks]
(ii)Find the numbers and names of borrowers who have borrowed
books on Operating Systems [3 Marks]
Page 3 of 3
QUESTION FIVE [20 MARKS]
(a) Read the scenario below and answer the questions that follows:-
At ABC Company, there are several departments. Each department has a unique
identification, a name, location of the office and a particular employee who manages
the department.
A department controls a number of projects, each of which has a unique name, a unique
number and a budget. Each employee has a name, identification number, address, salary
and birthdate. An employee is assigned to one department but can join in several
projects. There is a need to record the start date of the employee in each project.
The company wants to keep track of the dependents for each employee. Each dependent
has a name, birthdate and relationship with the employee.
Required:
(i) Draw an Entity Relationship Diagram (ERD) to represent the information in
the scenario above (use Chen notations) [9 Marks]
(ii) Outline three advantages of ERD as database modeling tool [3 Marks]
(b) Explain the following terms as used in database systems:-
(i) Data integrity [2 Marks]
(ii) Transaction [2 Marks]
(iii)Views [2 Marks]
(iv)Primary key [2 Marks]
