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