BCIS CH 9-14

Many organizations allocate ________ of IS budget to maintenance.

60-80%

________ is a software building block used to ensure that common system capabilities are standardized to facilitate data exchange between clients and servers.

API

________ is a method by which users interact with an information system.

An interface

_______ is the process of splitting or combining normalized relations into physical tables based on affinity of use of rows and fields.

Denormalization

All of the following are measures of usability of a system except

Ease of programming

Which of the following is not a characteristic of cloud computing?

Enhanced security

In a typical client-server setting, _______ is mostly the responsibility of the client.

user interface

All of the following are requirements that need to be considered when you design forms and reports except:

How many copies of the report are needed?

Which of the following maintenance organization types provide improved system and documentation quality?

Separate

________ brings together of all of the programs that a system comprises for testing purposes.

System testing

________ brings data management, presentation and analysis together into a three-tiered client-server environment.

Middleware

________ is the process of converting complex data structures into simple, stable data structures.

Normalization

Which of the following is not a property of relations in the relational database model?

The sequence of the rows cannot be changed.

The process of designing forms and reports must be a user-focused activity and follows a prototyping approach.

True

All of the following are potential problems of using colors in forms and reports except:

Use of colors may suppress emotional reactions.

When every non-primary key attribute is functionally dependent on the full set of primary key attributes, the relation is in ________ normal form.

Second

__________ is an Internet authoring language that allows designers to create customized tags, enabling the definition, transmission, validation and interpretation of data between applications.

XML

In ________ method, users enter explicit statements into a system to invoke operations.

a command language interaction

A master plan for testing a system must be developed during ________ stage.

analysis

Natural language interaction method is based on research in ________.

artificial intelligence

A _______ field is a field that can be derived from other database fields.

calculated

A _______ is an attribute that appears as a nonprimary key attribute in one relation and as the primary key attribute in another relation.

foreign key

In _______ file organization method, rows are stored non-sequentially but the address for each row is determined using an algorithm.

hashed

A ________ report provides summary of critical information on regular basis.

key-indicator

In ________ maintenance, changes are made to a system to avoid possible future problem.

preventive

The primary key in a relation must satisfy that _______.

the value of the key must uniquely identify every row in the relation

The result of normalization is that every non-primary key attribute depends upon ________.

the whole primary key

A relation is in _____ when there are no partial and transitive functional dependencies.

third normal form (3NF)

________ is a type of user testing of a completed information system using real data in the real user environment.

Beta testing

All of the following take place during the implementation stage except:

Database design

Which of the following is not a limitation of file server model?

Inability to provide user-friendly interface

________ is the longest phase in the SDLC.

Maintenance

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

Referential integrity

Which of the following service models is like dining out at a restaurant in the analogy of pizza as a service?

Software as a Service (SaaS)

________ documentation provides detailed information about a system's design specifications, its internal workings, and its functionality.

System

Changing over from the old system to a new one by turning off the old system when the new system is turned on describes ________ installation approach.

direct

eXtensible Style Language (XSL) is a specification for separating style from content when generating HTML document to improve __________.

site consistency

The criteria for a relation to be in the 2nd normal form applies only when _______.

the primary key is composed of multiple attributes