COSC Final Exam
Meaningful information
"All data and entry fields should be clearly labeled" is related to ________ for the design of forms and reports.
Meaningful information
"Revision date or code to distinguish a form or report from prior versions" is related to ________ for the design of forms and reports.
Attributes
A functional dependency is a particular relationship between two ________.
true
A key-indicator report provides a summary of critical information on a recurring basis.
True
A new system is developed when there is a change in the hardware or software platform or when fundamental assumptions and properties of the data, logic, or process models change.
False
A primary key is an attribute (or combination of attributes) that uniquely identifies each instance of an entity type.
True
A report is a business document that contains some predefined data and may include some areas where additional data are to be filled in.
entity
A(n) ________ is a person, place, object, event, or concept in the user environment about which the organization wishes to maintain data.
required attribute
A(n) ________ is an attribute that must have a value for every entity instance.
Database Design
All of the following activities take place during the system implementation stage except:
type
An entity ________ is a collection of entities that share common properties or characteristics.
instance
An entity ________ is a single occurrence of an entity type.
False
During design, we develop a unit test plan, an integration test plan, and a system test plan and during support; these various plans are put into effect and the actual testing is performed in this phase.
Data
During requirements structuring, a ________ model represents conceptual data requirements for a particular system.
conceptual
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.
False
In the maintenance phase, the systems development group is responsible for collecting maintenance requests from the network management staff.
how information is provided and captured from users
Interface design focuses on _______.
True
Mastery of the requirements structuring methods and techniques is critical to one's success on a systems development project team.
True
Regardless of the development methodology followed, once coding has begun, the testing process can begin and proceed in parallel.
Testing
Test scenarios (test plan) and test data are the deliverables that are produced after the ________ phase.
exception
The ________ report highlights data that are out of the normal operating range.
System Maintenance
The largest systems development expenditure for many organizations is spent on
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.
Testing and Usability Assessment
Under which design specification category for interfaces and dialogues does time to learn appear?
Acceptance
User testing of a completed information system using real data in the real user environment refers to as ---------- testing.
B is said to be functionally dependent on A
When the value of an attribute (Attribute A) uniquely determines the value of another attribute (Attribute B), then _______.
analysis
Which SDLC phase is analogous to the maintenance process of obtaining a maintenance request?
Obtaining maintenance requests
Which activity in the maintenance phase requires that a formal process be established whereby users can submit system change requests?
preventive
Which maintenance involves changes made to a system to reduce the chance of future system failure?
Interface
Which of the following is a method by which users interact with an information system?
Use as many different typefaces as possible.
Which of the following is not a prudent advice for designing tables and lists?
Menu items should be displayed in all upper-case letters and have a clear, unambiguous interpretation.
Which of the following is not a prudent menu design guideline?
Be humorous
Which of the following is not one of the ten user interface design fundamentals as discussed in class?
seperate
Which of the following maintenance organizational structures has as its advantage the formal transfer of systems between groups improves the system and documentation quality?
Branch and Employee
Which of the following relationships between two entities is represented as a one-to-many type (Based on the examples we did in class -- i.e., Bank database --)?
Every nonprimary key attribute is functionally dependent on the full set of primary key attributes
Which of the following statements correctly describe the condition for a relation to be in the second normal form.
scheduled
Which of the following types of reports is used to provide summary of critical information on regular basis?
Associative entity with additional key
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?
installation
________ is the process during which the current system is replaced by the new system.
disjoint
a _______ rule of the supertype/subtype hierarchy.
Binary
A ________relationship is a relationship between instances of two entity types.
