UNIVERSITY EXAMINATIONS: 2019/2020
EXAMINATION FOR DIPLOMA IN INFORMATION
TECHNOLOGY
DIT 205: PRINCIPLES OF DATABASE SYSTEMS
ORDINARY EXAMINATIONS
MODE: FULL TIME/PART TIME
DATE: MAY, 2020 TIME: 6 HOURS
INSTRUCTIONS: Answer ALL Questions
SECTION B: (20 MARKS)
QUESTION ONE
a) For each of the following relations, indicate the normal form for the relation. If the
relation is not in the third normal form (3NF), decompose it into 3NF relations and
briefly explain the steps.
[6 Marks]
Functional dependencies (other than those implied by the primary key) are shown where
appropriate.
(a) CLASS (Course_No, Section_No)
(b) CLASS (Course_No, Section_No, Room)
(c) CLASS (Course_No, Section_No, Room, Capacity) Room Capacity
(d) CLASS (Course_No, Section_No, Course_Name, Room, Capacity) Course_No
Course_Name, Room Capacity.
b) Produce the Third Normal Form of this document by normalization.
SECTION B: (20 MARKS)
QUESTION TWO
a) You have been approached by a health institution to develop for them a database based on
their unique specifications. Briefly describe the procedure or steps that you will follow until
you present the working database to the organization. [8Marks]
b) The following tables form part of a database held in a relational DBMS (The primary key of
each table has been underlined).
Hotel (hotelNo, hotelName, city)
Room (roomNo, hotelNo, type, price)
Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo)
Guest (guestNo, guestName, guestAddress)
Identify the foreign keys in this schema and briefly explain how the entity and referential
integrity rules apply to these relations. [8Marks]
c) State any four types of attributes
