BIS 4753 Structured systems analysis-Final Exam

What is the value of c (OVERALL NPV)? HINT: You can find the value of c by adding a and b Don't include decimal places or parentheses when providing numerical answers.

848,819 (with margin: 0)

If group members work alone in the beginning of the project and then pool the ideas with guidance, they are participating in ________.

A Nominal Group Technique

If a project has a small or narrow focus, it most likely was chosen by ________.

A business unit

________ is/are the final output from the analysis phase.

A description of the alternative solution

Which of the following activities happens during the SDLC planning phase?

A presentation of why the system should or should not be developed by the organization is given.

Which of the following is NOT a part of the project management process?

Adjoining

Which of the following is an incorrect explanation for key physical database design decisions?

Arranging related records in primary memory (hard disks and magnetic tapes) so that records can be stored, retrieved and updated rapidly

According to the DFD conventions, the data flow is always depicted by a(n) ________.

Arrow

A functional dependency is a particular relationship between two ________.

Attributes

________ is NOT a valid type of partitioning method in relational database products.

Boundary

Which option identifies the point at which benefits equal costs?

Break-even analysis

The overall process by which current methods are replaced with new methods is referred to as ________.

Business process reengineering

Which of the following is NOT a feature of PERT?

Calculates budget for a project

A ________ key is an attribute (or combination of attributes) that uniquely identifies each instance of an entity type.

Candidate

The ________ defines the number of instances of entity B that can (or must) be associated with each instance of entity A.

Cardinality

If an organization is using applications rented from a third party vendor running in a remote location, they are most likely using what type of software system?

Cloud computing

A(n) ________ data model is a detailed model that captures the overall structure of organizational data that is independent of any database management system or other implementation considerations.

Conceptual

The concept of DFD ________ refers to whether or not the depiction of the system shown at one level

Consistency

A ________ is a picture of the movement of data between external entities and the processes and data stores within a system.

Data flow diagram

A ________ is an end product of an SDLC phase.

Deliverable

________ is the process of splitting or combining normalized relations into physical tables based on affinity of use of rows and fields.

Denormalization

Which of the following is NOT included as a total when using a weighted multi-criteria project?

Department rankings

________ will mostly likely choose projects that are easy to integrate with the current hardware and software.

Development group

Which of the following is NOT a phase in the Planning Game?

Documentation

hinking about attributes, which of the following is an example of a synonym?

EMP_ID and Employee_ID

________ solutions integrate individual traditional business functions into a series of modules so that a single transaction occurs seamlessly within a single information system rather than several separate systems.

ERP

A(n) ________ is a person, place, object, event, or concept in the user environment about which the organization wishes to maintain data.

Entity

The most common format used for data modeling is ________ diagramming.

Entity-relationship

What is the result of normalization?

Every nonprimary key attribute depends on the whole primary key and nothing but the primary key.

________ and ________ are the two processes of prototypes.

Evolutionary; throwaway

An unstructured relation is a relation that contains a minimum amount of redundancy and that allows users to insert, modify, and delete the rows without error or inconsistencies.

False

Which of the following is NOT a characteristic of top management when choosing an IS project selection?

Faster development

A ________, which is conducted by the project manager, involves determining if the information system makes sense for the organization from an economic and operational standpoint.

Feasibility study

A(n) ________ is the smallest unit of application data recognized by system software, such as a programming language or database management system.

Field

________ are recognized in official documentation of the organization.

Formal systems

________ is the process of discovering discrepancies between two or more sets of DFDs or discrepancies within a single DFD

Gap analysis

Which of the following is NOT a characteristic of good systems analyst?

Great at finances

What is a possible outcome of NGT?

Ideas for new features in a system

Analysis

In which phase of the SDLC are the system requirements studied and structured?

When an organization has the resources and a system must be built from scratch, an organization should choose what type of software?

In-house development

The term ________ is used when a project is reviewed after each stage to determine its continuance.

Incremental commitment

A(n) ________ is a file organization in which rows are stored either sequentially or non- sequentially, and an index is created that allows software to locate individual rows.

Indexed file organization

A ________ is a DFD that represents a system's major processes, data flows, and data stores at a high level of detail.

Level-0 diagram

In which design phase of the SDLC are all functional features of the system chosen for development in analysis described independently of any computer platform?

Logical design

Balancing is the conservation of inputs and outputs to a DFD process when that process is decomposed to a ________ level.

Lower

Which of the following is NOT a source of requirements gathering for the systems analyst?

Market conditions

Barry asked Jerry for a diagram that shows the sequence of dependencies between tasks. Barry is asking for a ________

Network diagram

TRUE

Ninety-four percent of companies report that they practice agile in their systems development efforts.

Which of the following is NOT a characteristic of a steering committee when making IS identification and selections?

No concern with cost-benefit analysis

In logical database design, we use a process called ________, which is a way to build a data model that has the properties of simplicity, non-redundancy, and minimal maintenance.

Normalizaion

A ________ value is a special field value, distinct from zero, blank, or any other value, that indicates that the value for the field is missing or otherwise unknown.

Null

Systems development methodologies and techniques which are based on objects rather than data or processes are known as ________.

Object-oriented analysis and design

Which of the following is NOT a major category of sources of software?

Offshore

A new hardware purchase is classified as a(n)

One-time cost

Joshua is a new project manager. He is unsure of how much time a new task will require to be completed on the project. He decides to use ________ to estimate a realistic time frame for the task.

PERT

The capability to split a table into separate sections, often called ________, is possible with most relational database products.

Partitioning

Logical and ________ database design is typically performed in parallel with other systems design steps.

Physical

A(n) ________ is a field of data that can be used to locate a related field or row of data.

Pointer

________ are NOT a part of a decision table.

Policies

What unique characteristic(s) distinguish(es) each object from other objects of the same type?

Primary key

A ________ is the work or actions performed on data so that they are transformed, stored, or distributed

Process

Data cannot move directly from one data store to another data store. Data must be moved by a ________.

Process

Which of the following is NOT a generic strategy identified by Porter?

Product introduction

During ________, the project manager performs several activities to assess the size, scope, and complexity of the project and to establish procedures to support subsequent activities.

Project initiation

The ________ is a systems analyst with a diverse set of skills-management, leadership, technical, conflict management, and customer relationship-who is responsible for initiating, planning, executing, and closing down a project.

Project manager

Which tool enables you to quickly take basic requirements and create a limited working system?

Prototyping

One purpose of database design is to structure the data in stable structures, called normalized tables, that are not likely to change over time and that have minimal ________.

Redundancy

Which of the following is NOT a common criterion when choosing off-the-shelf software?

Reputation of the firm

All of the following are categories of feasibility except

Scope

In ________ normal form, each nonprimary key attribute is identified by the whole key (what we call full functional dependency).

Second

A(n) ________ is one field or a combination of fields for which more than one row may have the same combination of values.

Secondary key

A database designer chooses a file organization for a specific file that will provide the following except ________.

Security from authorized users

A ________ is the origin and/or destination of the data, and these are sometimes referred to as external entities because they are outside the system.

Source

All of the following are guidelines for choosing indexes for relational databases except ________.

Specify multiple keys for each table

Which of the following is NOT a primary activity in project identification?

Stop current projects

Which evaluation criterion for classifying and ranking projects deals with helping an organization achieve its long-term goals?

Strategic alignment

Which of the following is NOT an example of a recurring cost?

System conversion

A(n) ________ comes from an information system that can be measured monetarily.

Tangible benefit

FALSE

The Agile Methodologies focus on the roles that people perform rather than placing the emphasis on individuals.

Which of the below is a true statement regarding the systems development life cycle?

The life cycle can be thought of as a circular process in which the end of the useful life of one system leads to the beginning of another project to develop a new version of or replace an existing system.

Why is open-source software different than the other types of software?

The source code is free.

Who must review the Baseline Project Plan before it moves to the next phase in the SDLC?

The user, managers, and development group

In ________ normal form, nonprimary key attributes do not depend on each other (what we call no transitive dependencies).

Third

Which of the following is a critical factor that distinguishes agile methods from traditional approaches to systems development?

Thrives in a culture where people feel empowered by having many degrees of freedom

Which term below means that money available today is worth more than the same amount tomorrow?

Time value of money

The ________ rule specifies that each entity instance of the supertype must be a member of some subtype of the relationship.

Total specialization

Which business rule specifies the validity of attribute values?

Triggering operations

An entity ________ is described just once in a data model, whereas many ________ of that may be represented by data stored in the database.

Type; instances

A recursive relationship is also known as a ________ relationship.

Unary

Which of the following is NOT a guideline for better cost estimation?

Update estimates at the end of the project.

What is the first step in the BPR effort?

Use induction

When choosing a weighted system to determine project viability, what should the organization keep in mind?

Weights are subjective.

Systems analyst

Who has the primary responsibility for the design and analysis of information systems?

All of the following are ways of validating purchased software information except ________.

asking the manufacturer if they feel their software is best

Project break-even occurs ...

between years 1 and 2

What is the practice of a company running a computer application for another organization?

outsourcing

________ refers to the use of previously written software resources, especially objects and components, in new applications.

reuse

The critical path represents the ________ time in which a project can be completed.

shortest

Nodes not on the critical path contain ________ time and allow the project manager some flexibility in scheduling.

slack

Which of the following is NOT a basic reuse software step?

testing