Uganda Institute of Information and Communications Technology
IT 122: Database Systems Design I Test I ITS I Time: 1 hour
Attempt any TWO questions
Question One
(a) Differentiate between a file system and database approaches to data management. (5 marks)
(b) What do you understand by the term ‘Database application program? (3 marks)
(c) Give any five limitations of file-based systems. (5 marks)
(d) Define a Database Management system and give any five functions associated with it. (7 marks)
Question Two
(a) Write short notes on the following in relation to database systems: (1 mark @)
(i) Attribute b) Database d) Relation e) Record f) Entity
(b) Despite all the advantages associated with databases, they still portray some
disadvantages. Mention any five of these disadvantages. (5 marks)
(c) Using an illustration, write a paragraph on any four components of the DBMS
environment. (10 marks)
Question Three
a) Use an illustration to explain the three levels of the DBMS architecture. (7 marks)
b) Give any three objectives of the DBMS architecture. (3 marks)
c) Define a database view and give any four advantages of implementing views.
(5
marks)
d) Mention any five functions of a database administrator. (5 marks)
Question Four
a) Define a data model. (2 marks)
b) Explain the three parts of data model. (6 marks)
c) Using illustrations, explain what you understand by ‘Network’,’Hierarchical’ and
‘Relational’ data models. (6 marks)
d) What do you understand by conceptual, logical, and physical data models? (6 marks)
GOOD LUCK!!
ANSWERS
Difference between File System and Database Approaches to Data Management
A file system stores data in separate files, requiring individual programs to manage
and retrieve data.
A database management system (DBMS) organizes data in structured tables with
relationships, allowing efficient querying and manipulation.
DBMS reduces redundancy, ensures data integrity, and supports concurrent access,
unlike file systems.
(b) Definition of Database Application Program
A database application program is a software program designed to retrieve,
insert, update, and delete data from a database. It enables users to interact with
stored data efficiently.
(c) Five Limitations of File-Based Systems
1. Data Redundancy – Same data may be stored in multiple files, leading to
duplication.
2. Data Inconsistency – Changes in one file may not be reflected in others, causing
discrepancies.
3. Limited Data Sharing – Files are isolated, making it difficult to share data across
applications.
4. Security Issues – File-based systems lack robust security mechanisms.
5. Difficulty in Accessing Data – Searching and retrieving data is inefficient compared
to databases.
(d) Definition and Functions of a Database Management System (DBMS)
A DBMS is software that manages databases, ensuring efficient data storage,
retrieval, and security.
Five functions of a DBMS include:
1. Data Storage Management – Organizes and stores data efficiently.
2. Security Management – Controls access and protects data.
3. Backup and Recovery – Ensures data safety in case of failures.
4. Multi-User Access Control – Allows multiple users to access data simultaneously.
5. Data Integrity Management – Maintains accuracy and consistency of data.
