Midterm Practice Day 1
Which are the major business themes that guide analysts in fact finding activities? (chose 3)
What are the business processes?
How are the business processes performed?
What information is needed?
What are the two primary benefits of reviewing the documentation of existing inputs, outputs, and procedures. (choose
2)
Obtain a preliminary understanding
Serve as visual aids in interview discussions
Two benefits of researching vendor solutions include _______ and ______. (Choose two)
helping analysts discover state of the art solutions
helping users generate new ideas for business functions
Which two of the following are activities of Core Process 3? (choose two)
Gather detailed information
Develop user-interface dialogs
One important reason for prioritizing requirements is to _______.
avoid scope creep
Clients play what role in the development of the new system?
Fund the project
Two primary techniques to identify use cases are _______ and _______. (Choose two)
user goal technique
event decomposition technique
In UML notation the includes relationship connects two use cases. The use case that is “included” use case is the one
which _______ .
is connected to the head of an arrow
Something that occurs at a specific time and place and should be remember by the system is called a(n) _______.
event
The user goal technique normally begins by identifying, listing, and classifying _______ .
the system users
The source of using the concept of events to define functional requirements was first emphasized with _______
systems.
real-time
Which of the following is an example of a state event?
Inventory reorder point is reached
One technique for finding “things” that need to be in the new system is done by the analyst starts making lists of
“things.” He may do this from information and even without talking to the users extensively. This technique is called the
_______.
noun technique
One technique to find the “things” that need to be included in the new system begins by starting with a user and the
use cases and then try to identify the necessary informational “things.” This technique is called the _______.
brainstorming technique
https://i.imgur.com/Mvzl4dL.png
The above cardinality constraint on the Order data entity indicates that there can be _____ .
one or many orders
https://i.imgur.com/L4gPIMr.png
The association shown on the above image is a(n) ________ association.
unary
https://i.imgur.com/4LIiZxQ.png
This notation indicates what type of association?
Generalization/Specialization
When analyzing the list of nouns to determine whether to exclude a particular noun as an important “thing,” which of
the following questions should be asked about the noun? (choose two)
Is it a synonym of an existing thing?
Is it an output from the system?
https://i.imgur.com/Ap1HBRU.png
Which is correct?
B
CRUD stands for _______________.
Create, Read, Update, Delete
Two methods to show a return value are: (Choose two)
value :=
Dashed arrow with value
Two methods to show a repeating message are: (Choose two)
Asterisk *
Loop frame
Which of the following is NOT an advantage of object-oriented modeling with several models is that _____.
developing new models allows the analyst to discard unnecessary diagrams.
A unique set of internal activities within a use case which represents a unique path through the use case is called a(n)
_______.
scenario
Accurate, relevant, and timely information is the key to ____.
good decision making
The organization of data within folders in a manual file system is determined by _______.
its expected use
The database structure in a DBMS is stored as a _____.
collection of files
An XML database supports the storage and management of _____ XML data.
semistructured
A(n) _______ enables a database administrator to describe schema components.
data definition language (DDL)
Oracle 12c, MS SQL Server, and Tamino are examples of _____ data models.
XML Hybrid
VMS/VSAM is an example of the _____.
file system data model
A(n) _____ is anything about which data are to be collected and stored.
constraint
A(n) _____ is bidirectional.
relationship
When you define a table’s primary key, the DBMS automatically creates a(n) _____ index on the primary key
column(s) you declared.
unique
Another name for a composite entity is a(n) _____ entity.
bridge
The CUSTOMER table’s primary key is CUS_CODE. The CUSTOMER primary key column has no null entries, and
all entries are unique. This is an example of _____ integrity.
entity
Ideally, an entity identifier is composed of _____ attribute(s).
one
A derived attribute is indicated in the Chen notation by a _____ that connects the attribute and an entity.
dashed line
_____ expresses the minimum and maximum number of entity occurrences associated with one occurrence of the
related entity.
Cardinality
In the entity relationship diagram (ERD), cardinality is indicated using the _____ notation, where max is the
maximum number of associated entities and min represents the minimum number of associated entities.
(min, max)
If an entity can exist apart from all of its related entities, then it is existence-independent, and it is referred to as a(n)
_____ entity.
strong
A _____ entity has a primary key that is partially or totally derived from the parent entity in the relationship.
weak
Within a specialization hierarchy, every subtype can have _____ supertype(s) to which it is directly related.
only one
One important inheritance characteristic is that all entity subtypes inherit their _____ key attribute from their
supertype.
primary
Which of the following is a specialization hierarchy disjoint constraint scenario in case of partial completeness?
Subtype discriminator can be null.
Attribute A _____ attribute B if all of the rows in the table that agree in value for attribute A also agree in value for
attribute B.
determines
A(n) _____ exists when there are functional dependencies such that Y is functionally dependent on X, Z is
functionally dependent on Y, and X is the primary key.
transitive dependency
In a(n) _____ diagram, the arrows above the attributes indicate all desirable dependencies.
dependency