f

© Institute for the Management of Information Systems –J.2009.
Page: 1 of 6
DIPLOMA
INFORMATION SYSTEMS
BUILDING
(D 26)
TUESDAY 9TH JUNE 2009
TIME: 14.00 –17.00 HOURS
DURATION : 3 HOURS
Candidates should attempt FIVE questions only. Clearly cross out
‘surplus’ answers; failure to do so will result in the first 5answers being
marked.
No reference material of any kind may be taken into the examination.
[Turn over]
© Institute for the Management of Information Systems –J.2009.
Page: 2 of 6
Candidates should attempt FIVE questions only. Clearly cross out
‘surplus’ answers; failure to do so will result in the first 5 answers being
marked.
Question 1.
A large supermarket chain, Prodco, is about to upgrade its in-store computer
systems. Systems analysts are in the process of fact-finding.
a) Describe THREE different techniques the analysts might use and
comment on the suitability of each for investigating Prodco.
( 9 marks)
When developing models, quality assurance (QA) is of key importance.
b) Describe the stages in the walkthrough QA process and the roles of
those involved. (11 marks)
(Total 20 marks)
Question 2.
Prodco, a large supermarket, have asked you to:-
a) Name and describe the main stages in TWO different systems
development lifecycles that they could use. (12 marks)
b) Discuss the factors, which need to be considered when choosing
the appropriate lifecycle for Prodco. ( 8 marks)
(Total 20 marks)
Question 3.
Computer Assisted Software Engineering (CASE) tools can be used to help
Prodco (a large supermarket chain) designers, develop models for their
organisation.
a) Describe the features that CASE tools provide which could aid
Prodco’s systems development. (12 marks)
b) Describe the advantages and disadvantages of using CASE tools
both to developers and to Prodco. ( 8 marks)
(Total 20 marks)
[Turn over]
© Institute for the Management of Information Systems –J.2009.
Page: 3 of 6
Question 4.
Prodco sells household goods by mail order. The following describes their
sales order system:-
 Customers either fill out an order form and post it, or phone-in the
order to a Prodco salesperson that fills out the form in the office.
 Posted orders are checked when they arrive. Those with errors are
referred back to customers.
All valid orders are checked to see if goods are in stock. Out of stock items
are ordered from suppliers. Back orders need not be considered.
 Orders, which can be filled immediately, are passed on to dispatch
and an invoice sent to the customer.
 Those orders awaiting stock arrivals are checked daily and filled
when stock is available.
a) Using suitable notation, and only considering the details mentioned,
complete this context diagram for the above description.
( 2 marks)
b) Expand this to a level 1 Data Flow Diagram (DFD). Include only
those sub-processes mentioned in the description.
Marks will be awarded for:-
i) Correct diagram syntax. ( 4 marks)
ii) Detailed diagram. ( 8 marks)
iii) Completeness of solution. ( 3 marks)
iv) Clear, easy to follow, well-structured diagram. ( 3 marks)
(Total 20 marks)
[Turn over]
Prodco
Sales
Order
Process
Customers
Suppliers
© Institute for the Management of Information Systems –J.2009.
Page: 4 of 6
Question 5.
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:-
a) Correct diagram syntax. ( 3 marks)
b) Representation of entities, relationships and attributes. (10 marks)
c) Cardinality constraints. ( 3 marks)
d) Clear, easy to follow, well-structured diagram. ( 4 marks)
(Total 20 marks)
[Turn over]
© Institute for the Management of Information Systems –J.2009.
Page: 5 of 6
Question 6.
In the transition from analysis to design, various tasks need to be carried out.
a) With the aid of a diagram, explain how a structure chart is used to
represent program modules. Explain the meaning of all the
notations used. (10 marks)
b) The following shows part of an un-normalised relation Sales Order.
Customer
No
Customer
Name
Telephone
Number
Order
No
Order Date Item
Description
Item
Code
Quantity
Ordered
001 Smith 12345 01 01/02/2008 Shoe Sh2 20
003 Jones 43551 02 02/02/2008 Blouse Bl6 10
001 Smith 12345 03 04/03/2008 Blouse Bl6 15
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. ( 8 marks)
(Total 20 marks)
Question 7.
Prodco has an Internet company selling CDs and DVDs. They charge for
delivery as follows:-
Any order valued £75 or more is delivered free. Orders valued less than £75
are charged by the number of items and type of delivery. Three items or less
costs £3.50 for standard or £5.00 for next day delivery. Four items or more
costs £5.50 for standard and £7.00 for next day delivery.
a) What aspects of this process makes the use of a decision table
appropriate? ( 2 marks)
b) Draw a decision table for the process. (10 marks)
c) Write an algorithm for the process using structured English.
( 8 marks)
(Total 20 marks)
[Turn over]
© Institute for the Management of Information Systems –J.2009.
Page: 6 of 6
Question 8.
Prodco system developers have both ethical and professional responsibilities
towards clients, fellow staff and wider society.
a) Discuss the ethical issues which may arise for their system
developer. (10 marks)
b) Discuss the ways in which the developer can maintain the highest
standard of professionalism. (10 marks)
(Total 20 marks)
END OF EXAMINATION.
© Institute for the Management of Information Systems –J.2009.
Page 1 of 7
D 26 –INFORMATION SYSTEMS BUILDING JUNE 2009
SOLUTIONS & MARKING SCHEME.
Question 1 answer.
a) Fact finding techniques:-
Interview.
Questionnaire.
Observation.
Document analysis.
Brainstorming.
Any (3x1) + description (3x1) + suitability (3x1).
e.g. Questionnaire can be sent to staff at a selection of stores
geographically remote.
(9 marks)
b) Walkthrough stages:-
Develop model.
Prepare for walkthrough.
Carry out walkthrough.
Action list.
Amend model.
Prepare review documents.
Review/plan for next stage.
Any (6x1).
Roles:-
Leader –e.g. organise, control meeting.
Secretary –e.g. record issues, prepare report.
Reader/Producer - e.g. describe product, elaborate.
(3x1) roles + (2x1) tasks. (11 marks)
(Total 20 marks)
Question 2 answer.
a) Possible lifecycles:-
Traditional/Waterfall
Concept formation (Initiation)/Feasibility/ (Requirements)
Analysis/Design/
Implementation/Testing (Installation)/Maintenance (Review).
Linear sequence/phase completed before next one starts.
Prototyping
Basic initial system developed.
Experimentation by users and developers.
Model refined.
RAD/DSDM
Incorporate JAD.
Early feedback to users.
Phases overlap.
Evolutionary/Spiral
Series of development cycles.
Requirements/Risk Analysis/Design/Develop/Prototype ready.
Each cycle grows/evolves from previous one.
Any 12x1 phases/features identified or diagram. (12 marks)
} repeatedly
}repeat
© Institute for the Management of Information Systems –J.2009.
Page 2 of 7
b) Factors:-
System structure.
Linear suited to well understood, highly structured problems.
Evolutionary suited to ‘new’, unstructured problems.
Familiarity with technology.
Better predictions/able to plan ahead if familiar.
Need experimentation, build user confidence if not.
Project size/nature.
Need for quick results, ability to break project into sub systems.
Any 8x1 points identified. (8 marks)
(Total 20 marks)
Question 3 answer.
a) Features
Any 1 x12 points mentioned (or 6x2 for examples or explanations).
Repository/central database/data dictionary/error checking/completeness
checks/consistency checks diagram tools/produce ERD/convert between
stages/identify relationships/generate documentation/interface
generation/group working/version control/others. (max 12 marks)
b) Advantages
Any 1 x 8 points mentioned (or 4x2 as above).
Automation of tedious tasks/consistency/easier to update/better
maintenance/prototyping possible/alternative designs easier to
develop/communication with users/continuity with changing
staff/standardisation/quality assurance/systematic testing.
Disadvantages
Cost of installation/training required/and maintenance tools may have
limited scope/multiple tools required/over reliance/no guarantee of
accuracy. (8 marks)
(Total 20 marks)
© Institute for the Management of Information Systems –J.2009.
Page 3 of 7
Question 4 answer.
a)
2 marks for arrowed processes
(2 marks)
b)
Marks will be awarded for:-
i) Correct diagram syntax
4x1 correct symbols with suitable text
(4 marks)
ii) Detailed diagram
8x1 correct elements (or equivalent) seen anywhere (8 marks)
iii) Completeness of solution
2 marks for 4 suitable processes, 1 mark for 2 suitable processes
(3 marks)
iv) Clear, easy to follow, well-structured diagram
(3 marks)
(Total 20 marks)
process data flow entity data store
referral
Customer
Prodco
Sales Order
Process
stock order Supplier
1.0
Receive
orders
2.0
Check
orders
3.0
refer
Valid orders
stock
Customer
Valid
orders
Error
orders
Stock
level
invoice
Alternatives/
additions
possible
Phone orders
details
Order
items
Suppliers
order
invoice
order
details
written orders
details
Out of stock
order
4.0
Check
stock
5.0
dispatch
items
In stock
Order
items
Referred
order
© Institute for the Management of Information Systems –J.2009.
Page 4 of 7
Question 5 answer.
Marks to be awarded as follows:-
a) Correct diagram syntax
3x1 correct symbols with suitable text
(3 marks)
b) Representation of entities, relationships and attributes
Three relationships (or equivalent) of
Faculty manages Course (2)
Course consists of Modules (2)
Student enrols on Course (2)
Correct attributes (at least two) for each entity 4x1 (10 marks)
c) Cardinality constraints 3x1 (3 marks)
d) Clear, easy to follow, well-structured diagram
Single diagram (1)
Easy to follow (1)
Neatness (2) which includes straight lines (4 marks)
(Total 20 marks)
entity attribute relationship
Enrols on manages
studID
STUDENT
studName
m
Consists of
n
m
COURSE m
courseTitle duration
courseID
MODULE
modTitle description modID
FACULTY
facName building director
1 1
© Institute for the Management of Information Systems –J.2009.
Page 5 of 7
Question 6 answer.
a) Components named.
Program module (rectangle).
Connection (lines between modules).
Coupling (arrows).
Decision (diamond).
Repetition (looping arrow). (any 6x1)
Symbols correctly used (any 4x1)
(10 marks)
b)
i) Repeated group (1) CustNo, CustNam, CustTel (1)
ii) Customer(CustNo, CustNam, CustTel) (3)
Order(OrderNo, Date, ItemCode, Desc,Qty, CustNo (foreign key))
(5)
( 10 marks)
(Total 20 marks)
Question 7 answer.
a) Process has a number of conditions (1) with a number of options (1).
(2 marks)
b)
Rules
Sale Value <£75 >=£75
Conditions (1) No of items (1) <=3 >3 <=3 >3
Delivery Type (1) S N S N S N S N
Actions (1) Charge Free (1) X X X X
Charge £3.50 (1) X
Charge £5.00 (1) X
Charge £5.50 (1) X
Charge £7.00 (1) X
(9 marks)
Broadly 1 mark for the grid and one for each correct entry
MAIN
T1 Do That T2 Do This
Do Simple Do This
x
© Institute for the Management of Information Systems –J.2009.
Page 6 of 7
c) if SV>=75 then key SV Sale Value
charge=0 D Delivery Type
else S Standard
if I<=3 then I Items
if D=S then
charge=£3.50
else
charge=£5.00
end if
else
if D=S then
charge=£5.50
else
charge=£7.00
end if
end if
end if
(9 marks)
Broadly 1 mark for the non ”else” line and one for each correct line
(Total 20 marks)
Question 8 answer.
Allow overlap of points between a) and b). Marks can be distributed between
point made and expansion –at least 4 points per section.
Issues could be:-
Employment.
De-skilling/skilling.
Digital divide/accessibility.
Privacy.
Data Protection (Act).
Computer Misuse (Act) or similar.
a)
Hacking.
Piracy.
Copyright/Patents/Trademarks.
Human rights. (10 marks)
b) Membership of professional bodies (e.g. IMIS).
Keep knowledge and skills up-to-date.
Be aware of latest relevant legislation.
Act in client’s best interest.
Support fellow team members.
Act in an appropriate manner to clients/fellow professionals.
Others possible.
(10 marks)
(Total 20 marks)
© Institute for the Management of Information Systems –J.2009.
Page 7 of 7
Reading references:
[1] Main course text:
Hawryszkiewycz, I (2001)
Introduction to Systems Analysis & Design (5th Ed.)
Pearson Education. ISBN: 1740092805
[2] Secondary course text:
Bocij, P., Chaffey, D., Greasley, A. & Hickie, S (2003)
Business Information Systems: Technology, Development &
Management for the e-Business (2nd Ed.)
Pearson Education. ISBN: 027365540X
Question
No.
Learning
outcome
References
1 LO4
LO7
Fact finding [1] Ch. 4
System Development Testing [1] Ch 20
2 LO2 Development Process [1] Ch. 5
Alternatives
3 LO8 Case Tools [1] Ch. 6
4 LO5 Data Flow Diagrams [1] Ch. 8
LO9 Case Study [1] Case 1
5 LO5 Describing Data (ERDs) [1] Ch. 9
6 LO6 Structured Design [1] Ch. 16
[2] Ch. 11
7 LO7 Decision Tables [1] Ch. 10 [2] Ch. 11
8 LO12 Ethics, Legal, Moral [2] Ch. 17