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
