System Analysis & Design PDF

Preview

Summary

SECTION A. MULTIPLE CHOICE QUESTIONS Read and Choose the Best Answer. Write your Answer in the Answer Booklet. 1. The process of ensuring that the information system is operational and allowing users to take over its operation is called : A. system Implementation B. production C. system Planning D. ...

Description

SECTION A.

MULTIPLE CHOICE QUESTIONS

[20 MARKS]

Read and Choose the Best Answer. Write your Answer in the Answer Booklet.

1. The process of ensuring that the information system is operational and allowing users to take over its operation is called : A.

system Implementation

B.

production

C.

system Planning

D.

user Training

2. Which graphically characterize(s) processes and data flows through a business system? A.

structured analysis

B.

data flow diagrams

C.

data dictionary

D.

design

3. Which of these is a potential training source? A.

external paid trainers

B.

in-house trainers

C.

systems analysts

D.

all of the above

1

4. When Data Flow Diagrams (DFD)s are drawn, which of the following conventions should be followed?

I.

each context diagram must fit on one page

II.

use the same names within each set of symbols

III.

do not cross lines

IV.

use a unique reference number for each process symbol

A.

I, II and III

B.

I, II and IV

C.

I, III and IV

D.

II, III and IV

5. ___________ maintains consistency among DFDs by ensuring that input and output data flows align properly.

A.

Balancing

B.

Levelling

C.

Indexing

D.

Exploding

6. Using _________, an analyst starts with an overall view, which is a context diagram with a single process symbol, and then the analyst creates diagram 0, which shows more detail.

A.

balancing

B.

levelling

C.

indexing

D.

exploding

2

7. Because Diagram 0 is a(n) _____________ version of process 0, it shows considerably more detail than a context diagram.

A.

contracted

B.

condensed

C.

exploded

D.

extrapolated

8. Process logic may be represented as a:

A.

structured english

B.

decision table

C.

decision tree

D.

All of the above

9. In a decision table, contradictions occur when:

A.

identical sets of alternatives require the same action.

B.

rules suggest different actions but satisfy the same conditions.

C.

the situation cannot occur because there are two or more conditions that cannot occur at the same time.

D.

an important condition is omitted.

10. Goal of producing process specifications is to:

A.

reduce process interactions.

B.

validate the system design, including data flow diagrams and the data dictionary.

C.

build technical specifications for a specific computer language.

D.

design computer input and output processes. 3

11. The type of module that is found low in the structure chart and performs only one task is called

A.

control module.

B.

transformational module.

C.

functional module.

D.

all of the above.

12. Good interface design is based partly on ________, which focuses on how an interface can be made attractive and easy to use.

A.

aesthetics

B.

interface technology

C.

ergonomics

D.

output security

13. Input ________ are templates that make it easier for users to enter data.

A.

patterns

B.

masks

C.

legends

D.

keys

14. For upper-level managers who often want to see total figures and do not need supporting details, a(n) ________ is appropriate.

A.

detail report

B.

exception report

C.

summary report

D

all of the above

4

15. A range check is a data validation check that ________. A.

tests data items to verify that they fall between a specified minimum and maximum value

B.

identifies values that are questionable, but not necessarily wrong

C

is performed on two or more fields to ensure that they are consistent or reasonable when considered together

D.

is used for mandatory data items

16. In sequence, the four steps typically followed to create a structure chart are ____.

A.

review the DFDs; identify modules and relationships; add couples, loops, and conditions; analyze the structure chart and the data dictionary

B.

identify modules and relationships; add couples, loops, and conditions; analyze the structure chart and the data dictionary; review the DFDs

C.

add couples, loops, and conditions; analyze the structure chart and the data dictionary; review the DFDs; identify modules and relationships

D.

analyze the structure chart and the data dictionary; review the DFDs; identify modules and relationships; add couples, loops, and conditions

17. Successful completion of system testing is the key to user and management approval, which is why system tests sometimes are called ____.

A.

implementation tests

B.

modular tests

C.

structure tests

D.

acceptance tests

5

18. Greater user involvement in the system development process usually results in ____.

A.

poorer communication

B.

more satisfied users

C.

slower development times

D.

both b and c

19. The testing of an individual module is called ____ testing.

A.

modular

B.

beta

C.

integrated

D.

unit

20. The __________ approach causes the changeover from the old system to the new system to occur immediately when the new system becomes operational.

A.

phased operation beta

B.

parallel operation unit

C.

pilot operation

D.

direct cutover

6

SECTION B.

TRUE / FALSE.

[10 MARKS]

Read Each Statement and Write Your Answer as True OR False in the Answer Booklet.

1)

While process specifications produce a precise description of what is accomplished, they are not detailed enough to validate the system design. F

2)

It is useful to combine conditions and actions when drawing decision trees. F

3)

Later in the systems design phase, you build a logical model that describes how a system will be constructed. F

4)

When a DFD is exploded, the higher-level diagram is called the child diagram, and the lowerlevel diagram is referred to as the parent diagram. F

5)

When designing an interface, to provide features that promote efficiency use default values if the majority of values in a field are the same. T

6)

System sign-on procedures should allow unauthorized individuals to enter the system, and users should change their passwords rarely. F

7)

When a context diagram is expanded into DFD diagram 0, all the connections that flow into and out of process 0 must be retained. T

8)

Phased operation is more expensive than full parallel operation because the entire system must be worked with at a time. F

9)

To develop a user-centred interface, a designer must learn to think like a user and see the system through a user’s eyes. T

10)

Parallel operation is the least costly change over method. F 7

SECTION C.

STRUCTURED QUESTIONS

[48 MARKS]

Choose and Answer ONLY FOUR(4) Questions From This Section in the answer booklet.

1. Assuming your development team has came out with the physical data flow diagram (i.e., Level 0) of Web-based Ordering System for one client as shows in Figure 1 below. As a Junior System Analyst, the project leader wants you to:

Inventory Department Control

Pending 3.0

Order record

D3

Order File

Produce Picking Slips Updated item record

Back-ordered item record

1.0 Order picking list

D2

Add Customer Order

Item Master File

Updated customer record

Warehouse

4.0 D1

Prepare Shipping Statement

Order goods

5.0

Customer Master File

New customer record

Customer shipping statement

Customer order

2.0 Ship Customer Order Customer name and address

Shipment details

Add Customer Record

New customer information Customer

Figure 1: Physical Data Flow Diagram 0 of Web-based Ordering System

8

a) Explode the child diagram for Process 2.0 – Add Customer Record that adds a new customer if he or she is not currently in the database (i.e., has never ordered before). (6 marks)

2.1 New customer information Record Customer Information

2.2

Recorded customer information

Store Customer Record

New customer record

D1

Customer Master File

** Data flow of ‘new customer information’ and ‘new customer record’, and data store of ‘D1 Customer master file’ must be balanced (appeared) in this diagram. 1 mark for each one = 3 mark ** 1 mark each from Process 2.1 and 2.2 (doesn’t matter the name of the process) = 2 mark **1 mark from ‘recorded customer information’ data flow b) Partition the Figure 1 by grouping and separating processes (e.g., online program, batch program, manual etc) as you feel appropriate. Explain why do you partitioned the data flow in this manner. (Use APPENDIX A attached at the end of this exam paper). (6 marks)

9

Inventory Department Control

Pending 3.0

Order record

D3

Order File

Produce Picking Slips Updated item record

Back-ordered item record

1.0 Order picking list

D2

Add Customer Order

Item Master File Item record

Updated customer record

Warehouse

Customer order record

4.0 D1

Prepare Shipping Statement

Order goods

5.0

Customer Master File

New customer record

Customer shipping statement

Customer order

2.0 Ship Customer Order Customer name and address

Shipment details

Add Customer Record

New customer information Customer

1. Process 1.0 and 2.0 must be conducted in one program (online program) (1 mark) Justification: The customer would be added when placing an order (1 mark) 2. Process 3.0 must be performed in separate program (as batch-process) (1 mark) Justification: it has computer input and computer output, and performed at different time from other processes (1 mark) 3. Process 4.0 must be performed in separate program (as batch-process) (1 mark) Justification: it has computer input and computer output, and performed at different time from other processes (1 mark)

10

2. The interface in figure2 below illustrates the form to enter the record of reference materials via Research Collection System. Is it a good interface design for a form? State your arguments. (12 marks)

It is a good interface design.

3 marks

Input controls are used.

3 marks

They are: text box, (2) list box, (3) radio button that ease the data entry.

4 marks

Hence, it reduces input errors by users. 2 marks

Figure2: Physical interface of record reference materials

3.

A new public library at Taman Sri Skudai allows its members to order new books using a computer system. This computer system involves two entities only, namely members of libraries and book suppliers. Prospective borrowers of books should give profile to a computer system and they are informed of the lending regulation. While searching for requested book, they are presented with a book catalogue. The borrower could request to purchase it if the 11

requested books are not available in the library. The management of this library gets a catalogue of books after making request to the book suppliers. Eventually, new books are added to the library. Draw the context and level 0 diagram. (12 marks)

5 MARKS

7 MARKS 12

4.

“Just a little longer . . . I want to be sure this is working correctly before I change over,” says Anita, the owner of three bathroom accessories boutiques called BuTik ’n Stuff. Her accountant, who helped her set up a new accounting information system, is desperately trying to persuade Anita to change over completely to the new system. Anita has insisted on running the old and new systems in parallel for an entire year.

a. Briefly describe the general problems involved in using a parallel conversion strategy for implementing a new information system.

(6 marks) a.

Some of the general problems that can be encountered with a parallel conversion strategy for implementing a new information system are:

1)

the cost of running two systems at the same time

2)

double work load

3)

difficulty of making comparisons with output from the old system

4)

refusal to convert to the new system entirely because of familiarity with the old system

b. In a paragraph, try to convince the owner of BuTik ’n Stuff that a year of running a system in parallel is long enough. Suggest a way to end BuTik ’n Stuff dual systems that will provide enough reassurance to Anita. (Assume the new system is reliable.) (6 marks)

b.

Running the system in parallel for a year has been very expensive. To be fully assured that the new system is running well and is reliable enough, a postimplementation test can be conducted. If the system passes the evaluation test, it should be safe enough to stop using the old system.

13

5.

Prepare a decision table for a batch update of the COMPUTER MASTER file below: (12 marks) There are three types of updates: Add, Delete, and Change. The COMPUTER MASTER record must be read. If the transaction is an Add and the master is not found, format and write the new COMPUTER MASTER record. Print a valid transaction line on an UPDATE REPORT. For a Change or Delete transaction, print a CHANGE ERROR LINE or a DELETE ERROR LINE if the COMPUTER MASTER record is not found. If the COMPUTER MASTER record is found, check the active code. If the record is inactive and the transaction is an Add, format and rewrite the new COMPUTER MASTER record. Print a valid transaction line on an UPDATE REPORT. For a Change or Delete transaction, print a CHANGE ERROR LINE or a DELETE ERROR LINE. If the COMPUTER MASTER record is active and the transaction is an Add, print an ADD ERROR LINE. For a Change transaction, format the changes and rewrite the COMPUTER MASTER record. Print the VALID TRANSACTION LINE. For a Delete transaction, change the ACTIVE CODE to inactive and rewrite the COMPUTER MASTER record. Print the VALID TRANSACTION LINE.

One option of the solution : (12 marks maximum) Decision Table Conditions and Actions

1

2

3

4

5

6

7

8

9

Type of transaction

A

A

A

D

D

D

C

C

C

Microcomputer Master record found

N

Y

Y

N

Y

Y

N

Y

Y

N

Y

N

Y

N

Y

Microcomputer Master record is active Format new Microcomputer record

X

X

Change Microcomputer record

X

Delete Microcomputer record

X X

Print ‘Add error’ line

X

Print ‘Delete error’ line

X X

Print ‘Change error’ line Print ‘Valid transaction’ line

X

Write New Microcomputer record

X

Rewrite New Microcomputer record Codes are:

X

X

X

X

X

X

X

A - Add Microcomputer D - Delete Microcomputer C - Change Microcomputer 14

6.

Figure 3 below shows the level 0 diagram of a Course Registration System in a particular (12 marks)

university. Convert the data flow diagram into a structure chart.

P ayment Student

Class Request

Receipt

2

1

P ayment Information Collect Student Fee P ayment

Enroll Student In Course

Student Class Record Student and Course Data

D1

Student Class Records

Student Class Record

Student Class Record

3

4

P roduce Student Schedule

Student

Figure 3.

Student Payments

Student Class Record

5

P roduce Class Roster

Student Schedule

D2

Class Roster

P rofessor

P roduce Enrollment Summary Report

Enrollment Statistics

Registrar

Data Flow Diagram Level 0 of Student Course Registration

15

SC HEM A FIN A L EXA M SEM1 20 1 1/2 01 2

C OU R SE R EG ISTR A TION SY S TEM

Class Request

Payment

Student Class Record

Student Class record

Receipt

En ro ll St u d ent in C o urse

Student Schedule

Pro duce St udent Schedule

Co llect St ud ent fee Pa y ment

Class Roster

Enrollment Statistic Student Class Record

Pro d uce Cla ss R o st er

Pro dud uce En ro llment R epo rt

Student and Course Data Student Class Record

PU T Stud ent a nd Co urse Data

GET St ud ent Cla ss R eco rd

Payment Information

PU T Pa y men t In fo rma tio n

All Correct conversion of DFD process into modules = 6 marks All Correct conversion of data flows and data fi...