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