UNIVERSITY EXAMINATIONS: 2021/2022
EXAMINATION FOR DEGREE IN BACHELOR OF SCIENCE
INFORMATION TECHNOLOGY/ INFORMATION SECURITY AND
FORENSICS/APPLIED COMPUTING/SOFTWARE DEVELOPMENT
BSD 1306/BISF 1301/BAC 1301/BIT 2104: DATABASE DESIGN AND
DEVELOPMENT
MODE: PART TIME/FULL TIME/DISTANCE LEARNING
ORDINARY EXAMINATIONS
DATE: DECEMBER.2021 TIME: 2 HOURS
INSTRUCTIONS: Answer QUESTION ONE and any other TWO Questions
QUESTION ONE [20 MARKS]
a) Explain a data model highlighting the composition of its structure. (4 Marks)
b) Describe three levels of database backup that can be used in database recovery
management. (3 Marks)
c) The SDLC is a complete set of steps that a team of information systems professionals,
including database designers and programmers, follow in an organization to specify,
develop, maintain, and replace information systems. Explain the implementation phase of
the Systems Development Life Cycle. (5 Marks)
d) Explain any four guidelines about naming a data object. (4 Marks)
e) Explain why you will propose to an organization SQL for adoption as a standard for
Relational Database Management Systems. (4 Marks)
QUESTION TWO [15 MARKS]
You have been given tasked to come up with a design of a database for a proposed Parcel delivery
system. After a brief discussion with users you have identified two key entity types and
corresponding attributes for each entity type, namely sender and parcel. The sender is described
by sender Number, sender name and address. The parcel is described by parcel number,
description, fee charged, cashier name.
a) Using this case perform normalization and draw an ERD using Chen’s notation.
(10 Marks)
b) Map the logical design in a) to physical data model.
(5 Marks)
QUESTION THREE [15 MARKS]
a) Map the following Entity Relational (ER) attributes to a Relational Data model; Entity
type: Customer, Identifier: Customer ID, Attributes : Customer Name, Customer
Address, Customer Postal Code. (8 Marks)
b) Define the term Normalization. (1 Mark)
c) Explain any three of the normal forms. (6 Marks)
QUESTION FOUR [15 MARKS]
a) A table for storing employee’s records in a database had the following data:
i. Write an SQL statement that will produce a list of all staff showing the staff no, last
names, and first names only. (3 Marks)
ii. Write an SQL statement that will produce the same list as (ii) above but with the last
name and first name combined as staff names. (4 Marks)
iii. Write an SQL statement to display details of all staff whose position is Driver.
(2 Marks)
iv. Write an SQL statement that would count the different types of positions for the
employees. (3 Marks)
b) Describe the following terms:
i. Foreign key
ii. Attribute
iii. Relationship
(3 Marks)
