MIS 3250 Exam

If group members work alone in the beginning of the project and then pool the ideas with guidance, they are participating in ________.

A Nominal Group Technique

"All data and entry fields should be clearly labeled" is related to ________ for the design of forms and reports.

A balanced layout

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?

Abbreviation

Daniel was surprised his store ran out of marshmallows so quickly. This typically does not happen during the spring, so he runs a(n) ________ to gather unplanned information to support if he should stock up on marshmallows.

Ad-hoc report

Which relation is created with a composite primary key using the primary keys of the related entities, plus any nonkey attributes associative entity of the relationship or associative entity?

Associative entity

Which relation is created with a composite primary key using the primary keys of the related entities and additional primary key attributes associated with the relationship or associative entity, plus any non-key attributes of the relationship or associative entity?

Associative entity with additional key

Which relation is created with the primary key associated with the relationship or associative entity, plus any nonkey attributes of the relationship or associative entity and the primary keys of the related entities (as foreign key attributes)?

Associative entity with its own key

A functional dependency is a particular relationship between two ________.

Attributes

Rating a response or idea on a scale, say from bad to good or strongly agree to strongly disagree, is what type of interview question?

Close-ended

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.

Conceptual

To convert a relation to second normal form, you decompose the relation into new relations using the attributes, called ________, that determine other attributes.

Determinants

The ________ report provides details behind the summary values on a key-indicator or exception report.

Drill-down

Which of the following is an example of a primary key?

Driver's license number

What is the result of normalization?

Every nonprimary key attribute depends on the whole primary key and nothing but the primary key.

The ________ report highlights data that are out of the normal operating range.

Exception

A recursive foreign key is a foreign key in a relation that references the primary key values of a different relation.

False

A(n) ________ is the smallest unit of application data recognized by system software, such as a programming language or database management system.

Field

"Use same family of typefaces within and across displays and reports" is related to which guideline for displaying tables and lists?

Formatting columns, rows, and text

"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?

Formatting numeric, textual, and alphanumeric data

In some situations, a single attribute name, called a(n) ________, may have more than one meaning or describe more than one characteristic.

Homonym

One of the greatest challenges for designing mobile applications that run on smartphones and tablets is the ________ interface.

Human-computer

A(n) ________ is a file organization in which rows are stored either sequentially or non-sequentially, and an index is created that allows software to locate individual rows.

Indexed file organization

In logical database modeling and design, we combine normalized data requirements from all user interfaces into one consolidated logical database model; this step is called view ________.

Integration

Left-justifying text and leaving a ragged-right margin is related to which of the guidelines for displaying text?

Justification

The ________ report provides a summary of critical information on a recurring basis.

Key-indicator

Normalized relations are, of course, the result of ________ database design.

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.

Logical

All of these are types of database models except ________.

Matrix model

"Revision date or code to distinguish a form or report from prior versions" is related to ________ for the design of forms and reports.

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.

Meaningful titles

Often, initial prototypes are simply a series of ________ screens that are not working modules or systems.

Mock

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.

Normalization

________ is a process for converting complex data structures into simple, stable data structures.

Normalization

What is the primary disadvantage of a group interview?

Participants do not want to voice their opinion

The capability to split a table into separate sections, often called ________, is possible with most relational database products.

Partitioning

Logical and ________ database design is typically performed in parallel with other systems design steps.

Physical

A(n) ________ is a field of data that can be used to locate a related field or row of data.

Pointer

________ are used in file organizations when it is not possible to store related data next to each other.

Pointers

A(n) ________ is an attribute (or combination of attributes) whose value is unique across all occurrences of a relation.

Primary Key

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 ________.

Redundancy

Cindy tried to delete a customer but the customer still had open invoices so the system would not allow her to delete the customer. More than likely ________ was enforced.

Referential integrity

In a relation, the sequence of columns can be interchanged without changing the meaning or use of the ________.

Row

The ________ report is produced at predefined intervals-daily, weekly, or monthly-to support the routine informational needs of an organization.

Scheduling

In ________ normal form, each nonprimary key attribute is identified by the whole key (what we call full functional dependency).

Second

In some situations, two or more attributes may have different names but the same meaning, as when they describe the same characteristic of an entity. Such attributes are called ________.

Synonyms

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 ________.

Table

Which of the following is NOT used as a design specification section when designing forms and reports?

Testing and usability assessment

In business-related systems, ________ is becoming increasingly important as text-based applications such as electronic mail, bulletin boards, and information services are more widely used.

Textual output

In ________ normal form, nonprimary key attributes do not depend on each other (what we call no transitive dependencies).

Third

A ________ can be used to quickly develop a series of screens so that users can get a sense of the look and feel of a design.

Wireframe