Database Management Systems(Dbit 221) (Dcis 200) Question Paper
Database Management Systems(Dbit 221) (Dcis 200)
Course:Computer Science & Business Information
Institution: Kenya Methodist University question papers
Exam Year:2013
TIME : 2 HOURS
INSTRUCTIONS
Answer Question one (compulsory) in Section A and any other two questions in section B.
SECTION A
Question One
Define the following terms
(6 Marks)
Database
Data independence
Entity
Differentiate between a relationship and relationship set.
(2 Marks)
A database comprises of four elements. List and explain them.
(12 Marks)
Define the four major symbols used in an ER diagram.
(4 marks)
Explain any three types of End users
(6 Marks)
SECTION B
Question Two
Define ER
(2 Marks)
List three types of cardinalities
(3 marks)
Differentiate between the main tasks carried out by the DA and the DBA.
( 10 Marks)
Question Three
Define five terms for providing security to a dbms
(5 marks)
Show the ER diagram of the following tables, student, lecturer, and course.
(10 Marks)
Question Four
Draw a diagram to show the components of a dbms.
(10 Marks)
Briefly explain the attributes of dbms components.
(5 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