UNIVERSITY EXAMINATIONS: 2019/2020
EXAMINATION FOR THE DEGREE OF BACHELOR OF SCIENCE IN
INFORMATION TECHNOLOGY/ BUSINESS INFORMATION
TECHNOLOGY
BIT 3202 A/ BBIT 304/ BAC 3204: DISTRIBUTED
DATABASES/ADVANCED DATABASE SYSTEMS
FULL TIME/PART TIME/DISTANCE LEARNING
DATE: MAY, 2020 TIME: 6 HOURS
INSTRUCTIONS: Answer ALL Questions
SECTION B: (20 MARKS)
QUESTION ONE
a) A banking database should contain the customer’s information along with the types of
accounts customer is maintaining. Customer information is its full profile in information
along with its current address, PAN ID, Card no. included and account information should
include type of account (Saving, fixed, current), date and time of access and the transaction
details. Write the DTD rules for the above XML documents and create an XML schema for
the above XML document. 10 Marks
b) Describe using a case of an existing organization how you would develop a distributed
database for it 10 Marks
SECTION C: (20 MARKS)
QUESTION ONE
What is horizontal and vertical fragmentation? What are the types of horizontal fragmentation?
Perform horizontal Fragmentation for student relation as given below. Also give the correctness
criteria for it.
a) Students (studentrollno., Student Name, Course Name, Course Name, Course fees, year)
10 Marks
b) What problem can occur in a distributed system due to the failure of link and partitioning of
the network? What are the ways by which recovery can take place?
10 Marks
