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

Computer Applcations Question Paper

Computer Applcations

Course:Bachelor Of Technology In Computer Engineering

Institution: Masinde Muliro University Of Science And Technology question papers

Exam Year:2009

MASINDE MULIRO UNIVERSITY OF SCIENCE AND TECHNOLOGY
(MMUST)
UNIVERSITY EXAMINATIONS 2008/2009 ACADEMIC YEAR
THIRD YEAR SECOND SEMESTER EXAMINATIONS
FOR THE DEGREE OF
BACHELOR OF SCIENCE (COMPUTER SCIENCE)
COURSE CODE: COM 305
COURSE TITLE: COMPUTER APPLICATIONS

INSTRUCTIONS TO CANDIDATES
• Answer questions one in section A and any two questions in section B
• All questions in section two carry equal marks

SECTION A
Question one
a) Define the following terms (6mks)
i) Table
ii) Record
iii) Field
b) State the disadvantages of traditional file management systems (4mks)
c) A news paper publisher uses relational database to record details of advertisement placed by businesses and members of the general public. Two relations (tables) Customer and Advertisement are used for this database. Customer (customerId, Name, Adress, CustomerType) Advertisement (AdvertId, Content, DateAdvertPlaced, NoOfNights,
Classification, CustomerId) Each advertisement is assigned a unique advert.
i) Explain what is meant by foreign key (2mks)
ii) Name the attribute which is the foreign key in the relation advertisement (3mks)
iii) Indexes are created on customer and Name attributes. Explain why an index is used? (3mks)
iv) Which of the two attribute indexes is secondary index? (2mks)
d) The following is an extract from a spreadsheet that shows how many supermarket loyalty points a customer would earn by spending different amounts of money on supermarket goods. The supermarket is currently operating a bonus scheme, which adds a fixed percentage of points to the points earned. The fixed percentage used is 10%.
B C D E F
1 Bonus% 10 Shillings
spent
Points
earned
Without
bonus Points
earned
With
bonus
2 Points earned per Shilling if Ksh 10.00 or less spent 2
3 Points earned per shilling when more than Ksh 10 but not more than Ksh 30 spent 3
4 Points earned per pound if more than Ksh 30 spent 4
5 5 10 11
6 15 45 50
7 30 90 99
8 60 240 264
9 90 360 396
10
11 240 960 1056
12 270 1080 1188
13 300 1200 1320
14

i. The value n the cell G56 is calculated from 45 × (1 +10/100) which equals 49.5. However, the value displayed in cell G56 is 50. How might this happen? (2mks)
ii. Write the formula that was entered in F5 and copied to cells F6 to F22. Your formula
should perform an automatic recalculation if the value in C2, or the value in C3, or the
value in C4, is changed. (8mks)
SECTION B
Question two
a) Explain six statistical functions used in a spread sheet (12mks)
b) i. What is cell referencing? (2mks)
ii. Distinguish between relative referencing and absolute referencing. (6mks)

Question three
a) Discuss five data management tools used to manage large data stored on a worksheet
(10mks)
b) i) What is the importance of charts and graphs in data analysis? (4mks)
ii) Explain the three logical functions used in spreadsheets (6mks)

Question four
a) Distinguish between data integrity and data security (4mks)
b) Explain the terms composite key and primary keys (4mks)
c) Discuss the advantages that a database system may have compared to convectional file
system for sorting data. (12mks)

Question five
a) What is a relational database management system? (2mks)
b) Distinguish between data, information and knowledge (6mks)
c) Discuss the major database methods (models) used to organize data (12mks)

Computer Applcations Question Paper

More Question Papers

Popular Exams

Mid Term Exams

End Term 1 Exams

End Term 3 Exams

Opener Exams

Full Set Exams