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)
More Question Papers
Exams With Marking Schemes
Popular Exams
Mid Term Exams
End Term 1 Exams
End Term 3 Exams
Opener Exams
Full Set Exams
Return to Question Papers