College of Engineering, Science and Technology

School of Mathematical and Computing Sciences

Department of Computer Science and Information System

CIN603 System Analysis & Design

Question Paper/Answer Booklet

Final Examination: Trimester I, 2015

Instructions

Read the following instructions before writing

1. Time Allowed: 3 hours with additional 10 minutes reading time.

2. Question/Answer Booklet: All answers are to be written in the Question/Answer Booklet.

3. Write your ID Number on all the sheets of paper of this Question/Answer Booklet that you

use. Please also number all the extra sheet/pages that you use.

4. Non-programmable calculators are allowed

Sections Question Marks

Section A: Multiple Choice 15 Questions. All compulsory 15
Questions
Section B: Short/Long Answer 10 Questions. All compulsory 35
Questions
Section C: Case Study & Calculation 4 Questions. All compulsory 50
Questions
Total 100

CIN603 System Analysis & Design Trimester 1 2015 Page 1 of 14

 Section A Multiple Choice [15 marks]
Instruction: Identify the choice that best completes the statement or answers the question. Answer to be written in the
space provided on the left side of the particular question.

____ 1. There are different types of questions that can be asked during an interview. Which type is used in
the sample question below?
Are you willing to use the new implemented system?
a. Open question c. Opinion question
b. Closed question d. Threat question

____ 2. The ____ document is the end product of the requirements analysis phase
a. request for proposal c. system requirements
b. request for proposal d. business process

____ 3. If you are using Gane and Sarson Model, what do open-ended boxes represent in data flow
diagrams?
a. process c. data stores
b. external entity d. data flow

____ 4. What is the most likely duration of a task given the following:
Optimistic Duration: 2 days
Pessimistic Duration: 14 days
Expected Duration: 5 days
a. 4 c. 5
b. 6 d. 7

Use the course table given below to answer question (5) (6)

____ 5. In the accompanying figure, identify an attribute that can serve as an ideal primary key for the
course table?
a. course number c. credit hours
b. course description d. department

____ 6. In the accompanying figure, identify an attribute that can serve as an ideal secondary key for the
course table?
a. course number
b. course description
c. All of the above
d. None of the above

CIN603 System Analysis & Design Trimester 1 2015 Page 2 of 14

____ 7. Scope creep refers to ____.
a. rating the importance of each function
b. deferring some functions until later
c. determining the priority of each function
d. requests to add new functions after decisions have been finalized

____ 8. What is Process Modeling?

a. a technique used to organize and document a systems process
b. the number of entities that participate in a relationship
c. the act of breaking a system into sub components
d. a description of activities and services a system must provide

____ 9. A(n) ____ report is useful to upper-level managers who want to focus on total figures rather than
supporting details.
a. summary c. control-break
b. exception d. greenbar

____ 10. In a Data Flow Diagram, a data flow that splits into multiple data flows is
a. converging c. concurrent
b. diverging d. one-way

____ 11. The relationship between an actor and a use case in Use Case Modeling is referred to as
a. Communication c. Relationship
b. Association d. Inheritance

____ 12. How should a process in dataflow diagrams be named?

a. with a descriptive singular noun c. with a strong action verb
b. with plural noun d. All of the above

____ 13. The usual reason for a(n) ____ relationship is where one use case is part of two or more other use
cases
a. <<extends>> c. <<include>>
b. <<depends on>> d. <<entity>>

____ 14. Which of the following is an example of a temporal event?

a. Customer outstanding balance report generated fortnightly
b. A customer places an order
c. Management checks order status
d. Employees process late notices

____ 15. A request for ____ is used when deciding on a specific product that can be acquired from multiple
sources.
a. order c. service
b. proposal d. quotation

CIN603 System Analysis & Design Trimester 1 2015 Page 3 of 14

Section B Short/Long Answer Questions [35 marks]
Instruction: Answer ALL questions in this section in the space provided.

1. Compare and contrast project management and process management? (4 marks)

______________________________________________________
______________________________________________________
______________________________________________________
______________________________________________________
______________________________________________________
_____________________________________________________

2. A subset of the Fact-finding techniques can be used to seek clarification on the requirements that have
been identified in an information systems development project. Identify at least two such techniques,
and explain exactly how you will implement or use the chosen techniques? (4 marks)

______________________________________________________
______________________________________________________
______________________________________________________
______________________________________________________
______________________________________________________
_____________________________________________________

3. The following table shows the relative cost of errors in requirements that were not discovered until
later in the development process.

Phase in Which Error Discovered Cost Ratio

Requirements Analysis 1
Design 36
Coding 10
Development Testing 15 40
Acceptance Testing 30 70
Operation 40 1000

Why is the cost of correcting a fault in Requirement Analysis Phase way less than correcting the same
fault in the Operation Phase? (2 marks)

______________________________________________________
______________________________________________________
______________________________________________________
CIN603 System Analysis & Design Trimester 1 2015 Page 4 of 14
4. Compare and contrast Modern Structured Design Approach and Joint Application Development
Approach for System Design? (4 marks)

______________________________________________________
______________________________________________________
______________________________________________________
______________________________________________________
______________________________________________________
_____________________________________________________

5. Feasibility analysis is the process by which feasibility is measured. Feasibility should be measured
throughout the information systems development lifecycle. Differentiate between Cultural (or
political) and Technical feasibility? (4 marks)

______________________________________________________
______________________________________________________
______________________________________________________
______________________________________________________
_____________________________________________________

6. Explain the two reasons for validating vendor claims after Request for Proposals (RFPs)? (2 marks)

______________________________________________________
______________________________________________________
_____________________________________________________

7. Describe two benefits of a well-designed database? (4 marks)

______________________________________________________
______________________________________________________
______________________________________________________
______________________________________________________
_____________________________________________________

CIN603 System Analysis & Design Trimester 1 2015 Page 5 of 14

8. List and explain the three types of Database integrity enforced by a DBMS? (3 marks)

______________________________________________________
______________________________________________________
______________________________________________________
______________________________________________________
_____________________________________________________

9. You have volunteered to work on the Web site of your local library. The library plans to develop an
online catalog of books that can be reserved by library patrons from their own computes via the
Internet. Discuss two screen design issues that should be taken into considerations. (4 marks)

______________________________________________________
______________________________________________________
______________________________________________________
______________________________________________________
______________________________________________________
_____________________________________________________

10. Explain the four commandments of user interface design? (4 marks)

______________________________________________________
______________________________________________________
______________________________________________________
______________________________________________________
______________________________________________________
_____________________________________________________

CIN603 System Analysis & Design Trimester 1 2015 Page 6 of 14

Section C Case Study & Calculation Questions [50 marks]
Instruction: Answer ALL questions in this section in the space provided.

1. At Zayside Financial, where you work as a project manager, you have been asked to conduct user
training sessions for a new information system. The following table shows the list of tasks, the
estimated task durations and dependencies.

a. Create a PERT chart for the project. (Show tasks preformed, Start Date (SD), End Date (ED), ID,
and duration)? (8 marks)

CIN603 System Analysis & Design Trimester 1 2015 Page 7 of 14

 b. What is the critical path for the project? Explain? (4 marks)

2. Read the problem statement given below very carefully and use it to answer parts (a) (c)

TheEyesHaveIt.com Book Exchange is a type of e-business exchange that does business entirely on
the Internet. The company acts as a clearinghouse for buyers and sellers of used books.

To offer books for sale, a person must register with TheEyesHaveIt.com. The person must provide a
current physical address and telephone number as well as a current e-mail address. The system then
maintains an open account for this person. Access to the system as a seller is through a secure,
authenticated portal. A seller can list books on the system through a special Internet form. The form
asks for all the pertinent information about the book: its category, its general condition, and the
asking price. A seller may list as many books as desired. The system maintains an index of all books
in the system so buyers can use the search engine to search for books. The search engine allows
searches by title, author, category, and keyword.

People who want to buy books come to the site and search for the books they want. When they
decide to buy, they must open an account with a credit card to pay for the books. The system
maintains all this information on secure servers. When a purchase is made, TheEyesHaveIt.com
sends an e-mail notice to the seller of the book that was chosen as well as payment information. It
also marks the book as sold. The system maintains an open order until it receives notice that the
book has been shipped. After the seller receives notice that a listed book has been sold, the seller
must notify the buyer via e-mail within 48 hours that the purchase is noted. Shipment of the order
must be made within 24 hours after the seller sends the notification e-mail. The seller sends a
notification to the buyer and TheEyesHaveIt.com when the shipment is made.

After receiving the notice of shipment, TheEyesHaveIt.com maintains the order in a shipped status.
At the end of each month, a check is mailed to each seller for the book orders that have remained in a
shipped status for 30 days. The 30-day waiting period exists to allow the buyer to notify
TheEyesHaveIt.com if the shipment doesnt arrive for some reason or if the book isnt in the same
condition as advertised. If they want, buyers can enter a service code for the seller. The service code
is an indication of how well the seller is servicing book purchases. Some sellers are very active and
use TheEyesHaveIt.com as a major outlet for selling books. Thus, a service code is an important
indicator to potential buyers

CIN603 System Analysis & Design Trimester 1 2015 Page 8 of 14

 a. Draw a Use-Case Diagram for TheEyesHaveIt.com Book Exchange system? (6 marks)

CIN603 System Analysis & Design Trimester 1 2015 Page 9 of 14

 b. Draw a Context Diagram for TheEyesHaveIt.com Book Exchange system? (8 marks)

CIN603 System Analysis & Design Trimester 1 2015 Page 10 of 14

 c. Draw a Level 0 Data Flow Diagram for TheEyesHaveIt.com Book Exchange system? (8 marks)

CIN603 System Analysis & Design Trimester 1 2015 Page 11 of 14

3. Given below is the Level 1 Data Flow Diagram (DFD) for Download Student Assignments Level 0 process.
This Level 1 Data Flow Diagram shows how the Lecturer downloads completed student assignment using an
online assignment submission system.

Make a Structure Chart for the Level 1 DFD (Lecturer downloads completed Student Assignment)
shown above? (4 marks)

CIN603 System Analysis & Design Trimester 1 2015 Page 12 of 14

4. Given below are the descriptions of the cost and benefits for a new system for Ocean Sound College. You are
to analyze the figures for developing the system in-house(alternative) and use it to answer parts (a) (d)

COST BENEFIT SUMMARY

PLAN A: In-House Development

Year 0 Year 1 Year 2 Year 3 Year 4
Costs:
Consultant time to develop system 6,600
Hardware 3,500
Network upgrades 4,000
Initial training time 300
Office staff maintenance, backup, and update - 5,200 5,200 5,200 5,200
Total Costs: 14,400 5,200 5,200 5,200 5,200
Benefits:
Eliminate overtime - 9,000 9,000 9,000 9,000
Eliminate student position - 3,750 3,750 3,750 3,750
Lost revenue capture - 13,600 13,872 14,149 14,432
Total Benefits: - 26,350 26,622 26,899 27,182

a. Complete the following Net Present Value analysis for developing the system in-house for an
estimated life-time of 4 years? (Assume the discount factor to be 8%)? (7 marks)

Year 0 Year 1 Year 2 Year 3 Year 4

Development cost:
Operation &
Maintenance cost:

Discount factors for 8%:

Present value of annual
costs:
Total present value of
lifetime costs:

Benefits derived from

operation of new
system:

Discount factor for 8%:

Present value of annual
benefits:
Total present value of
lifetime benefits:

CIN603 System Analysis & Design Trimester 1 2015 Page 13 of 14

 b. Find the pay-back period for this investment? (1 marks)

_________________________________________________________
_________________________________________________________

c. Was this a good or bad investment? Why? (2 marks)

_________________________________________________________
_________________________________________________________
_________________________________________________________

d. What is the annual return on investment for the project? (2 marks)

_________________________________________________________
_________________________________________________________
_________________________________________________________

-- The End --
CIN603 System Analysis & Design Trimester 1 2015 Page 14 of 14