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)
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