CIS 311 Final Study Guide

"Test for too few or too many characters," is part of the values validation test. A. True B. False

B. False

In an object oriented database model, data is represented as a set of related tables or relations. A. True B. False

B. False

________ is a process for converting complex data structures into simple, stable data structures. A. Normalization B. De-normalization C. Relation D. Database modeling

A. Normalization

"A consistent organizing principle should be used that relates to the tasks the intended users perform," falls under which category for menu design guidelines? A. Organization B. Selection C. Wording D. Length

A. Organization

Logical and ________ database design is typically performed in parallel with other systems design steps. A. Physical B. Normal C. Conceptual D. Normalized

A. Physical

A(n) ________ is an attribute (or combination of attributes) whose value is unique across all occurrences of a relation. A. Primary key B. Identifier C. Index D. Composite key

A. Primary key

Under which design specification category for interfaces and dialogues does speed of performance appear? A. Narrative Overview B. Interface; Dialogue Designs C. Testing and Usability Assessment D. Database Design

C. Testing and Usability Assessment

Under which design specification category for interfaces and dialogues does time to learn appear? A. Narrative Overview B. Interface; Dialogue Designs C. Testing and Usability Assessment D. Database Design

C. Testing and Usability Assessment

When designing the navigation procedures within our system, flexibility and consistency are primary concerns. A. True B. False

A. True

When two 3NF relations are merged to form a single relation, dependencies between non-keys may result. A. True B. False

A. True

________ is an overall evaluation of how a system performs in supporting a particular user for a particular task. A. Accuracy B. Speed C. Satisfaction D. Usability

D. Usability

When designing forms and reports, which characteristic focuses on issues related to experience, skills, motivation, education, and personality that should be considered? A. Environment B. Task C. System D. User

D. User

When using a ________, users push an array of small buttons that represent symbols that are then translated into words and commands. A. Keyboard B. Touch screen C. Mouse D. Graphics tablet

A. Keyboard

"Clear and specific titles describing content and use of form or report" is related to ________ for the design of forms and reports. A. Meaningful titles B. Meaningful information C. A balanced layout D. An easy navigation system

A. Meaningful titles

"Valid date, which identifies on what date (or time) the data in the form or report was accurate," is related to ________ for the design of forms and reports. A. Meaningful titles B. Meaningful information C. A balanced layout D. An easy navigation system

A. Meaningful titles

________ is a usability dimension concerned with how easy it is to remember how to accomplish a task when revisiting the system after a period of time. A. Memorability B. Error-rate C. Satisfaction and aesthetics D. Efficiency

A. Memorability

Under which design specification category for interfaces and dialogues do environmental characteristics appear? A. Narrative Overview B. Interface; Dialogue Designs C. Testing and Usability Assessment D. Database Design

A. Narrative Overview

Under which design specification category for interfaces and dialogues does interface/dialogue name appear? A. Narrative Overview B. Interface; Dialogue Designs C. Testing and Usability Assessment D. Database Design

A. Narrative Overview

"Test to make sure values come from set of standard values," is part of the expected values validation test. A. True B. False

B. False

A foreign key is an attribute (or combination of attributes) whose value is unique across all occurrences of a relation. A. True B. False

B. False

A form is a business document that contains only predefined data; it is a passive document used solely for reading or viewing. A. True B. False

B. False

A mouse is the most accurate device for a data entry task. A. True B. False

B. False

A null value is the value a field will assume unless an explicit value is entered for the field. A. True B. False

B. False

A paper prototype is a simple design to show the placement of information elements on a screen and the space needed for each element. A. True B. False

B. False

A touch screen is the most accurate device for a text selection task. A. True B. False

B. False

Ad-hoc reports provide details behind the summary values on a key-indicator or exception report. A. True B. False

B. False

Command language interaction does not require users to remember command syntax and semantics. A. True B. False

B. False

Drill-down reports highlight data that are out of the normal operating range. A. True B. False

B. False

During logical database design, you must account for every data element on a system input or output—form or report—and on the flow chart. A. True B. False

B. False

Highlighting cannot be a valuable technique for notifying users of errors in data entry or processing. A. True B. False

B. False

Most forms have a stylized format and are usually simple row and column format. A. True B. False

B. False

The procedure for representing relationships depends on both the degree of the relationship and not on the cardinalities of the relationship. A. True B. False

B. False

To clearly show how to move forward and backward is related to balance the layout characteristic during the design of forms and reports. A. True B. False

B. False

Which usability factor specifies that information format should be consistent between entry and display, and format should distinguish each piece of data and highlight, not bury, important data? A. Consistency B. Format C. Flexibility D. Clarity

B. Format

"Entry methods should be consistent and reflect the size of the application and sophistication of the users," falls under which category for menu design guidelines? A. Organization B. Selection C. Wording D. Length

B. Selection

In ________ normal form, non-primary key attributes do not depend on each other (what we call no transitive dependencies). A. First B. Third C. Second D. Fourth

B. Third

A relation is a named, ________-dimensional table of data. Each relation (or table) consists of a set of named columns and an arbitrary number of unnamed rows. A. One B. Two C. Three D. Four

B. Two

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 ________. A. Space B. Data C. Redundancy D. Columns

C. Redundancy

A paper prototype is a series of mock ________ that can be used to test content, look, and feel, as well as the task flow and other usability factors. A. Forms B. Papers C. Screens D. Reports

C. Screens

Which of the following is a method by which users interact with an information system? A. Database B. Report C. Form D. Interface

D. Interface

A small plastic box that users push across a flat surface and whose movements are translated into cursor movement on a computer display is known as a ________. A. Mouse B. Joystick C. Light pen D. Trackball

A Mouse

The key should be ________; that is, no attribute in the key can be deleted without destroying its unique identification. A. Non-redundant B. Redundant C. Normalized D. De-normalized

A. Non-redundant

Each ________ in a relation corresponds to an attribute of that relation. A. Column B. Entity C. Data D. Row

A. Column

In logical database modeling and design, we translate the ________ E-R data model for the application or enterprise, developed without explicit consideration of specific user interfaces, into normalized data requirements. A. Conceptual B. Normal C. Physical D. Logical

A. Conceptual

A(n) ________ is a coding scheme recognized by system software for representing organizational data. A. Data type B. Field C. Data model D. Attribute

A. Data type

The ________ report highlights data that are out of the normal operating range. A. Exception B. Schedules C. Drill-down D. Key-indicator

A. Exception

"Use short, simple wording, common spelling, and complete sentences and give users only what they need to know, with the option to find additional information," is related to which guideline for designing usable help? A. Simplicity B. Manage C. Organize D. Show

A. Simplicity

"Test where an extra digit is added to a numeric field in which its value is derived using a standard formula," is part of the self-checking digits validation test. A. True B. False

A. True

A calculated field is a field that can be derived from other database fields and is also known as a computed field or a derived field. A. True B. False

A. True

A key-indicator report provides a summary of critical information on a recurring basis. A. True B. False

A. True

A relation is a named, two-dimensional table of data and each relation (or table) consists of a set of named columns and an arbitrary number of unnamed rows. A. True B. False

A. True

A relation is in third normal form if it is in second normal form and there are no functional dependencies between two (or more) non-primary key attributes. A. True B. False

A. True

A report typically contains data from many unrelated records or transactions. A. True B. False

A. True

A single menu has obvious advantages over a command language but may provide little guidance beyond invoking the command. A. True B. False

A. True

An icon may also look like a button that, when selected or depressed, causes the system to take an action relevant to that form, such as cancel, save, edit a record, or ask for help. A. True B. False

A. True

A relation is in ________ if every non-primary key attribute is functionally dependent on the whole primary key. A. 1NF B. 2NF C. 3NF D. 4NF

B. 2NF

Displaying text in mixed uppercase and lowercase and using conventional punctuation is related to which of the guidelines for displaying text? A. Justification B. Case C. Spacing D. Hyphenation

B. Case

"Reversing the sequence of one or more characters in a field," is related to transcripting data error type. A. True B. False

B. False

Under which design specification category for interfaces and dialogues do dialogue sequence diagram(s) and narrative description appear? A. Narrative Overview B. Interface; Dialogue Designs C. Testing and Usability Assessment D. Database Design

B. Interface; Dialogue Designs

The most common method for implementing ________ is through the use of icons. A. Form interaction B. Object-based interaction C. Menu interaction D. Natural language interaction

B. Object-based interaction

In a relation, each row is unique and uniqueness is guaranteed because the relation has a non-empty ________ key value. A. Composite B. Primary C. Candidate D. Unique

B. Primary

A ________ is a business document that contains only predefined data; it is a passive document used solely for reading or viewing. A. Form B. Report C. Flowchart D. Word document

B. Report

The ________ report is produced at predefined intervals-daily, weekly, or monthly-to support the routine informational needs of an organization. A. Exception B. Scheduled C. Drill-down D. Key-indicator

B. Scheduled

In ________ normal form, each non-primary key attribute is identified by the whole key (what we call full functional dependency). A. First B. Second C. Third D. Fourth

B. Second

A(n) ________ is one field or a combination of fields for which more than one row may have the same combination of values. A. Index B. Secondary key C. Primary key D. Pointer

B. Secondary key

Using acronyms only when they are widely understood by users and are significantly shorter than the full text is related to which of the guidelines for displaying text? A. Justification B. Case C. Abbreviations D. Spacing

C. Abbreviations

The ________ report provides details behind the summary values on a key-indicator or exception report. A. Exception B. Scheduled C. Drill-down D. Key-indicator

C. Drill-down

Which usability factor specifies that information should be viewed and retrieved in a manner most convenient to the user? A. Clarity B. Format C. Flexibility D. Organization

C. Flexibility

"Break long sequences of alphanumeric data into small groups of three to four characters each" is related to which guideline for displaying tables and lists? A. Meaningful titles B. Formatting columns, rows, and text C. Formatting numeric, textual, and alphanumeric data D. Use meaningful labels

C. Formatting numeric, textual, and alphanumeric data

________ is a human—computer interaction method whereby inputs to and outputs from a computer-based application are in a conventional spoken language such as English. A. Form interaction B. Menu interaction C. Natural language interaction D. Object-based interaction

C. Natural language interaction

According to guidelines for selecting tables versus graphs, we should use tables for ________. A. Providing a quick summary of data B. Forecasting activities C. Reading individual data values D. Detecting trends over time

C. Reading individual data values

Each ________ of a relation corresponds to a record that contains data values for an entity. A. Column B. Entity C. Row D. Attribute

C. Row

User fatigue is a potentially high usability problem associated with which device? A. Keyboard B. Graphics tablet C. Touch screen D. Mouse

C. Touch screen

"Menu items should be displayed in mixed uppercase and lowercase letters and have a clear, unambiguous interpretation," falls under which category for menu design guidelines? A. Organization B. Selection C. Wording D. Length

C. Wording

"Clearly show where we are (e.g., page 1 of 3) on the report" is related to ________ for the design of forms and reports. A. Meaningful titles B. Meaningful information C. A balanced layout D. An easy navigation system

D. An easy navigation system

Which usability factor specifies that outputs should be self-explanatory and not require users to remember information from prior outputs in order to complete a task? A. Consistency B. Flexibility C. Format D. Clarity

D. Clarity

Which test is done to ensure that data are of proper type, e.g., all numeric, all alphabetic, all alphanumeric? A. Reasonablesness B. Expected Values C. Range D. Class

D. Class

________ is a human-computer interaction method whereby users enter explicit statements into a system to invoke operations. A. Menu interaction B. Form interaction C. Object-base interaction D. Command language interaction

D. Command language interaction

A ________ is an attribute that appears as a non-primary key attribute in one relation and as a primary key attribute (or part of a primary key) in another relation. A. Referential Integrity B. Unique key C. Primary key D. Foreign key

D. Foreign key

All human-computer interfaces must have an interaction style and use some ________ for supporting this interaction. A. Database B. Software C. Network D. Hardware

D. Hardware

The ________ report provides a summary of critical information on a recurring basis. A. Exception B. Scheduled C. Drill-down D. Key-indicator

D. Key-indicator

________ is a usability dimension concerned with how difficult it is for the user to perform a task for the first time. A. Efficiency B. Satisfaction and aesthetics C. Memorability D. Learnability

D. Learnability

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. A. Database designing B. Data modeling C. De-normalization D. Normalization

D. Normalization

Which of the below is a problem from using a color in forms and reports? A. Draws attention to warnings B. Soothes or strikes the eye C. Evokes more emotional reactions D. Printing or conversion to other media may not easily translate

D. Printing or conversion to other media may not easily translate

A report typically contains data from many unrelated ________ or transactions. A. Form B. Documents C. Attributes D. Records

D. Records

"Provide examples of proper use and the outcomes of such use," is related to which guideline for designing usable help? A. Simplicity B. Manage C. Organize D. Show

D. Show

A well-structured 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 and is also known as a ________. A. Row B. Key C. Column D. Table

D. Table

Which test is done to ensure that data conform to a standard format? A. Missing Data B. Expected Values C. Self-Checking Digits D. Templates

D. Templates

A sphere mounted on a fixed base that steers the cursor on a computer display is known as a ________. A. Mouse B. Joystick C. Light pen D. Trackball

D. Trackball

De-normalization can increase the chance of errors and inconsistencies that normalization avoided. A. True B. False

A. True

Highlighting can be a valuable technique for drawing attention to keywords, commands, high-priority messages, and data that have changed or gone outside normal operating ranges. A. True B. False

A. True

In a relational table, each row is unique and uniqueness is guaranteed because the relation has a non-empty primary key value. A. True B. False

A. True

In addition to providing a look and feel that can be assessed, the paper prototype is also used to test content, task flow, and other usability factors. A. True B. False

A. True

Increasingly, developers are using tools that can quickly create screen mockups, referred to as wireframes. A. True B. False

A. True

Logical 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. A. True B. False

A. True

One objective of interface design is to reduce data entry errors. A. True B. False

A. True

Range validation test is done to ensure data are within proper range of values. A. True B. False

A. True

To minimize data entry errors and user frustration, never require the user to enter information that is already available within the system or information that can be easily computed by the system. A. True B. False

A. True