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

2. MIS stands for _____________.

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

3. DSS stands for __________________.

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

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

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

is called _____________________.
a. Information centre
b. Variable
c. DSS
d. Model
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

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

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

a. Model
b. MIS
c. EIS
d. DSS

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

a. field
b. record
c. file
d. database

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

[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

16. Middle-level managers focus on planning ____________

17. A record is made up of files ____________

18. The two steps to create a table are designing its ____________

structure and entering the data.

19. In addition to formatted reports, most database ____________

can be used to produce graphical output, such as
bar graph, line graph and pie chart.

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.

21. A (n) ______________________ is a software package that is used to create and

manage a database. _________________ retrieve data from a database by
presenting criteria that the DBMS uses to select the desired data. It is written
using a ___________________ . _________________________________ is a
standard query language that supported by DBMS.

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
data about a single person makes up that person’s ___________________A
collection or related records makes up a (n) __________________. A
______________ is a collection of related tables.

23. Records in a file are identified by their ______________________, which

contains a unique value for each record. ________________ is a field in another
table that contains the value of primary key.

24. A _____________________________ is a set of business systems designed ti

provide information for decision-making while a ___________________ is a
computer system that supports managers in non-routine decision-making tasks
which involves a __________________ , a mathematical representation of a real-
life situation.

25. The phases of system development are analysis, ____________________,

implementation, ______________________, documentation and
_____________________.
[16 marks]
 SECTION B
Answer all the questions

1. a. Give the definition of Information System.

[1 mark]
b. State 3 fields that use Information System .
i.
ii.
iii.
[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

[2 marks]

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

[2 marks]

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

i.
ii
[2 marks]
b. State the function of each answer in 3(a).
[2 marks]

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

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

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

[2 marks]

b. List two benefit of Database.

[2 marks]
 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]
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 one benefit of using X and the software used to create it.
[2 marks]

c) Explain the meaning of verification and state the method of verification used in
the above system.
[3 marks]

d) State two consequences if the system is hacked by the unauthorized personnel.

[2 marks]
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]

-End of Question Paper-