Database Management Systems (Dcis 200) Question Paper
Database Management Systems (Dcis 200)
Course:Computer Science And Business
Institution: Kenya Methodist University question papers
Exam Year:2012
TIME : 2 HOURS
Instructions:
Answer all questions in section A and any other two in section B.
SECTION A
Question One
Define the following terms
Database
Database management system
Primary key
DML
Explain any four reasons you would advance to an organization in order to encourage them to automate their database management process. (5mks)
Explain the concept of normalization and highlight its main goal and benefit in database design.
(4mks)
Briefly describe the role of the following people
Database designer
Database administrator
Database user
Highlight four challenges that may be encountered as a result of poor database design.
(4mks)
SECTION B
Question Two
Define the term database management system.
(3mks)
Explain any four parts of a database management system environment.
(12mks)
Question Three
Define the term entity relationship model.
(2mks)
Explain the relationship between entity relationship model and the design of relational databases.
(8mks)
Using the examples of student and book as entities of a system show the attributes of each and give a primary key for each.
(5mks)
Question Four
Why is it necessary to specify data types during database design? (4mks)
Suggest suitable data type for the following attributes as maybe used in Microsoft access.
Name
Age
Date of birth
Marital status
Address
(5mks)
State any three main roles of a database administrator and show what these roles entail.
(6mk)
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