Bit 1207: Computer Applications Software (Distance Learning) Question Paper
Bit 1207: Computer Applications Software (Distance Learning)
Course:Bachelor Of Science In Information Technology
Institution: Kca University question papers
Exam Year:2014
1
UNIVERSITY EXAMINATIONS: 2013/2014 ORDINARY EXAMINATION FOR THE BACHELOR OF SCIENCE IN INFORMATION TECHNOLOGY BIT 1207 COMPUTER APPLICATIONS SOFTWARE (DISTANCE LEARNING) DATE: APRIL, 2014 TIME: 2 HOURS INSTRUCTIONS: Answer Question ONE and any other TWO QUESTION ONE:[30 Marks]
a) Describe THREE advantages and THREE disadvantages of database approach.
[6 Marks]
b) Discuss THREE advantages and THREE disadvantages of file based systems.
[6 Marks]
c) Discuss THREE components of database management system (DBMS). [6 Marks]
d) Describe FIVE components of a database system. [5 Marks]
e) Describe the process of database management system selection. [4 Marks]
f) Explain any THREE disadvantages of distributed database. [3 Marks]
QUESTION TWO: [20 Marks]
a) Describe any THREE goals of database normalization. [3 Marks]
b) Discuss the following database models.
i. Relational model [2 Marks]
ii. Object oriented model [2 Marks]
iii. Hierarchical model [2 Marks]
iv. Network model [2 Marks]
c) Discuss the following database anomalies. Give example in each case.
i. Deletion anomaly. [3 Marks]
ii. Insertion anomaly. [3 Marks]
2
iii. Update anomaly. [3 Marks]
QUESTION THREE :[20 Marks]
a) Describe any SIX security measures intended to counter database security threats
[6 Marks]
b) Using the table EMPLOYEE below, write SQL statements in each case to perform the tasks specified i-iv.
EmpNo
EmpName
EmpAge
EmpGender
EmpEmail
DeptNo
E001
Jacob
23
Male
ja@yahoo.com
D3
E002
Janet
24
Female
jan@gmail.com
D3
E005
Griffin
27
Male
gri@ymail.com
D1
E007
Fredrick
25
Male
fre@yahoo.com
D4
E009
Alice
25
Female
ali@ymail.com
D2
i). Display all employees whose names have letter i. [2 Marks]
ii). Display unique age values for the employees. [2 Marks]
iii). Calculate the average age for the employees. [1 Mark]
c) Define database integrity; hence describe the following types of database integrity giving an example in each case.
i. Domain integrity.
ii. Entity integrity.
iii. Referential integrity.
iv). User defined Integrity.
[9 Marks] QUESTION FOUR: [20 Marks]
a) Describe any FIVE functions of database management system(DBMS)
[ 5 Marks]
3
b) Transaction management deals with the problem of always keeping the database in a consistent state .In doing so, a transaction must always maintain for properties. Describe these properties and show how they relate to concurrency control and recovery. [8 Marks]
c) One of the ways in which concurrently executing transactions can interfere with one answer and compromise the integrity and consistency of the database is the inconsistency analysis problem. Demonstrate in details how this problem occurs and suggest a solution to it. [7 Marks]
d) Use the case study below and answer the questions that follow.
Members of a friendly society invest money in any one of the society''s branches. A member may hold a number of investment accounts. Each investment account is associated with the branch where it was opened, but money may be paid in or withdrawn at any branch. For each account, the member holds an account book to record all transactions.
i). Identify entity types in this case. [3 Marks]
ii). Identify the relationships. [2 Marks]
iii). Produce conceptual data model for this case. [3 Marks]
QUESTION FIVE: [20 Marks]
a) Normalize the document below to third normal form.
Sales Order
ABC &co
Box 123 NAIROBI
Customer Number:
1000
Sales Order Number:
405
Customer Name:
Manhut
Sales Order Date:
12/2/2014
Customer Address:
BOX 14 THIKA
Clerk Number:
210
Clerk Name:
Jane
Item Number
Description
Quantity
Unit Price
Total
800
Jik
40
50
2000
801
Colgate
30
60
1800
805
Dettol
12
100
1200
ORDER TOTAL
5000
4
[10 Marks]
b) Describe the characteristics of a table that violates first normal form (1NF) and then describe how such a table is converted to 1NF. [4 Marks]
c) Describe what is meant by full functional dependency and describe how this type of dependency relates to 2NF. Provide an example to illustrate your answer. [6 Marks]
More Question Papers
Exams With Marking Schemes