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

Bbit 232 Cisy221 Comp 340 Bsis 115 Dbit221 Dcis106 ( Database Systems) 2 Trimester 2016 Question Paper

Bbit 232 Cisy221 Comp 340 Bsis 115 Dbit221 Dcis106 ( Database Systems) 2 Trimester 2016

Course:Bachelor Of Business Information Technology

Institution: Kenya Methodist University question papers

Exam Year:2016

BBIT 232 CISY221 COMP 340 BSIS 115 DBIT221 DCIS106 ( Database Systems)(2 Trimester 2016)FT
KENYA METHODIST UNIVERSITY

END OF 2'ND 'TRIMESTER 2016 (FT) EXAMINATION

FACULTY : COMPUTING & INFORMATICS
DEPARTMENT : COMPUTER SCIENCE
UNIT CODE : 'BBIT 232/CISY221/ COMP 340/ BSIS 115/
DBIT221/DCIS106
UNIT TITLE : DATABASE SYSTEMS
TIME : 2 HOURS

INSTRUCTIONS

Answer Question One and any other Two Questions.
SECTION A (30 Marks)

Question One

In 3-tier application architecture, each tier is completely independent
from all other tiers where you can share and reuse the components and services you create. Highlight the main benefits of the 3-tier architecture [3 Marks]
Define a database and highlight 4 areas of database applications.
[5 Marks]
Explain a transaction as used in databases and clearly outline its
Properties. [10 Marks]
Differentiate between Database Management System (DBMS) and
Database System [4 Marks]
Discuss the three main levels of abstractions in databases. [6 Marks]
Identify the impact of using unnormalized data?

[2 Marks]
SECTION B

Question Two

Query processing takes place in two major phases; query optimization
and query execution''''. Define a Query Processor and outline what happens in those two phases? [6 Marks]

Dept # DName Location MgrName Mgr ID No. Tel Extn. Cust # Cust Name Date of Complaint Nature of Complaint
11232 Soap Division Cincinnati Mary Samuel S11 7711 P10451 Robert Drumtree 1/12/1998 Poor Service
11232 Soap Division Cincinnati Mary Samuel S11 7711 P10480 Steven Parks 1/14/1998 Discourteous Attendant

Given the table below, normalize it up to the 1st Normal form clearly indicating the fields that are the primary key
[9 Marks]

Question Three

Distinguish between the following terms
[6 Marks]
Insertion anomaly; Update anomaly; Deletion anomaly;

Define database approach and explain Its main characteristics
[9 Marks]

Question Four

a) Clearly outline FIVE Limitations of File-Based Approach [5 Marks]

b) XYX is a commercial bank whose daily activities involve cash deposits, withdrawals by their customers as well us accounts updates by the bank employees. The bank tellers access customers’ accounts with the help of a banking Information System installed in their work stations. These transactions are stored in the bank databases created and maintained within the bank’s server room. Identify database users involved above and explain their roles. [10 Marks

Bbit 232 Cisy221 Comp 340 Bsis 115 Dbit221 Dcis106 ( Database Systems) 2 Trimester 2016 Question Paper

More Question Papers

Popular Exams