LEARNING AREA: INFORMATION SYSTEM

Instruction : This question paper consists of three (3) sections. Answer all questions in
section A and section B. Answer 2 questions from section C, question 1 is
compulsory.

SECTION A

Choose the correct answer.

1. A decision support system for senior-level executives is called ____________.

a. model
b. MIS
c. EIS
d. DSS
Answer : B

2. MIS stands for _____________.

a. Management Information System
b. Management Internal Simulation
c. Multiple Integrated System
d. Model Independent Simulation
Answer : A

3. DSS stands for __________________.

a. Decision Support System
b. Dependable Selection System
c. Database Selective System
d. Non of the above
Answer : A

4. The information centre or support centre does not offer help with which of the
following
a. Software and hardware selection
b. Network access
c. User training
d. Travel arrangement
Answer : D

5. A computer system that supports managers in non-routine decision-making tasks

is called _____________________.
a. Information centre
b. Variable
c. DSS
d. Model
Answer : C
6. A DSS is used by _____________________.
a. Top-level managers only
b. Middle-level managers only
c. Low-level managers only
d. All levels of management
Answer : D

7. Which of the following is a technique designed to determine the overall cost

payback of personal computers?
a. EIS
b. CIO
c. TCO
d. MIS
Answer : C

8. A decision support system for senior-level executives is called _______________.

a. Model
b. MIS
c. EIS
d. DSS
Answer : C

9. A ________________ is the smallest meaningful unit of data.

a. field
b. record
c. file
d. database
Answer : A

10. Which of the following statement about primary and foreign key values is true?
a. Only primary key values must be unique
b. Only foreign key values must be unique
c. Both primary and foreign key values must be unique
d. Neither primary nor foreign key values must be unique
Answer : A

[10 marks]
 Match the meaning with the correct word

11

Group of related characters. File

12
A fields that uniquely identifies each Field
record in a file.

13
Consist of facts or observations about Primary Key
people, places, thing and events.

14
A window on the screen that provides Data
areas for entering or changing data in
a database.

15
A collection of related records.
Form

[5 marks]
 State True / False
FALSE
16. Middle-level managers focus on planning ____________
FALSE
17. A record is made up of files ____________
TRUE
18. The two steps to create a table are designing its ____________

structure and entering the data.

FALSE
19. In addition to formatted reports, most database ____________
can be used to produce graphical output, such as
bar graph, line graph and pie chart.
TRUE
20. The personal computer manager is often the same ____________
person as the network manager or LAN manager

[5 marks]
Fill in the blank with correct answer.
DBMS
21. A (n) ______________________ is a software package that is used to create and
Query
manage a database. _________________ retrieve data from a database by
presenting criteria that the DBMS uses to select the desired data. It is written
query language . _________________________________
using a ___________________ Structured Query Language/SQL is a
standard query language that supported by DBMS.
field
22. The ____________ is the smallest meaningful unit of data and consists of a group
of one or more characters that has a specific meaning. The set of field containing
record
data about a single person makes up that person’s ___________________A
file or table
collection or related records makes up a (n) __________________. A
database
______________ is a collection of related tables.
primary key
23. Records in a file are identified by their ______________________, which
foreign key is a field in another
contains a unique value for each record. ________________
table that contains the value of primary key.
MIS
24. A _____________________________ is a set of business systems designed ti
DSS
provide information for decision-making while a ___________________ is a
computer system that supports managers in non-routine decision-making tasks
model
which involves a __________________ , a mathematical representation of a real-
life situation.
design
25. The phases of system development are analysis, ____________________,
implementation, testing
______________________, documentation and
maintenance
_____________________.
[16 marks]
 SECTION B
Answer all the questions

1. a. Give the definition of Information System.

(IS) is a collection of hardware, software, data, people and procedures that works
together to produce a quality information
[1 mark]
b. State 3 fields that use Information System .
i. Education
[Link]
iii. Management
[3 marks]

2. Base on the diagram below answer the following question.

FRIEND_INFO PHONE_INFO
FriendID FriendID
Name Phone_number
Address
D.O.B

Table 1 Table 2

a. Identify the Primary key and state its function

friendID , is a field that uniquely identifies each record in a file

[2 marks]

b. List 2 other information that can be included in Table two.

e-mail address, 2nd phone number, class ( any information that is relevant)
[2 marks]

3. a. There are five types of information system. List two that you know.

i. Management Information System( MIS)

ii Decision Support System (DSS)
( also accept TPS, EIS/ESS AND AI)
[2 marks]
b. Choose two of the above answers and state the usage each of it.
[2 marks]
MIS
Summarizes the detailed data of transaction processing system in standad report for
middle – level managers. Produces reports that are predetermined.

DSS
Provides a flexible tool for analysis

ESS
Is and easy to use system that presents information in a very highly summarized form.
Develop strategic plans and oversee the company’s operation for the top-level managers

4. a. There are six Database Development phases.

i) State the last phase.
ii) In which phase that you can ensure the program runs correctly and it is error
free.
[2 marks]
i) maintenance
ii) Testing

b. In Database Development, there are three steps to follow in Analysis Phase. List
two of them.
[2 marks]

1. identifying project title

2. identifying project requirement
3. classifying project requirement

5. a. Explain the Database Management System (DBMS)?

[2 marks]
Is a software that allows to create, access and manage a database. DBMS are
available is many seize and type of computers.

b. List two benefit of Database.

[2 marks]

Can share information

Easy to update information
It creates paperless environment
Is easier to search for information
And others that is relevant
 SECTION C
Answer 2 questions from this C, question 1 is compulsory.

QUESTION 1
Answer the following questions based on diagram 1.

System X

people Y Software

hardware Procedure

Diagram 1

a) Name system X and one of its functions.

[2 marks]
b) Label Y and complete the interrelationship diagram using the proper arrows.
[3 marks]
c) Explain the relationship between Y and people.
[2 marks]
d) State one example of system X which is commonly used in our society.
[1 mark]

a) X = information system
Enables updates, Management of information (other relevant)
b)
data

people Software

hardware Procedure

c) people should provide accurate data and information. Provided data should be true and
correct.
d) MIS , DSS, TIP,AI and (banks / education / business )
QUESTION 2

Diagram 2 shows the management system of Jempol Hospital patient records. Answer the
questions based on the diagram

Input X

Verification of patient

Diagram 2

a) What is X
[1 marks]
b) State the benefit of using X and the software used to create it.
[2 marks]

c) Explain the meaning of verification and state the methods of verification used in
the above system.
[3 marks]
d) State two consequences if the system is hacked by the unauthorized personnel.
[2 marks]
Answer

a) X = information system
b) Easy to manage information, retrieve data, easy update information and other
relevant answer and Ms Access
c) Is an act of proving or disproving he/she who they say they are and the method are
user identification and processed objects ( identification card and security token)
d) data could be lost, information is stolen, data can be changed, infected by virus
QUESTION 3

The following questions are based on the situation below.

Mr. Guasuka wants to build a database system for his company Look4you. He needs the
system to help him manage the staff profile.

a) What software should Mr. Guasuka used to build his database and state why.
[2 marks]
b) List three of the database development phase that he will follow.
[3 marks]
c) Based on the answer for question (b) explain one of the phases.
[1 marks]

Answers
a) DBMS, Microsoft Access, Oracle or any suitable answer.
Easy to manage information, retrieve data, easy update information
and other relevant answer
b) Any 3 : Analysis, Design, Implementation, Testing, Documentation and
Maintenance
c) In analysis phase one person has to conducts pulmonary investigation and
identify project title and classify project requirement testing phase try the
database created in implementation phase and correct any errors (other relevant
answer accepted)
-End of Question Paper-