Scribd
Upload
11 views2 pages

CMT 109 Database Systems

This document outlines the examination details for the Bachelor of Science in Computer Science course at The Catholic University of Eastern Africa, specifically for the Database Systems module. It includes instructions for answering questions, a variety of topics related to databases, such as definitions, components, normalization, SQL categories, DBMS advantages, E-R diagrams, joins, database models, and user roles. The exam is scheduled for April 2024 and has a duration of 2 hours.

Uploaded by

christopherdecay
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
11 views2 pages

CMT 109 Database Systems

This document outlines the examination details for the Bachelor of Science in Computer Science course at The Catholic University of Eastern Africa, specifically for the Database Systems module. It includes instructions for answering questions, a variety of topics related to databases, such as definitions, components, normalization, SQL categories, DBMS advantages, E-R diagrams, joins, database models, and user roles. The exam is scheduled for April 2024 and has a duration of 2 hours.

Uploaded by

christopherdecay
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

THE CATHOLIC UNIVERSITY OF EASTERN AFRICA

A. M. E. C. E. A P.O. Box 62157


00200 Nairobi - KENYA
MAIN EXAMINATION Telephone: 891601-6
Ext 1022/23/25
Fax: 254-20-891084
JANUARY-APRIL 2024 email:exams@[Link]
directorofexams@[Link]

FACULTY OF SCIENCE

DEPARTMENT OF COMPUTER AND INFORMATION SCIENCE

BACHELOR OF SCIENCE IN COMPUTER SCIENCE

CMT 109: DATABASE SYSTEMS

DATE: APRIL 2024 Duration: 2 Hours


INSTRUCTIONS: Answer Question ONE and any other TWO Questions
Q1.

a) Define the following terms (4 Marks)


i. Database
ii. Database management system
iii. Data instance
iv. Database schema
b) Discuss any four components of a database (4 Marks)
c) Discuss three factors you should consider before choosing a particular DBMS. (6 Marks)
d) Discuss any two security threats posed to a database showing how each can be handled.

(4 Marks)

e) State any four examples of DBMS available in the market. (2 Marks)

Q2.

a) Define the term normalization and briefly discuss the three major forms of normalization.

(8 Marks)

b) State and briefly discuss the three data anomalies which may exist in un normalized database
(6 Marks)
c) SQL statements are often divided into categories. Discuss the following categories, giving
examples of the SQL commands used in each (6 Marks)
CUEA/ACAD/EXAMINATIONS/DIRECTORATE OF EXAMINATIONS & TIMETABLING Page 1

ISO 9001:2015 Certified by the Kenya Bureau of Standards


i) Data Definition Language
ii) Data manipulation Language
iii) Data Control Language

Q3.

a) Discuss four advantages that a DBMS offer compared to traditional file systems.
(8 Marks)
b) Define the term E-R diagram and discuss the three major components of an E-R diagram

(7 Marks)

c) Discuss the different kinds of relationships (3 Marks)


d) List two data types used in an Access database and two data types used in SQL.(2 Marks)

Q4.
a) Define joins and briefly describe various join types (10 Marks)
b) Define the term database model and discuss the four types of database models used today
(10 Marks)

Q5.

a) Describe the following database users:

i) Database designers (2 Marks)


ii) Database administrators (2 Marks)
iii) Database End-users (2 Marks)
b) Database schema can be categorized into three parts. Discuss those (6 Marks)
c) What is data independence? (2 Marks)
d) Describe the two categories of data independence (6 Marks)

*END*

CUEA/ACAD/EXAMINATIONS/DIRECTORATE OF EXAMINATIONS & TIMETABLING Page 2

ISO 9001:2015 Certified by the Kenya Bureau of Standards

You might also like