SA Final Exam CH 9-14
A relation is in ________ if every non-primary key attribute is functionally dependent on the whole primary key.
2NF
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
High-quality documentation leads to a(n) ________ percent reduction in the system maintenance effort when compared with average-quality documentation.
80
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?
Abbreviations
When using an integrated development environment, ________ maintain(s) design documents such as data flow diagrams and screen designs, not source code.
Analysts
________ is the technique of placing "tabs" that show a user where he or she is within a site and where he or she has been.
Cookie Crumbs
________ is/are needed to construct any version of the system that has ever existed.
Build routines
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.
Foreign key
The premise of ________ is to allow users to fill in the blanks when working with a system.
Form interaction
All of the following are automated test types except ________.
Desk checking
The ________ report provides details behind the summary values on a key-indicator or exception report.
Drill-down
MTBF is a measurement of ________ occurrences that can be tracked over time to indicate the quality of a system.
Error
A report is a business document that contains some predefined data and may include some areas where additional data are to be filled in. T/F
False
A touch screen is the most accurate device for a text selection task. T/F
False
Command language interaction does not require users to remember command syntax and semantics. T/F
False
Emphasis on the logical organization of information is not a benefit of using color T/F
False
Most forms have a stylized format and are usually simple row and column format. T/F
False
A(n) ________is an information systems department function and is staffed by IS personnel.
Help desk
________ is a common error when design the interface and dialogues of websites.
Hidden links
During the early stages of ________, the training plans are finalized and training on the use of the system begins.
Implementation
Which of the following is a method by which users interact with an information system?
Interface
________ is a lightweight data interchange approach that is relatively easy for humans to understand and for computers to generate or interpret.
JSON
When using a ________, users push an array of small buttons that represent symbols that are then translated into words and commands.
Keyboard
________ is the cabling, hardware, and software used to connect workstations, computers and file servers located in a confined geographical area.
LAN
The maintenance phase is the ________ phase of the systems development life cycle.
Last
Most companies have some sort of document like a(n) ________ to request new development, to report problems, or to request new features within an existing system.
System Service Request
________ has detailed information about a system's design specifications, its internal workings, and its functionality.
System documentation
All of these are types of database models except ________.
Matrix model
MTBF stands for ________.
Mean time between failures
"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
All of the following are guidelines for menu design except ________.
Meaningful to the user
Which common property of windows and forms in a GUI environment allows users to shrink a window or form to an icon?
Minimize
The key should be ________; that is, no attribute in the key can be deleted without destroying its unique identification.
Nonredundant
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
A ________ value is a special field value, distinct from zero, blank, or any other value, that indicates that the value for the field is missing or otherwise unknown.
Null
Lack of ________ can cause maintenance efforts to increase exponentially.
Quality documentation
In ________ testing, each module is tested alone in an attempt to discover any errors in its code.
Unit
________ is an overall evaluation of how a system performs in supporting a particular user for a particular task.
Usability
________ has written or other visual information about an application system, how it works, and how to use it.
User documentation
It may be necessary to ________ a Web site with search engines when the content of the site changes significantly.
Reregister
________ is a usability dimension concerned with how enjoyable a system's visual appeal is and how enjoyable the system is to use.
Satisfaction and aesthetics
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.
Screens
________ is the process whereby actual users test a completed information system.
Acceptance testing
Contrary to corrective maintenance, ________ maintenance is generally a small part of an organization's maintenance effort, but it adds value to the organization.
Adaptive
One prime example of a cloud computing provider is ________.
Amazon Web Services
When ________ maintenance problems surface, they are typically urgent and need to be resolved to curtail possible interruptions in normal business activities.
Corrective
Ad-hoc reports provide details behind the summary values on a key-indicator or exception report. T/F
False
A binary one-to-many (1:N) relationship in an E-R diagram is represented by adding the primary key attribute (or attributes) of the entity on the one side of the relationship as a(n) ________ in the relation that is on the many side of the relationship.
Foreign key
A ________ is a business document that contains some predefined data and may include some areas where additional data are to be filled in.
Form
Client/server architecture is a ________-based computing environment in which a central database server or engine performs all database commands sent to it from client workstations, and application programs on each client concentrate on user interface functions.
LAN
A(n) ________ is a field of data that can be used to locate a related field or row of data.
Pointer
________ may be necessary in order for visitors to find your site based on the new or changed content.
Reregistration
________ specifies that rather than renting out space or time to each customer on one specific, physical machine, cloud providers manage multiple distributed resources that are dynamically assigned to multiple customers based on their needs.
Resource Pooling
According to the ________ service principle, a service should be usable in many different applications.
Reusability
________ tools are those that can create a representation of a system or program module at a design level of abstraction.
Reverse engineering
________ is more than simply expanded integration testing, where you are testing the interfaces between programs in a system rather than testing the interfaces between modules in a program.
System testing
________ is an advantage of using the client/server architecture.
The ability to decouple the client environment from the server environment
Each PC and workstation on a LAN is typically within a few hundred feet of another, with a total network cable length of less than one mile. T/F
True
Error messages should appear in roughly the same format and placement each time so that they are recognized as error messages and not as some other information. T/F
True
Offsetting the position of nonstandard information is one of the methods of highlighting information. T/F
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. T/F
True
________ is the user testing of a completed information system using real data in the real user environment.
Beta testing
A(n) ________ is a special type of software application for collecting, organizing, and publishing Web site content.
CMS
The ________ is the portion of the client/server database system that provides the user interface and data manipulation functions.
Client
Code is the deliverable that is produced after the ________ phase.
Coding
Each ________ in a relation corresponds to an attribute of that relation.
Column
Which interaction places a substantial burden on the user to remember names, syntax, and operations?
Command language interaction
________ is a human-computer interaction method whereby users enter explicit statements into a system to invoke operations.
Command language interaction
A ________ is the (back-end) portion of the client/server database system running on the server that provides database processing and shared access functions.
Database engine
A form is a business document that contains only predefined data; it is a passive document used solely for reading or viewing. T/F
False
A mouse is the most accurate device for a data entry task. T/F
False
A ________ is a device that manages file operations and is shared by each client PC attached to a LAN.
File server
A ________ is a set of related programs that protects the resources of a network from users from other networks.
Firewall
The user guide is the deliverable that is produced after the ________ phase.
Installation
Normalized relations are, of course, the result of ________ database design.
Logical
If ________ is/are assigned to make changes to a system, they must first check out a copy of the baseline system modules since no one is allowed to directly modify the baseline modules.
Maintenance personnel
In the ________ model, the user has control over the applications but has limited or no control over the underlying infrastructure.
PaaS
Many systems professionals feel that ________ maintenance is not really maintenance but rather new development.
Perfective
________ means providing Internet content to a user based upon knowledge of that customer.
Personalization
A ________ table is a named set of rows and columns that specifies the fields in each row of the table.
Physical
Logical and ________ database design is typically performed in parallel with other systems design steps.
Physical
In a relation, the sequence of columns can be interchanged without changing the meaning or use of the ________.
Relation
There are ________ major activities involved in system implementation.
Six
________ make(s) it much simpler to design an Internet-based system versus a client/server system.
Standards
To verify that a system meets its objectives, ________ testing involves using nonlive test data in a nonlive testing environment.
System
Which test is done to ensure that data conform to a standard format?
Templates
Inspection is a(n) ________ technique in which participants examine program code for predictable language-specific errors.
Testing
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
A report typically contains data from many unrelated records or transactions. T/F
True
