Chapter 5-9 exam
A ________ key is an attribute (or combination of attributes) that uniquely identifies each instance of an entity type. Unique Candidate Duplicate Primary none of the above
Candidate
The ________ defines the number of instances of entity B that can (or must) be associated with each instance of entity A. Identifier Relationship Cardinality Association
Cardinality
The concept of DFD ________ refers to whether or not the depiction of the system shown at one level of a nested set of DFDs is compatible with the depictions of the system shown at other levels. Accuracy Consistency Balancing Completeness
Consistency
A ________ shows the scope of the system, indicating which elements are inside and which are outside of the system Data diagram Process flow diagram Procedure flow diagram Context diagram none of the above
Context diagram
Which of the following is NOT a part of project initiation? Develop the project charter Establish management procedures Create a project budget Create the project initiation team
Create a project budget
Which of the following is NOT an example of a project risk assessment factor? Project duration time Organizational personnel changes resulting from system Customer's commitment to system Familiarity with similar systems
Customer's commitment to system
________ allow you to check for the extent to which your logic is complete, consistent, and not redundant. Gap analysis Process modeling Action stubs Decision tables
Decision tables
All of the following are tangible benefits except ________. ncreased speed of activity Improvement of management planning Cost reduction Decreased flexibility
Decreased flexibility
A(n) ________ is an attribute whose value can be computed from related attribute values. Required attribute Composite attribute Optional attribute Derived attribute
Derived attribute
Which of the following is an advantage of the use of domains? Domains ensure data manipulation operations are logical. Domains are non-null. Domains are easier to define in an E-R model than entities. They are easier to understand than entities.
Domains ensure data manipulation operations are logical.
A(n) ________ in a data flow means that exactly the same data goes from a common location to two or more different processes, data stores, or sources/sinks. (This usually indicates different copies of the same data going to different locations.) Fork Join Break Arrow
Fork
Kathy was reviewing the DFD and found there was a discrepancy between the order process and the customer credit approval process. Kathy was involved in a(n) ________. Gap analysis Walkthrough JAD Audit none of the above
Gap analysis
What is a possible outcome of NGT? A list of user roles in the project Ideas for new features in a system The analysts' favorite projects Times for a new meeting
Ideas for new features in a system
At what point in the project should you identify the alternative solutions? The introduction section of the BPP In the system description section of the BPP During baseline planning During the project initiation phase
In the system description section of the BPP
The two way wo insert data into a table in Microsoft Access (using either proprietary or SQL) are: Insert into or datasheet view design view or insert into query view or design view add view, insert view
Insert into or datasheet view
Which part of the Baseline Project Plan contains an outline of the recommended course of action? Feasibility assessment Management issues System description Introduction
Introduction
If group members work alone in the beginning of the project and then pool the ideas with guidance, they are participating in ________. A group interview A single interview A Nominal Group Technique The JAD process
A Nominal Group Technique
________ is used to represent an indifferent decision in the decision table. A dash The letter X A blank A greater than sign none of the above
A dash
When two ________ have the same data flow name, you must be careful that these flows are exactly the same. Arrows Processes Rectangles DFDs
Arrows
What is the term that describes the best estimate of a project's scope, benefits, cost, and resources? Baseline project plan Project charter Management procedure Resource plan
Baseline project plan
A ________ relationship is a relationship between instances of two entity types and is the most common type of relationship encountered in data modeling. Secondary Ternary Primary Binary
Binary
BPMN stands for ________. Basic Process Modeling Notation Business Process Modeling Notation Business Procedure Modeling Notation Business Process Multi Notation none of the above
Business Process Modeling Notation
The overall process by which current methods are replaced with new methods is referred to as ________. CASE Business process reengineering JAD Systems analysis
Business process reengineering
Which of the following is a drawback for prototyping? It is a complex way to develop systems. It takes a long time to produce a product. There is typically no formal documentation created. Tools are not readily available for use.
There is typically no formal documentation created.
An entity ________ is described just once in a data model, whereas many ________ of that may be represented by data stored in the database. Class; objects Type; instances Instance; types Type; classes
Type;instances
All of the following are needed to calculate time present value except ________. Discount rate Inflation rate Amount Years from now
inflation rate
A ________ is a DFD that represents a system's major processes, data flows, and data stores at a high level of detail. Level-1 diagram Level-2 diagram Level-0 diagram Level-3 diagram
Level-0-diagram
What should one do first when creating a decision table? List all possible rules. Name the conditions. Identify the value each condition can assume. Simply the decision table. list all the rules and actions
List all possible rules.
________ database design is driven not only from the previously developed E-R data model for the application or enterprise but also from form and report layouts. Physical Logical relational Normalized De-normalized
Logical
Karen is creating an E-R model. Skill is one of the attributes of worker. But a worker can have more than one skill, therefore Karen knows this is a(n) ________. Entity Aliases Multivalued attribute Instance
Multivalued attribute
A Project Scope Statement can be used to ________. Detail project estimates Prepare the project for the analysis phase Outline a schedule Serve as a contract None of the above
None of the above
All of the following are part of project planning except ________. Organizing the team Identifying risk Developing the project scope Creating a resource plan all are needed
Organizing the team
Which of the following is NOT an example of a type of feasibility study? Operational feasibility Technical feasibility Resource feasibility Economic feasibility all are types
Resource feasibility
The following development approach is known for its short cycles. Steering Agile SDLC eXtreme Programming
SDLC
All of the following are categories of feasibility except ________. Scheduling Technical Political Scope all are categories
Scope
A ________ lists what it takes to satisfy stakeholders if the use case is completed successfully. Minimal guarantee Success guarantee Precondition Trigger none of the above
Success guarantee
A(n) ________ comes from an information system that can be measured monetarily. Tangible benefit Economic feasibility Project benefit Project plan none of the above
Tangible benefit
The criteria choice in MS Access Appears in a Create Query similar to the SQL select statement can be invoked on many fields all of the above only answers 1 and 3
All of the above
What of the following is NOT a purpose for a baseline project plan? Eliminate risks A depository for information collected during initiation Resources are more quantifiable Decide if a project should be rejected
Eliminate risks
________ and ________ are the two processes of prototypes. Throwaway; permanent New process; old process Evolutionary; throwaway Long term; short-term
Evolutionary; throwaway