UNIVERSITY EXAMINATIONS: 2017/2018
EXAMINATION FOR THE DIPLOMA IN BUSINESS INFORMATION
TECHNOLOGY
DBIT301 DATABASE MANAGEMENT SYSTEMS (DBMS)
FULLTIME & PART TIME
DATE: AUGUST, 2018 TIME: 1 ½ HOURS
INSTRUCTIONS: Answer question One and ANY other two questions.
QUESTION ONE [30 MARKS]
(a) Differentiate between the following terms:-
(i) Primary key & Foreign key [2 Marks]
(ii) Entity & tuple [2 Marks]
(iii)Database & DBMS [2 Marks]
(b) Explain four DML commands supported by MYSQL/ SQL [8 Marks]
(c) Explain four functions of Database Management systems [4 Marks]
(d) Table 1 shows customers details created in a database program. Use it to answer the
questions that follow:-
Required:-
Write SQL/ MYSQL statements to perform the following transactions:-
(i) Return details of all customers aged below 30 years who reside in Nairobi city [3 Marks]
(ii) Insert the data (5001, Mary, Box 56 Machakos, Machakos and 34 years) into the
respective columns in the customers table [4 Marks]
(iii)Amend the city data from ‘Kisumu to ‘Mombasa’ for a Customer Id ‘100’ [3 Marks]
(iv)Delete all the records in the customers table [2 Marks]
QUESTION TWO [20 MARKS]
(a) Discuss five components of a database system environment [5 Marks]
(b) Identify four properties of transactions [4 Marks]
(c) Explain four functions of a database management system [4 Marks]
(d) Outline the steps during database design that will result in an entity-relationship diagram
[4 Marks]
(e) Explain three limitations of file based systems [3 Marks]
CustomerID Firstname Lastname address City Age
100 James Kamau Box 32 Kisumu 12
101 Caroline NJoroge Box 120 Nairobi 34
102 Janet Kamau Box 32 Kisumu 15
103 John Karoti Box 23 Nairobi 19
QUESTION THREE [20 MARKS]
a) Define the term ‘database transaction’ and identify four properties exhibited by database
transactions [5 Marks]
b) Explain two benefits of Object oriented data modeling [2 Marks]
c) Explain five application areas of database systems [5 Marks]
d) (i)Define the term ‘Normalization’ with respect to logical data design [2 Marks]
(ii)Describe any three anomalies that are associated with bad database design [6 Marks]
QUESTION FOUR [20 MARKS]
(a) Discuss five security threats to a computerized database system [5 Marks]
(b) Outline five qualities of an effective Database administrator (DBA) [5 Marks]
(c) Outline three advantages of Entity Relationship Diagrams [3 Marks]
(d) A manufacturing company produces products. Product information stored is product
name, id, and quantity on hand. These products are made up of many components. Each
component can be supplied by one or more suppliers. Component information kept is
component id, name, description, suppliers who supply them, and which products they are
used in.
Required:-Create an ERD Showing entity names, primary keys, attributes for each entity and
relationships between the entities [7 Marks]
QUESTION FIVE [20 MARKS]
(a) Distinguish between logical and physical database design [4 Marks]
(b) With the aid of a diagram, describe two database models [6 Marks]
(c) A new database system is to be implemented in an organization. Identify four issues that
should be addressed in order to ensure minimal staff resistance. [4 Marks]
(d) Highlight two advantages of MYSQL as a DBMS [2 Marks]
(e) Describe any two objects in a database system [4 Marks]
