Get premium membership and access revision papers, questions with answers as well as video lessons.
Information System Development Question Paper
Information System Development
Course:Bachelor Of Science In Information Technology
Institution: Kca University question papers
Exam Year:2010
1
UNIVERSITY EXAMINATIONS: 2009/2010
SECOND YEAR EXAMINATION FOR THE DEGREE OF BACHELOR OF
SCIENCE IN INFORMATION TECHNOLOGY
BIT 2202: INFORMATION SYSTEM DEVELOPMENT
DATE: APRIL 2010 TIME: 2 HOURS
INSTRUCTIONS: Answer question ONE and any other TWO questions
QUESTION ONE (Compulsory)
a) A theatre uses a network of computers for selling tickets from day to day. What type of information
system is the theatre using? (2 Marks)
Link each of these scenarios with one of the following stages of the systems development life Give
reasons for your answers (6 Marks)
i. A network administrator identifies the error rate of his organization’s Internet connection.
ii. A school replaces old computers in the computer room with new ones during the school holidays.
iii. A graphics company identifies some concerns in the way it currently stores and accesses past
customers’ details.
b) Systems analysis is the analysis of a problem that the organization will try to solve with an
information System. Give the four activities involved in the analysis (4 Marks)
c) State and explain four main implementations that can be employed ( 4 Marks)
d) Identify three potential benefits of project management (3 Marks)
e) What tasks are associated with the Cleanroom Strategy? (3 Marks )
f) Examine the following algorithm. What type of data structure is student_name? (2 Marks)
2
g) Describe the CASE system life cycle (6 Marks)
QUESTION TWO
a) MacDonald University offers a number of degree courses for students.
You are required to produce an entity-relationship diagram (ERD) that accurately models the information
below:-
• Each course is managed by a Faculty and consists of a number of
modules. A module may be part of more than one course.
• A Faculty has a unique name, building and director.
• A Course has an ID, title and duration.
• A Module has an ID, title and description.
• A Student has an ID and name.
Include on your diagram: attributes, identifiers and the cardinality of EACH relationship.
Marks will be awarded for:-
i) Correct diagram syntax. ( 3 Marks)
ii) Representation of entities, relationships and attributes. (10 Marks)
iii) Cardinality constraints. ( 3 Marks)
b) State and explain four methods of system maintenance (4 Marks)
QUESTION THREE
a) A computerised machine sorts fruit by weight. It uses a program that directs the fruit through three
different gates according to weight. Below is a small segment of that program. Use it to answer the
questions below.
For student_number ?1 to 25
Read
student_name(student_number)
End for
3
message ! “Fruit is undersized”
fruit_count ! 0
Repeat
good_fruit ! true
Close all gates
Input (fruit_weight)
If (fruit_weight > 30.00) then
Open (gate1)
fruit_count ! fruit_count + 1
Else
If (fruit_weight > 20.00) then
Open (gate2)
fruit_count ! fruit_count + 1
Else
good_fruit ! false
Open (gate3)
Endif
Endif
If not (good_fruit) then
Output (message)
Endif
Until eof ***end of fruit
Output (fruit_count)
i) Identify each variable shown in the table below as one of the following variable types: text, date,
boolean, integer, floating point. (3 Marks)
Variable Type
fruit_count
message
good_fruit
4
ii) The code is to be written as a procedure within a larger program. The programmer decides to name the
procedure ‘mama’ in honour of his mother. Briefly explain why this is a poor choice of name for the
procedure. (3 Marks)
b) Use examples explain three logical constructs of Structured English (9 Marks)
c) Outline at least five software design principles (5 Marks)
QUESTION FOUR
a) Use the following information to construct a context diagram of the World Cup 2010 web system
• Before the World -Cup each country’s officials provide details of all players in their squad and these
are entered into the database.
• During the World Cup the WHF officials provide the statistics during and after each match.
• During the World Cup photographers provide action photographs from each match.
• The public can access the web site and search for information about any player or match or watch video.
• WHF officials can obtain personal information on players not available to the public.
(8 Marks)
b) The following shows part of an un-normalised relation Sales Order.
i. How can you tell the diagram is un-normalised? ( 2 Marks)
ii. Re-draw the relation in First Normal Form (1NF), identifying any key attributes (10 Marks)
QUESTION FIVE
a) State and explain four alternative methods for system building (8 Marks)
b) Describe the stages in the walkthrough Quality Assurance process and the roles of those involved.
(12 Marks)
More Question Papers
Popular Exams
Return to Question Papers