Question

Question 1

1 out of 1 points

Using lists to break information into manageable pieces conforms to the SOS guideline of:

organize

shortcuts

organize

simplicity

show

Question 2

1 out of 1 points

Two different names that refer to the same data item best defines:

synonym

homonym

synonym

transitive dependency

alias

Question 3

1 out of 1 points

The set of all data types and ranges of values that an attribute can assume defines:

domain

cardinality

constraint set

domain

reference set

Question 4

1 out of 1 points

Which of the following is not a true statement regarding data flows?

A data flow can go directly back to the same process it leaves.

A fork 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.

A data flow can go directly back to the same process it leaves.

A data flow has a noun phrase label.

A data flow has only one direction of flow between symbols.

Question 5

1 out of 1 points

A named property or characteristic of an entity that is of interest to the organization defines:

attribute

relationship

instance

gerund

Question 6

1 out of 1 points

Which of the following is not a true statement regarding a relation?

Each row in a relation corresponds to an attribute of that relation.

Each relation consists of a set of named columns and an arbitrary number of unnamed rows.

Each column in a relation corresponds to an attribute of that relation.

An entry at the intersection of each row and column has a single value.

Each row in a relation corresponds to an attribute of that relation.

Question 7

1 out of 1 points

A table used to determine the location of rows in a file that satisfy some condition best describes:

index

relation

structure chart

index

domain table

Question 8

1 out of 1 points

A method that helps you to better understand how a system fits within existing business activities and data best defines:

system granularity

context development

integration depth

organizational breadth

Question 9

1 out of 1 points

Recording a customer’s payment is represented on a data flow diagram as a:

process

source

data flow

data store

Question 10

1 out of 1 points

The guideline specifying that dialogues be logically grouped and have a beginning, middle, and end is:

closure

shortcuts and sequence

consistency

control

Question 11

1 out of 1 points

Which of the following is not a rule for structuring data entry fields?

Never justify data entries.

Never require data that is already on-line or that can be computed.

Always provide default values when appropriate.

Never justify data entries.

Always place a caption adjacent to fields.

Question 12

1 out of 1 points

An Internet authoring language that allows designers to create customized tags, enabling the definition, transmission, validation, and interpretation of data between applications best describes:

XML

HTTP

BIND

HTML

XML

Question 13

1 out of 1 points

The process of migrating mainframe applications to personal computers, workstations, and networks is sometimes called:

upsizing

downsizing

downgrading

resizing

Question 14

1 out of 1 points

All of the following are usability characteristics except:

satisfaction

completeness

speed

accuracy

Question 15

1 out of 1 points

Each regular entity type in an E-R diagram is transformed into a:

relation

row in a relation

column in a relation

tuple in a relation

Question 16

1 out of 1 points

Process, logic, and data model descriptions of a system must be consistent and complete because:

they each describe different but complementary views of the same information system

they are prepared during the analysis phase

they are constructed in parallel by separate analyst teams

programming tasks require the integration of the information contained in the diagrams

Question 17

0 out of 1 points

A computer-based file containing employee information is represented on a data flow diagram as a:

data flow

source

data store

process

Question 18

1 out of 1 points

Providing Internet content to users based upon knowledge of that customer best describes:

personalization

micromarketing

personalization

customization

profiling

Question 19

1 out of 1 points

The most widely used interface method is:

menu interaction

object-based interaction

natural language interaction

menu interaction

command language interaction

Question 20

1 out of 1 points

Grouping related options together and requiring the same option to have the same wording and codes each time it appears refers to the:

organization guideline for menu design

wording guideline for menu design

selection guideline for menu design

organization guideline for menu design

highlighting guideline for menu design

Question 21

1 out of 1 points

Which of the following combines range and hash partitioning by first segregating data by ranges on the designated attribute and then within each of these partitions it further partitions by hashing on the designated attribute?

composite partitioning

combined partitioning

transitive partitioning

functional partitioning

Question 22

1 out of 1 points

Combining all normalized user views into one consolidated logical database model refers to:

view integration

requirements structuring

view integration

normalization

file integration

Question 23

1 out of 1 points

The extent to which information contained on one level of a set of nested data flow diagrams is also included on other levels refers to:

DFD consistency

DFD completeness

DFD gap proofing

DFD flexibility

Question 24

1 out of 1 points

An assertion or rule that governs the validity of data manipulation operations such as insert, update, and delete is:

triggering operation

entity integrity

referential integrity constraints

domains

Question 25

1 out of 1 points

Which of the following statements regarding the differences between file server and client/server architectures is true?

While software maintenance on the file server architecture is considered low, software maintenance on the client/server architecture is mixed since some new parts must be delivered to each client.

While the file server architecture involves efficient data transfers, the client/server architecture has large file and data transfers.

Servers and clients perform processing in a file server architecture. Only servers perform processing in a client/server architecture.

While database security and integrity on a file server architecture is high, it is low on the client/server architecture.

While software maintenance on the file server architecture is considered low, software maintenance on the client/server architecture is mixed since some new parts must be delivered to each client.

Question 26

1 out of 1 points

A square on a data flow diagram represents a:

data store

data flow

process

source/sink

Question 27

1 out of 1 points

Potentially high usability problems for some applications exist for keyboards in all of the following areas except:

visual blocking

adequate feedback

speed

movement scaling

Question 28

1 out of 1 points

A decision table does not include:

statements

condition stubs

action stubs

rules

Question 29

1 out of 1 points

An indifferent condition is represented by a(n):

dash (-)

dash (-)

asterisk (*)

exclamation point (!)

pound sign (#)

Question 30

1 out of 1 points

When transforming an E-R diagram into normalized relations, the identifier of the entity type becomes:

the primary key of the corresponding relation

the foreign key in the corresponding relation

a nonkey attribute in the corresponding relation

a secondary key in the corresponding relation

Question 31

1 out of 1 points

The diagram that shows the scope of the system, indicating what elements are inside and which are outside the system, is called a:

context diagram

level-2 diagram

referencing diagram

representative diagram

Question 32

1 out of 1 points

The deliverables of process modeling state:

how you should develop the system during physical design

what you learned during requirements determination

how you should implement the new system during implementation

what you learned during project planning

Question 33

1 out of 1 points

The primary deliverable from the conceptual modeling step within the analysis phase is a(n):

E-R diagram

state-transition diagram

context data flow diagram

decision tree

Question 34

1 out of 1 points

The data manipulation operation (insert, delete, or update) that initiates the operation is called a(n):

condition

action

user rule

event

Question 35

1 out of 1 points

Movement to another screen requires the functional requirement of:

cursor control capabilities

editing capabilities

exit capabilities

help capabilities

Question 36

1 out of 1 points

When each nonprimary key attribute is identified by the whole key, the relation is said to be in at least:

second normal form

third normal form

fourth normal form

fifth normal form

Question 37

1 out of 1 points

A many-to-many relationship that associates certain items with their component items is called a:

binary structure

bill-of-materials structure

binary relationship

ternary relationship

Question 38

1 out of 1 points

During logical database design, the work of all systems development team members is coordinated and shared through:

the project dictionary

scheduled weekly meetings

the project leader

JAD sessions

Question 39

1 out of 1 points

Which of the following statements is true regarding normalization?

Normalization produces a set of well-structured relations that contain all of the data mentioned in system inputs and outputs.

Normalization is a top-down process.

Through the use of anomalies, stable structures are produced.

Normalization is an integrity constraint specifying that the value of an attribute in one relation depends on the value of the same attribute in another relation.

Question 40

1 out of 1 points

Which of the following client/server architectures places all software on the client except for the data management functions?

distributed function

remote presentation

remote data management

distributed processing

Question 41

1 out of 1 points

When designing Web pages, which of the following is the recommendation for avoiding bleeding-edge technology?

make sure that users do not need the latest browsers or plug-ins to view your site

avoid using large images, lots of images, unnecessary animations, or other time-consuming content

avoid scrolling text and animations since they are both hard to read and users often equate such content as advertising

make sure that users do not need the latest browsers or plug-ins to view your site

make sure you avoid designing any legitimate information in a manner that resembles advertising

Question 42

1 out of 1 points

The primary characteristic of a client-based LAN is that:

all data manipulation is performed at the client PC, not at the file server

all data manipulation is performed at the file server, not at the client PC

all data manipulation is performed at the client PC, not at the file server

each client has a copy of the database and performs all data manipulations

the database is stored on the file server and all data manipulations are performed by the file server

Question 43

1 out of 1 points

For a binary many-to-many relationship existing between entity types A and B:

a separate relation C is created; the primary key of relation C is a composite key consisting of the primary key for each of the two entities in the relationship

the primary keys of relation A and relation B are designated as functionally dependent attributes

secondary keys are used to establish the relationship

place the primary key of either entity in the relation for the other entity or do this for both entities

Question 44

1 out of 1 points

In general, highlighting:

should not be used to warn users of errors in data entry or processing

should not be used to provide warnings to users regarding possible problems such as unusual data values

should not be used in tandem

should be used sparingly to draw the user to or away from certain information and to group together related information

Question 45

1 out of 1 points

In the case of designing forms and reports, the major deliverables are:

the design specifications

an updated baseline project plan and updated statement of work

entity-relationship diagrams

the implemented forms and reports

Question 46

1 out of 1 points

The ability to provide field-level help is often referred to as:

context-sensitive help

screen-level help

systems-level help

application-level help

Question 47

1 out of 1 points

Basic procedures for constructing a decision table do not include:

listing all possible rules

naming the conditions and the values each condition can assume

identifying selection criteria

simplifying the decision table

Question 48

1 out of 1 points

A communication protocol for exchanging information on the Internet best describes:

HTTP

BIND

HTML

XML

Question 49

1 out of 1 points

Which of the following statements regarding the differences between file server and client/server architectures is true?

While database security and integrity are low on a file server architecture, they are high on a client/server architecture.

While network usage involves efficient data transfers on a file server architecture, it is not efficient on a client/server architecture.

In terms of hardware and system software flexibility, there is less need for coordination between the client and server on a client/server architecture than on a file server architecture.

In terms of concurrent data access, concurrent data access is managed by the client in a client/server architecture.

Question 50

1 out of 1 points

Client-based deliveries of applications to users of PCs and workstations are called:

client-delivery applications

local applications

front-end applications

back-end applications

Question 51

1 out of 1 points

The general design guideline stating that outputs should be self-explanatory and not require users to remember information from prior outputs in order to complete tasks is:

ease

efficiency

flexibility

format

Question 52

1 out of 1 points

If a form is delivered on a visual display terminal, which design specification section would describe the capabilities of this device?

narrative overview

sample design

testing and usability

management issues

Question 53

1 out of 1 points

When designing forms and reports, the first activity is to:

gain an understanding of the intended user and task objectives by collecting initial requirements during requirements determination

structure and refine the requirements independent from the users

ask users to review and refine prototypes of the form or report

structure and refine the requirements with the users

Question 54

1 out of 1 points

Which of the following refers to the set of all data types and values that an attribute can assume?

domains

referential integrity constraints

triggering operations

entity integrity

domains

Question 55

1 out of 1 points

An effectively designed form:

minimizes the need to scroll windows

provides default values when practical

displays data in appropriate field lengths

does all of these

Question 56

1 out of 1 points

A concise statement of the business rule to be enforced by the triggering operation refers to:

user rule

condition

action

event

Question 57

1 out of 1 points

An arrow on a data flow diagram represents a:

data store

data flow

process

source/sink

Question 58

1 out of 1 points

Research conducted on the usage of color found that:

color had positive effects on user task performance and perceptions when the user was under time constraints for the completion of a task

color is universally better than no color

the benefits of color are apparent regardless of the presentation format of the information

limiting the number and amount of color is not a good idea

Question 59

1 out of 1 points

Which of the following properties of a relation states that an entry at the intersection of each row and column is single-valued?

Entries in cells are simple.

Entries in columns are from the same set of values.

Each row is unique.

The sequence of rows is insignificant.

Question 60

1 out of 1 points

For a binary one-to-one relationship between two entities A and B, the relationship is represented by:

either adding the primary key of A as a foreign key of B or adding the primary key of B as a foreign key of A

adding the primary key of A as a foreign key of B

adding the primary key of B as a foreign key of A

combining the two entities into one relation

Question 61

1 out of 1 points

A set of two or more multivalued attributes that are logically related defines:

relationship

gerund

repeating group

class

Question 62

1 out of 1 points

When condition values are either “yes” or “no”, these values are called a(n):

extended entry

simple entry

complex entry

limited entry

Question 63

1 out of 1 points

Entering invalid data into a field describes:

transposing

transcripting

appending

truncating

Question 64

1 out of 1 points

Which of the following is a fundamental question to ask when designing forms and reports?

Who will use the form or report?

What is the purpose of the form or report?

Where does the form or report need to be delivered and used?

All of these

Question 65

1 out of 1 points

The process of linking together previous stand-alone personal computers to form networks that support workgroup computing is sometimes called:

upsizing

downsizing

upgrading

communicating

Question 66

1 out of 1 points

A method by which users interact with information systems defines:

dialogue

discussion

interface

session

Question 67

1 out of 1 points

If a data flow appears on the context diagram and is also represented at level-0, this would be referred to as:

leveling

flow conservation

balancing

matching

Question 68

1 out of 1 points

A supplier of auto parts to our company is represented on a data flow diagram as a:

process

source

data flow

data store

Question 69

1 out of 1 points

A computing server where data analysis functions primarily reside best defines:

file server

analytical server

dedicated server

application server

Question 70

1 out of 1 points

The section of a design specification that explains to those who will actually develop the final form why this form exists and how it will be used is called:

narrative overview

testing and usability assessment

rationale and benefit

usage and application

Question 71

1 out of 1 points

The menu positioning method that places a menu near the current cursor position is the:

pop-up menu

drop-down menu

box menu

cursor menu

Question 72

1 out of 1 points

A data flow diagram that represents a system’s major processes, data flows, and data stores at a high level of detail refers to:

level-0 diagram

context diagram

level-1 diagram

level-00 diagram

Question 73

1 out of 1 points

The process of converting complex data structures into simple, stable data structures is referred to as:

normalization

simplification

structuring

process modeling

Question 74

1 out of 1 points

A named two-dimensional table of data is a:

network

tree structure

relation

tuple

Question 75

1 out of 1 points

If an associative entity exists, then:

a separate relation C is created; the primary key of relation C is a composite key consisting of the primary key for each of the two entities in the relationship

the primary keys of relation A and relation B are designated as functionally dependent attributes

secondary keys are used to establish the relationship

place the primary key of either entity in the relation for the other entity or do this for both entities

Question 76

1 out of 1 points

Data in motion, moving from one place in a system to another, defines:

data store

process

source

data flow

Question 77

1 out of 1 points

Which of the following specifies that each instance of an entity type must have a unique identifier that is not null?

referential integrity constraints

triggering operations

entity integrity

domains

Question 78

1 out of 1 points

An association between the instances of one or more entity types that is of interest to the organization best defines:

occurrence

relationship

coupling

cardinality

Question 79

1 out of 1 points

During physical design, you consider:

the definitions of each attribute

the descriptions of where and when data are entered, retrieved, deleted, and updated

the expectations for response time and data integrity

All of these

Question 80

1 out of 1 points

For each entity, the name of the identifier is:

identified by using a double-lined ellipse

bold on an E-R diagram

written in all capital letters on an E-R diagram

Question 81

1 out of 1 points

Tables should be used instead of graphs when the user will be:

comparing points and patterns of different variables

forecasting activities

reading individual data values

detecting trends over time

Question 82

1 out of 1 points

When designing the navigation procedures within your system, the primary concerns are:

the design of between-field navigation and the ability to provide feedback

grouping data fields into logical categories and assigning group labels

flexibility and consistency

accuracy and reliability

Question 83

1 out of 1 points

When two 3NF relations are merged to form a single relation:

transitive dependencies may result

weak entities are created

recursive relationships may result

IS-A relationships are formed

Question 84

1 out of 1 points

Assume the first condition has four values; the second condition has two values; the third condition has two values. How many rules will there be?

8

7

16

24

Question 85

1 out of 1 points

To convert a relation to second normal form, you decompose the relation into new relations using the attributes, called:

determinants

foreign key

pointer

relationship key

Question 86

1 out of 1 points

The three main constructs of the entity-relationship modeling notation include each of the following except:

data entities

data flows

relationships

attributes

Question 87

1 out of 1 points

Which of the following is a true statement?

An employee application is an example of a report.

Reports are only for reading and often contain data about multiple unrelated records in a computer file.

Reports are used to convey information on a single item.

Generally, reports are only printed on paper.

Question 88

1 out of 1 points

Which of the following is not an advanced rule governing data flow diagramming?

Composite data flows on one level cannot be split into component data flows at the next level.

To avoid having data flow lines cross each other, data stores may be repeated on a DFD.

At the lowest level of DFDs, new data flows may be added to represent data that are transmitted under exceptional conditions.

The inputs to a process must be sufficient to produce the outputs from the process.

Question 89

1 out of 1 points

Software building blocks that are used to assure that common system capabilities like user interfaces and printing are standardized as well as modules for facilitating the data exchange between clients and servers best describes:

an application program interface

firmware

a software patch

a database management system

Question 90

1 out of 1 points

The condition that causes the operation to be triggered:

condition

action

entity name

user rule

Question 91

1 out of 1 points

The focus placed on forms and reports during logical design is on:

the content and layout design of the forms and reports

identifying how specific forms or reports should be implemented

identifying the content, layout design, and implementation method

None of these

Question 92

1 out of 1 points

Which of the following specifies that an entity instance can simultaneously be a member of two (or more) subtypes?

overlap rule

total specialization rule

partial specialization rule

disjoint rule

Question 93

1 out of 1 points

A sphere mounted on a fixed base that steers the cursor on a computer display is a:

trackball

mouse

light pen

joystick

Question 94

1 out of 1 points

The variation of menu design is most often related to:

All of these

the capabilities of the development environment

the skills of the developer

the size and complexity of the system

All of these

Question 95

1 out of 1 points

A miracle process is one that:

has only inputs

has only outputs

cannot be exploded further

has insufficient inputs to produce the associated processes

Question 96

1 out of 1 points

The input device that is most accurate for text selection is the:

mouse

keyboard

trackball

light pen

Question 97

1 out of 1 points

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

attribute

data element

relationship

entity

Question 98

1 out of 1 points

When selecting an identifier, one should:

use intelligent keys

use large composite keys instead of single-attribute surrogate keys

choose a candidate key that will not change its value over the life of each instance of the entity type

choose a candidate key such that for each instance of the entity, the attribute is guaranteed to have valid values or is null

Question 99

1 out of 1 points

A data warehouse that is limited in scope and whose data are obtained by selecting and summarizing data from the enterprise data warehouse best describes a(n):

information desk

rule base

data mart

data center

Question 100

1 out of 1 points

A human-computer interaction method where symbols are used to represent commands or functions defines:

object-based interaction

form interaction

menu interaction

command language interaction