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

Got a question or eager to learn? Discover limitless learning on WhatsApp now - Start Now!

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)

Cisy 221:Database Managment Systems Question Paper

More Question Papers

Popular Exams