Body:
MSC(IT) Second Sem Assignment Questions
System Structure Analysis and Design
Assignment A :
| |
|
S. No.
|
Questions
|
Marks - 10
|
|
|
|
|
1 .
|
Briefly explain the procedure and make up of the post-implementation review. Can one
perform maintenance on a system without a post-implementation review? Why?
|
|
|
|
2 .
|
How does normalization reduce data redundancy? Illustrate
|
|
|
|
3 .
|
What do you mean by system audit? Explain.
|
|
|
|
4 .
|
How functional dependency is related to database table design?
|
|
|
|
5 .
|
What are some of the advantages of top-down design? Elaborate.
|
|
|
|
6 .
|
An international airline initiated a frequent traveler program designed to encourage passengers
to fly regularly and earn awards based on miles flown. The airline policy is as follows:
Passengers who fly more than 1 lakh miles per calendar year and, in addition, pay cash for
tickets or have been flying the airline regularly for more than 5 years are to receive a free roundtrip
ticket around the world. Passengers who fly less than 1 lakh miles per calendar year and have
been flying the airline regularly for more than 5 years also get a free round trip ticket around the
world.
Draw a decision table based on the above.
|
|
Assignment B:
Case Detail :
Case Study
A problematic conversion to a new software system for managing staff and Shipping operations
at Sealine Inc. to a halt, resulting in passengers stranded in cities such as New York, Detroit and
Palm Beach, Florida. The system-wide problems forced the Fort Lauderdale, Florida - based
discount shipping to book all available hotel rooms in many markets and to institute a nationwide
disaster response program.
Sealine Inc president and CEO Thomas konchesky said the crisis wasn't touched off by the new
system crashing or other technical problem. Instead, the problem were caused by a lack of
familiarity with the software on the part of Sealine's employees-situation that snowballed at the
Shipping after winter storms affected sea travel in the northeast.
While the new scheduling system had been run in parallel with the sealine old one from August
through the end of the last year, Thomas said users could not negotiate the software fast enough
to keep pace after the storms began forcing Ship cancellations. "The people who operated the
software were not longer as fast with it, even though they were proficient and they were trained",
Thomas said "It's one of those situations where your fingers are not connected to your brain
anymore, and we were not prepared for that". Ships were also booked to capacity because of the
crush of holiday travellers, making it more difficult to accommodate stranded passengers after
the problems emerged, he said.
Compounding the situation even further was the fact that Sealines's CIO post is vacant, said
Thomas, who held that position until he was promoted to CEO in mid-2000. The Shipping began
interviewing potential CIO candidates last month but has yet to hire a replacement. A hands-on
IT executive might have been able to foresee the impending crisis and steer Sealine's crew
staffing department away from doing the software conversion at such a busy travel time, Thomas
said. "The only way we could have avoided this problem was to have called off the conversion",
he said. "But we obviously didn't see the problem coming".
Paul harnandez, an analyst at Forrester Research who follows the travel industry, faulted Sealine
for its timing. "You never want to do a cutover to a new software system during a peak travel
period", he said. Sealine's staffing department wanted the conversion to occur January 1 because
the Sealine needs to track Captain and crew Sail hours on a calendar bases in order to ensure that
workers don't exceed sailing limits set by the U.S. federal Sail Administration. Making the
switch a week or two later would have required the initial records for this year to be moved from
the old system to the new one.
"Up until now, it's been our policy to let individual departments manage their own projects and
not involve the IT department", Thomas said. "That's going to change. We need to have our tech
people more involved". Paul said such a hang-off IT policy is receipt for danger. "You don't
mess around the technology", he said. "It is not kind to the people who don't understand it".
System Analysis & Design
Thomas said the Sealine will have to spend at least the rest of month trying to win back
passengers who were inconvenienced by the problems. Sealine, the largest privately held shiping
in the U.S, carried more than 2,00,000 passengers last year.
The Sealine will also have to mend its relationship with the New York and the New Jersey Port
authority, which is considering pulling Sealine's docking permits at the LaGuardia and Newark
docks in the back of the ordeal. Port authority spokesman Stewon Coleman said that at one point.
New York police were called to La Guardia to claim an unruly crowd of disgruntled passengers.
"There were some near fist fights between some of the passengers who'd just had enough", he
said.
The crisis also will lead to organizational restructuring at Sealine. Konchesky said, although he
added that specific changes haven't been decided on. A week ago, the sealine announced that it
had returned to "business-as-usual operation". Thomas said the new software remains in place.
"It was a matter of knowing how to use it", he said.
- What major problems in system implementation and conversion practices do you recognize in this case? What major management problems do you recognize in this case?
|
2.
|
What should Sealine Shipping’s have done to avoid its system problems? What steps should
they take now?
|
|
|
3.
|
Please answer the following:
a) What are the pros & cons of waterfall model?
b) Summarize the advantages and limitations of Interviews and Questionnaires.
c) Discuss the multifaceted role of the system analyst.
d) Explain the major activities in conversion. Which activity is the most important? Why?
e) Discuss the concepts of MIS and DSS. How are they related? How do they differ?
|
|
Assignment C:
| |
|
|
Question No. 1
|
Marks - 10
|
|
|
|
How many steps are in the systems development life cycle (SDLC)?
|
|
|
|
|
Options
|
|
| |
|
|
4
|
|
|
5
|
|
|
6
|
|
|
10
|
|
|
|
Question No. 2
|
Marks - 10
|
|
|
|
The first step in the systems development life cycle (SDLC) is:
|
|
|
|
|
Options
|
|
| |
|
|
Analysis.
|
|
|
Design.
|
|
|
Problem/Opportunity Identification.
|
|
|
Development and Documentation.
|
|
|
| |
|
|
Question No. 3
|
Marks - 10
|
|
|
|
Most modern software applications enable you to customize and automate various features using small custom-built
miniprograms called:
|
|
|
|
|
Options
|
|
| |
|
|
macros.
|
|
|
Code
|
|
|
routines.
|
|
|
subroutines.
|
|
|
| |
|
|
Question No. 4
|
Marks - 10
|
|
|
|
The organized process or set of steps that needs to be followed to develop an information system is known as the:
|
|
|
|
|
Options
|
|
| |
|
|
analytical cycle.
|
|
|
design cycle.
|
|
|
program specification.
|
|
|
system development life cycle.
|
|
|
| |
|
|
Question No. 5
|
Marks - 10
|
|
|
|
How many steps are in the program development life cycle (PDLC)?
|
|
|
|
|
Options
|
|
| |
|
|
4
|
|
|
5
|
|
|
6
|
|
|
10
|
|
|
|
Question No. 6
|
Marks - 10
|
|
|
|
The make-or-buy decision is associated with the ____________ step in the SDLC.
|
|
|
|
|
Options
|
|
| |
|
|
Problem/Opportunity Identification
|
|
|
Design
|
|
|
Analysis
|
|
|
Development and Documentation
|
|
|
|
Question No. 7
|
Marks - 10
|
|
|
|
In the Analysis phase, the development of the ____________ occurs, which is a clear statement of the goals and objectives of the
project.
|
|
|
|
|
Options
|
|
| |
|
|
documentation
|
|
|
flowchart
|
|
|
program specification
|
|
|
design
|
|
|
| |
|
|
Question No. 8
|
Marks - 10
|
|
|
|
Actual programming of software code is done during the ____________ step in the SDLC.
|
|
|
|
|
Options
|
|
| |
|
|
Maintenance and Evaluation
|
|
|
Design
|
|
|
Analysis
|
|
|
Development and Documentation
|
|
|
| |
|
|
Question No. 9
|
Marks - 10
|
|
|
|
Enhancements, upgrades, and bug fixes are done during the ____________ step in the SDLC.
|
|
|
|
|
Options
|
|
| |
|
|
Maintenance and Evaluation
|
|
|
Problem/Opportunity Identification
|
|
|
Design
|
|
|
Development and Documentation
|
|
|
|
Question No. 10
|
Marks - 10
|
|
|
|
The ____________ determines whether the project should go forward.
|
|
|
|
|
Options
|
|
| |
|
|
feasibility assessment
|
|
|
opportunity identification
|
|
|
system evaluation
|
|
|
program specification
|
|
|
|
Question No. 11
|
Marks - 10
|
|
|
|
Technical writers generally provide the ____________ for the new system.
|
|
|
|
|
Options
|
|
| |
|
|
programs
|
|
|
network
|
|
|
analysis
|
|
|
documentation
|
|
|
|
Question No. 12
|
Marks - 10
|
|
|
|
____________ design and implement database structures.
|
|
|
|
|
Options
|
|
| |
|
|
Programmers
|
|
|
Project managers
|
|
|
Technical writers
|
|
|
Database administrators
|
|
|
| |
|
|
Question No. 13
|
Marks - 10
|
|
|
|
____________ spend most of their time in the beginning stages of the SDLC, talking
with end-users, gathering information, documenting systems, and proposing solutions.
|
|
|
|
|
Options
|
|
| |
|
|
Systems analysts
|
|
|
Project managers
|
|
|
Network engineers
|
|
|
Database administrators
|
|
|
| |
|
|
Question No. 14
|
Marks - 10
|
|
|
|
Which of the following could not be considered an organisational goal?
|
|
|
|
|
Options
|
|
| |
|
|
Increase company profit margin.
|
|
|
Expand customer base.
|
|
|
Provide quality service.
|
|
|
Complete backups every Friday.
|
|
|
| |
|
|
Question No. 15
|
Marks - 10
|
|
|
|
An organisations goal is to improve the communication of events to members. Which of the following strategies would best achieve
this aim?
|
|
|
|
|
Options
|
|
| |
|
|
Reduce labour costs.
|
|
|
Produce a regular newsletter.
|
|
|
Make sure all membership information is accurate.
|
|
|
Use a spreadsheet to keep track of finances.
|
|
|
|
Question No. 16
|
Marks - 10
|
|
|
|
The profile of an audience can include its
|
|
|
|
|
Options
|
|
| |
|
|
Employment category, income level and average age.
|
|
|
Employment category, favourite colour and average age.
|
|
|
Tax file number, income level and years of employment.
|
|
|
Educational level, Medicare number and name of doctor.
|
|
|
| |
|
|
Question No. 17
|
Marks - 10
|
|
|
|
Which of the following is not a component of an information system?
|
|
|
|
|
Options
|
|
| |
|
|
Equipment
|
|
|
End-user
|
|
|
Organisational goals
|
|
|
Procedures
|
|
|
|
Question No. 18
|
Marks - 10
|
|
|
|
____________ manage the system development, assign staff, manage the budget and reporting, and ensure that deadlines are met.
|
|
|
|
|
Options
|
|
| |
|
|
Project managers
|
|
|
Network engineers
|
|
|
Graphic designers
|
|
|
Systems analysts
|
|
|
|
Question No. 19
|
Marks - 10
|
|
|
|
____________ is the process of translating a task into a series of commands that a computer will use to perform that task.
|
|
|
|
|
Options
|
|
| |
|
|
Project design
|
|
|
Installation
|
|
|
Systems analysis
|
|
|
Programming
|
|
|
| |
|
|
Question No. 20
|
Marks - 10
|
|
|
|
Debugging is:
|
|
|
|
|
Options
|
|
| |
|
|
creating program code.
|
|
|
finding and correcting errors in the program code.`
|
|
|
identifying the task to be computerized.
|
|
|
creating the algorithm.
|
|
|
| |
|
|
Question No. 21
|
Marks - 10
|
|
|
|
Translating the problem statement into a series of sequential steps describing what the program must do is known as:
|
|
|
|
|
Options
|
|
| |
|
|
coding.
|
|
|
debugging.
|
|
|
creating the algorithm.
|
|
|
writing documentation.
|
|
|
| |
|
|
Question No. 22
|
Marks - 10
|
|
|
|
Translating the algorithm into a programming language occurs at the ____________ step of the PDLC.
|
|
|
|
|
Options
|
|
| |
|
|
Debugging
|
|
|
Coding
|
|
|
Testing and Documentation
|
|
|
Algorithm Development
|
|
|
| |
|
|
Question No. 23
|
Marks - 10
|
|
|
|
The problem statement should include all of the following EXCEPT:
|
|
|
|
|
Options
|
|
| |
|
|
input.
|
|
|
output.
|
|
|
processing.
|
|
|
storage.
|
|
|
| |
|
|
Question No. 24
|
Marks - 10
|
|
|
|
The problem statement includes the ____________, which lists specific input numbers a program would typically expect the user to
enter and precise output values that a perfect program would return for those input values.
|
|
|
|
|
Options
|
|
| |
|
|
testing plan
|
|
|
error handler
|
|
|
IPO cycle
|
|
|
input-output specification
|
|
|
| |
|
|
Question No. 25
|
Marks - 10
|
|
|
|
Which step of SDLC performs cost/benefit analysis?
|
|
|
|
|
Options
|
|
| |
|
|
Feasibility Study
|
|
|
Analysis
|
|
|
Design
|
|
|
None of the above
|
|
|
|
Question No. 26
|
Marks - 10
|
|
|
|
System maintenance is necessary because:
|
|
|
|
|
Options
|
|
| |
|
|
Human never gets it right the first time.
|
|
|
The deployment may change over time.
|
|
|
The user’s needs may change over time.
|
|
|
All of the above.
|
|
|
| |
|
|
Question No. 27
|
Marks - 10
|
|
|
|
A person-machine system and a highly integrated grouping of information-processing functions designed to provide management
with a comprehensive picture of specific operation is called:
|
|
|
|
|
Options
|
|
| |
|
|
DSS
|
|
|
MISS
|
|
|
ISS
|
|
|
All of the above.
|
|
|
| |
|
|
Question No. 28
|
Marks - 10
|
|
|
|
Which is the most creative and challenging phase of SDLC?
|
|
|
|
|
Options
|
|
| |
|
|
Analysis
|
|
|
Design
|
|
|
Implementation
|
|
|
Feasibility Study
|
|
|
| |
|
|
Question No. 29
|
Marks - 10
|
|
|
|
Costs that are known to exist but whose financial value cannot be accurately measured are referred to as
|
|
|
|
|
Options
|
|
| |
|
|
Intangible
|
|
|
Tangible
|
|
|
Direct
|
|
|
Indirect
| |
|
|
Question No. 30
|
Marks - 10
|
|
|
|
The parts of the organization or computer system depend on one another is called:
|
|
|
|
|
Options
|
|
| |
|
|
Interaction
|
|
|
Interdependence
|
|
|
Integration
|
|
|
All of the above
|
|
|
|
|
|
|
Question No. 31
|
Marks - 10
|
|
|
|
Which of the following Normal forms states that a non-key attribute depends on a key attribute or concatenated key:
|
|
|
|
|
Options
|
|
| |
|
|
First Normal Form
|
|
|
Second Normal Form
|
|
|
Third Normal Form
|
|
|
BCNF
|
|
|
|
Question No. 32
|
Marks - 10
|
|
|
|
_________ means adding, modifying or redeveloping the code to support change in any specifications.
|
|
|
|
|
Options
|
|
| |
|
|
Enhancement
|
|
|
Maintenance
|
|
|
Implementation
|
|
|
All of the above
|
|
|
| |
|
|
Question No. 33
|
Marks - 10
|
|
|
|
Which symbol of DFD represents a Data Store?
|
|
|
|
|
Options
|
|
| |
|
|
Circle
|
|
|
Square
|
|
|
Open-ended Rectangle
|
|
|
Triangle
|
|
|
| |
|
|
Question No. 34
|
Marks - 10
|
|
|
|
System maintenance is necessary because:
|
|
|
|
|
Options
|
|
| |
|
|
Human never gets it right the first time.
|
|
|
The deployment may change over time.
|
|
|
The user’s needs may change over time.
|
|
|
All of the above.
|
|
|
| |
|
|
Question No. 35
|
Marks - 10
|
|
|
|
A person-machine system and a highly integrated grouping of information-processing functions designed to provide management
with a comprehensive picture of specific operation is called:
|
|
|
|
|
Options
|
|
| |
|
|
DSS
|
|
|
MIS
|
|
|
IIS
|
|
|
All of the above.
|
|
|
|
Question No. 36
|
Marks - 10
|
|
|
|
The parts of the organization or computer system depend on one another is called:
|
|
|
|
|
Options
|
|
| |
|
|
Interaction
|
|
|
Interaction
|
|
|
ntegration
|
|
|
All of the above
|
|
|
|
Question No. 37
|
Marks - 10
|
|
|
|
What kind of information comes under user staff category of information?
|
|
|
|
|
Options
|
|
| |
|
|
Policies
|
|
|
Authority relationship
|
|
|
Objectives
|
|
|
Work schedules
|
|
|
| |
|
|
Question No. 38
|
Marks - 10
|
|
|
|
Primary external source of information is:
|
|
|
|
|
Options
|
|
| |
|
|
Financial report
|
|
|
Electronic data process
|
|
|
Government documents
|
|
|
Personal stuff
|
|
|
|
Question No. 39
|
Marks - 10
|
|
|
|
In which step of feasibility study people resist to change:
|
|
|
|
|
Options
|
|
| |
|
|
Technical feasibility
|
|
|
Behavioural feasibility
|
|
|
Economical feasibility
|
|
|
None of the above
|
|
|
| |
|
|
Question No. 40
|
Marks - 10
|
|
|
|
Evaluation criteria for the best candidate system:
|
|
|
|
|
Options
|
|
| |
|
|
Performance and cost
|
|
|
Observation
|
|
|
User feedback
|
|
|
None of the above
|
|
|
Short Name or Subject Code:
Structure Analysis and Design
Short Description:
MCA 3RD SEM
University:
Amity
Service Type:
Assignments
Select Semester:
Semester- II Semester- III Select Cource:
Msc-IT MCA
Product: