Question 1

A repeating group is a set of one or more fields that can occur only once in a single record, with each occurrence having the same value.

Accepted Answer

A) True 
 B)False

Question 2

Computers represent data as ____________________ that have only two possible values: zero (0) or one (1).

Accepted Answer

The answer of Computers represent data as ____________________ that have...

Question 3

-In the table or file shown in the accompanying figure, a(n) ____________________ is a set of related fields that describes one instance, or occurrence of an entity.

Accepted Answer

The answer of  
-In the table or file shown...

Question 4

A table design is in third normal form (3NF) if it is in 2NF and if all nonkey fields are dependent on other nonkey fields.

Accepted Answer

A) True 
 B)False

Question 5

____ means that a system can be expanded, modified, or downsized easily to meet the rapidly changing needs of a business enterprise.

Accepted Answer

A)  Scalability 
B)  Compatibility 
C)  Cardinality 
D)  Functionality 
A)  Scalability 
B)  Compatibility 
C)  Cardinality 
D)  Functionality

Question 6

A(n) ____________________ date is the total number of days from some specific base date.

Accepted Answer

The answer of A(n) ____________________ date is the total number...

Question 7

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A foreign key value that does not match an existing key in another table.

Accepted Answer

A) UML 
B) cardinality 
C) secondary key 
D) data mining 
E) orphan
F)subschema
G)intranet
H)entity
I)physical
J)logical 
A) UML 
B) cardinality 
C) secondary key 
D) data mining 
E) orphan
F)subschema
G)intranet
H)entity
I)physical
J)logical

Question 8

Because it supports virtually all languages, ____________________ has become a global standard.

Accepted Answer

The answer of Because it supports virtually all languages, ____________________...

Question 9

One problem in a typical file-processing environment is the rigid data structure. _________________________

Accepted Answer

A) True 
 B)False

Question 10

A(n) ____ is a set of letters or numbers that represents a data item.

Accepted Answer

A)  syntax 
B)  data dictionary 
C)  mnemonic 
D)  code 
A)  syntax 
B)  data dictionary 
C)  mnemonic 
D)  code

Question 11

Which of the following is the advantage of a DBMS (database management system)?

Accepted Answer

A)  economy of scale 
B)  flexible data sharing 
C)  increased programmer productivity 
D)  data dependence 
A)  economy of scale 
B)  flexible data sharing 
C)  increased programmer productivity 
D)  data dependence

Question 12

List at least 6 guidelines for developing a code.

Accepted Answer

1. Keep codes concise. Do not create cod

Question 13

-In the accompanying figure, any field that could serve as a primary key is called a ____.

Accepted Answer

A)  secondary key 
B)  candidate key 
C)  combination key 
D)  foreign key 
A)  secondary key 
B)  candidate key 
C)  combination key 
D)  foreign key

Question 14

In a file-oriented information system, a history file contains reference data used by the information system.

Accepted Answer

A) True 
 B)False

Question 15

In a file-oriented information system, a master file ____.

Accepted Answer

A)  stores relatively permanent data about an entity 
B)  is created and saved for backup and recovery purposes 
C)  stores records that contain day-to-day business and operational data 
D)  is a temporary file created by an information system for a single task 
A)  stores relatively permanent data about an entity 
B)  is created and saved for backup and recovery purposes 
C)  stores records that contain day-to-day business and operational data 
D)  is a temporary file created by an information system for a single task

Question 16

____ is the process of converting readable data into unreadable characters to prevent unauthorized access to the data.

Accepted Answer

A)  Encapsulation 
B)  Normalization 
C)  Standardization 
D)  Encryption 
A)  Encapsulation 
B)  Normalization 
C)  Standardization 
D)  Encryption

Question 17

In a file-oriented information system, a table file is a file created for historical or archiving purposes.

Accepted Answer

A) True 
 B)False

Question 18

To protect stored data, users can be asked to furnish a proper user ID and password to access a file or database.

Accepted Answer

A) True 
 B)False

Question 19

-A(n) ____________________, such as that shown in the accompanying figure, contains a set of related records that store data about a specific entity.

Accepted Answer

The answer of  
-A(n) ____________________, such as that shown...

Question 20

The inherent efficiency of high-volume processing on larger computers is called ____________________.

Accepted Answer

The answer of The inherent efficiency of high-volume processing on...

A repeating group is a set of one or more fields that can occur only once in a single record, with each occurrence having the same value.

Computers represent data as ____________________ that have only two possible values: zero (0) or one (1).

-In the table or file shown in the accompanying figure, a(n) ____________________ is a set of related fields that describes one instance, or occurrence of an entity.

A table design is in third normal form (3NF) if it is in 2NF and if all nonkey fields are dependent on other nonkey fields.

____ means that a system can be expanded, modified, or downsized easily to meet the rapidly changing needs of a business enterprise.

A(n) ____________________ date is the total number of days from some specific base date.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A foreign key value that does not match an existing key in another table.

Because it supports virtually all languages, ____________________ has become a global standard.

One problem in a typical file-processing environment is the rigid data structure. _________________________

A(n) ____ is a set of letters or numbers that represents a data item.

Which of the following is the advantage of a DBMS (database management system)?

List at least 6 guidelines for developing a code.

-In the accompanying figure, any field that could serve as a primary key is called a ____.

In a file-oriented information system, a history file contains reference data used by the information system.

In a file-oriented information system, a master file ____.

____ is the process of converting readable data into unreadable characters to prevent unauthorized access to the data.

In a file-oriented information system, a table file is a file created for historical or archiving purposes.

To protect stored data, users can be asked to furnish a proper user ID and password to access a file or database.

-A(n) ____________________, such as that shown in the accompanying figure, contains a set of related records that store data about a specific entity.

The inherent efficiency of high-volume processing on larger computers is called ____________________.

Introduction to Systems Analysis and Design

Analyzing the Business Case

Managing Systems Projects

Requirements Modeling

Data and Process Modeling

Object Modeling

Development Strategies

User Interface Design

System Architecture

Managing Systems Implementation

Managing Systems Support and Security

Communication Tools

CASE Tools

Financial Analysis Tools

Internet Resource Tools

Filters

Exam 9: Data Design

A repeating group is a set of one or more fields that can occur only once in a single record, with each occurrence having the same value.

Computers represent data as ____________________ that have only two possible values: zero (0) or one (1).

-In the table or file shown in the accompanying figure, a(n) ____________________ is a set of related fields that describes one instance, or occurrence of an entity.

A table design is in third normal form (3NF) if it is in 2NF and if all nonkey fields are dependent on other nonkey fields.

____ means that a system can be expanded, modified, or downsized easily to meet the rapidly changing needs of a business enterprise.

A(n) ____________________ date is the total number of days from some specific base date.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A foreign key value that does not match an existing key in another table.

Because it supports virtually all languages, ____________________ has become a global standard.

One problem in a typical file-processing environment is the rigid data structure. _________________________

A(n) ____ is a set of letters or numbers that represents a data item.

Which of the following is the advantage of a DBMS (database management system)?

List at least 6 guidelines for developing a code.

-In the accompanying figure, any field that could serve as a primary key is called a ____.

In a file-oriented information system, a history file contains reference data used by the information system.

In a file-oriented information system, a master file ____.

____ is the process of converting readable data into unreadable characters to prevent unauthorized access to the data.

In a file-oriented information system, a table file is a file created for historical or archiving purposes.

To protect stored data, users can be asked to furnish a proper user ID and password to access a file or database.

-A(n) ____________________, such as that shown in the accompanying figure, contains a set of related records that store data about a specific entity.

The inherent efficiency of high-volume processing on larger computers is called ____________________.

Introduction to Systems Analysis and Design

Analyzing the Business Case

Managing Systems Projects

Requirements Modeling

Data and Process Modeling

Object Modeling

Development Strategies

User Interface Design

System Architecture

Managing Systems Implementation

Managing Systems Support and Security

Communication Tools

CASE Tools

Financial Analysis Tools

Internet Resource Tools

Filters