Get premium membership and access revision papers, questions with answers as well as video lessons.

Ics 2206: Database Management Systems Question Paper

Ics 2206: Database Management Systems

Course:Degree Of Bachelor Of Commerce

Institution: Jomo Kenyatta University Of Agriculture And Technology question papers

Exam Year:2010

JOMO KENYATTA UNIVERSITY OF AGRICULTURE AND TECHNOLOGY
University Examinations 2010/2011
YEAR II SEMESTER I EXAMINATIONS FOR THE DEGREE OF BACHELOR OF
COMMERCE
ICS 2206: DATABASE MANAGEMENT SYSTEMS
DATE: AUGUST 2010 TIME: 2 HOURS
INSTRUCTIONS: ATTEMPT QUESTION ONE AND ANY OTHER TWO QUESTIONS
Question One (Compulsory): 30 Marks
(a) Discuss the roles of the following personnel in the database environment.
i. Data administrator
ii. Database administrator.
iii. Database designer.
iv. Application developers. (8 marks)
(b) Define the following terms:
i. Database Management System
ii. Data independence
iii. Integrity
iv. Views (8 marks)
(c) Explainn the concepts of Relational Integrity, Referential Integrity, and Entity Integrity. (9 marks)
(d) Biefly discuss possible sources of database failure and the role of the role of log in failure recovery. (5 marks)
Question Two: 20 Marks
(a) Distinguish between:
i. Data Definition Language (DDL)
ii. Data Manipulation Language (DML) (8 marks)
(b) Discuss the Three-Level ANSI-SPARC database architecture. (12 marks)

Question Three: 20 Marks
(a) Discuss the advantages and disadvatages of DBMSs. (12 marks)
(b) Explain what an attribute is and define the following:
i. Primary key
ii. Composite key
iii. Foreign key
(8 marks)
Question Four: 20 marks
(c) By making use of Java’s built-in timekeeping feature, write a program which keeps track of the curerent date and time and presents this information in a sentence form, as shown below.
It’s 9 minutes past 4 o’clock on August 12, 2008. (20 marks)

Ics 2206: Database Management Systems Question Paper

More Question Papers

Popular Exams