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

Dit 305:Database Systems Question Paper

Dit 305:Database Systems

Course:Diploma In It

Institution: Kenya Methodist University question papers

Exam Year:2013

KENYA METHODIST UNIVERSITY

END OF 2''ND ''TRIMESTER 2013 EXAMINATION
FACULTY : COMPUTING & INFORMATICS
DEPARTMENT : CIS & BI
UNIT CODE : DIT 305
UNIT TITLE : DATABASE SYSTEMS
TIME : 2 HOURS

Instructions:

Answer question one and any two other questions.

Question One

Define the following terms as used in databases

Database

(2 marks)

Database Management System

(2 marks)

File system

(2 marks)

With the aid of examples differentiate between data manipulation language (DML) and the Data Definition Language.

(6 marks)

Define the term normalization.

(2 marks)

State the two problems associated with redundant data.

(2 marks)

Discuss any four categories of computer crimes.

(8 marks)

Describe concurrency control techniques

(6 marks)

Question Two

Define the following terms

Entity type

(2 marks)

Entity

(2 marks)

Instances

(2 marks)

Differentiate between an attribute and an identifier of an entity.

(4 marks)

Draw an ER diagram for the following. Be sure to indicate the existence and cardinality for each relationship.
A college runs may classes. Each class may be taught by several teachers, and a teacher may teach several classes. A particular class always uses the same room. Because classes may meet at different times or on different evenings, it is possible for different classes to use the same room.

Each employee in an engineering company has at most one recognized skill, but given a skill may be possessed by several employees. An employee is able to operate a given machine type if he has one of several skills, but each skill is associated with the operation of only one machine type. Possession of a given skill allows an employee to maintain several machine-types, although maintenance of any given machine-type requires a specific skill.

(10 marks)

Question Three

Discuss the importance of the following components of a database

Recovery management

(3 marks)

Security management

(3 marks)

Transaction management

(3 marks)

Concurrency control

(3 marks)

Briefly explain the processes involved in query processing.

(4 marks)

Briefly discuss the concepts of data warehousing and data mining.

(4 marks)

Question Four

Explain the measuring of the following SQL statement

Select rent _ pm + deposit _ amount
From least; (3 marks)

Explain any three advantages of object databases.

(6 marks)

With respect to database transaction management explain the following:

Atomicity

(2 marks)

Consistency

(2 marks)

Isolation

(2 marks)

Durability

(2 marks)

List three advantages of normalization

(3 marks)

Question Five

List four traditional Data Administration functions

(4 marks)

Define data security

(2 marks)

Describe four threats to Data Security

(8 marks)

List six applications of Database Systems.

(6 marks)

Dit 305:Database Systems Question Paper

More Question Papers

Popular Exams