- Answer Any Five 5 Questions Question 1 20 Marks A Database Management System Dbms Is A Collection Of Programs Tha 1 (71.53 KiB) Viewed 23 times
Answer ANY FIVE (5)
questions.
QUESTION 1 (20 Marks) A database management system (DBMS) is a collection of programs that enables you to store, modify, and extract information from a database. With this in mind, answer the
questions that follow: 1.1 Briefly explain the types of databases. (10 marks) (10 marks) 1.2 Provide ANY FIVE (5) functions of a DBMS.
QUESTION 2 (20 Marks) A database system is composed of five major parts: hardware, software, people, procedure and data. People include all users in a database system. 2.1 Identify FIVE (5) types of users and briefly explain their importance in a Database Management System (DBMS). (10 marks) 2.2 The file system of storing information was a definite improvement on manual systems, but it had its own set of problems. Discuss the limitations of file systems. (10 marks)
QUESTION 3 (20 Marks) 3.1 Lock granularity specifies the level of lock use. List and explain the FOUR (4) levels of lock granularity. (10 marks) 3.2 Deadlock is also referred to as a deadly embrace. Explain the THREE (3) techniques to control deadlocks. (10 marks)
QUESTION 4 (20 Marks) The object-oriented data model (OODM) represents the real world more closely than the relational model. Discuss the entity relationship model and the object-oriented model in detail.
QUESTION 5 (20 Marks) A transaction is a sequence of database operations that access the database. 5.1 List and describe the properties that all database transactions should display. (10 marks) 5.2 Briefly discuss the techniques used in transaction recovery procedures. (10 marks)