Cisy 221:Database Managment Systems Question Paper
Cisy 221:Database Managment Systems
Course:Computer Science
Institution: Kenya Methodist University question papers
Exam Year:2012
KENYA METHODIST UNIVERSITY
END OF 2''ND ''TRIMESTER 2012 (DAY) EXAMINATIONS
FACULTY : COMPUTING AND INFORMATICS
DEPARTMENT : COMPUTER SCIENCE AND BUSINESS INFORMATION
UNIT CODE : BBIT 232/CISY 221
UNIT TITLE : DATABASE MANAGEMENT SYSTEMS
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
Relational Database
Normalization
Access control
(6mks)
Distinguish between logical independence and physical independence of DBMS.
(4mks)
Why are entity integrity and referential integrity important in a database?
(4mks)
a) What are multivalued attributes?
b) How can they be handled within databases design? (4mks)
(v) Define and describe the concept of transitive dependency. (4mks)
(vi) List any four factors in DBMS software selection. (4mks)
(vii) Describe any four components of a database environment. (4mks)
SECTION B
Question One
Explain the four file organization technique and state the appropriateness of each.
(8mks)
Briefly describe the factors to consider when choosing the right DBMS for use in an organization.
(7mks)
Question Two
State three roles of a database administrator (DBA) in an organization that uses database systems.
(3mks)
A security policy is important in any organization that needs to secure its data. Discuss any four security issues that need to be included in such a security plan.
(6mks)
explain the following database security features
authorization
backups
administrative controls
(6mks)
Question Three
What is the purpose of entity relation diagram in database design? (4mks)
How can the mapping of ERD’s be implemented in relational database design?
(5mks)
Describe how the cardinality of entity occurrences can be used in enforcing referential integrity in databases.
(6mks)
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