Question 1

With the centralized database approach to data management, we expect to have:

Accepted Answer

A)  increased data storage costs 
B)  improved data integrity 
C)  increased data redundancy 
D)  greater difficulty in performing file maintenance 
A)  increased data storage costs 
B)  improved data integrity 
C)  increased data redundancy 
D)  greater difficulty in performing file maintenance

Question 2

In a network database model, data are logically organized into two-dimensional tables.

Accepted Answer

A) True 
 B)False

Question 3

Database table ______________________________ each store one specific attribute of the type of things stored in a table.

Accepted Answer

The answer of Database table ______________________________ each store one specific...

Question 4

A table is in ______________________________ if it is in first normal form and no non-key attribute is dependent on only a portion of the primary key.

Accepted Answer

second nor

Question 5

Each relationship in an E-R diagram has a ____ that shows the degree to which each entity participates in the relationship.

Accepted Answer

A)  maximum cardinality 
B)  identifier 
C)  cardinality 
D)  primary key 
A)  maximum cardinality 
B)  identifier 
C)  cardinality 
D)  primary key

Question 6

Which of the following database types has dominance in organizations?

Accepted Answer

A)  relational 
B)  object-oriented 
C)  network 
D)  hierarchical 
A)  relational 
B)  object-oriented 
C)  network 
D)  hierarchical

Question 7

Transform the relation in Figure TB 5.5 to third normal form (3NF). Label each new relation with a name that describes the attributes.
 $\text { Customers }$ 
$\begin{array}{|r|l|l|l|l|l|l|}
\hline \text { Number } & \begin{array}{c}
\text { First } \
\text { Name }
\end{array} & {\begin{array}{c}
\text { Last } \
\text { Name }
\end{array}} & {\text { Address }} & {\text { City }} & \text { State } & {\begin{array}{c}
\text { Zip } \
\text { Code }
\end{array}} \
\hline 104 & \text { Joln } & \text { Welch } & 123 \text { East St. } & \text { Ocoee } & \text { FL } & 32761 \
106 & \text { Mary } & \text { Best } & 745 \text { Webster Lare } & \text { Pensacola } & \text { FL } & 32809 \
106 & \text { Adam } & \text { Camp } & 4842 \text { Highand } & \text { Orange Lake } & \text { FL } & 32681 \
107 & \text { Patrick } & \text { Gaston } & 54 \text { Randh Road } & \text { Pensacola } & \text { FL } & 32809 \
100 & \text { Jaric } & \text { Lambert } & 27 \text { Rabin Hood } & \text { Orange Lake } & \text { FL } & 32681 \
\hline
\end{array}$
$\text { Figure TB } 5.5 \text { Relation in Second Normal Form (2NF) }$

Accepted Answer

The answer of Transform the relation in Figure TB 5.5...

Question 8

An attribute is equivalent to a field and may also be known as a row.

Accepted Answer

A) True 
 B)False

Question 9

The ______________________________ is the way data is actually stored on computer hardware.

Accepted Answer

The answer of The ______________________________ is the way data is...

Question 10

A(n) ______________________________ is a computer hardware and software system that mimics the human brain's ability to recognize patterns or predict outcomes using less-than-complete information.

Accepted Answer

neural net

Question 11

The feature of a database management system that enables nontechnical users to access a database and to produce inquiry reports is the:

Accepted Answer

A)  Schema 
B)  query language 
C)  Subschema 
D)  logical database view 
A)  Schema 
B)  query language 
C)  Subschema 
D)  logical database view

Question 12

In the applications approach to business event processing, a data change in one application before updating another application could lead to:

Accepted Answer

A)  data redundancy 
B)  inconsistent data 
C)  data integrity 
D)  data deletion 
A)  data redundancy 
B)  inconsistent data 
C)  data integrity 
D)  data deletion

Question 13

______________________________ is the use of information systems facilities to focus on the collection, organization, integration, and long-term storage of entity-wide data.

Accepted Answer

The answer of ______________________________ is the use of information systems...

Question 14

Grouping or categorizing data according to common attributes is called:

Accepted Answer

A)  coding data 
B)  filing data 
C)  classifying data 
D)  updating data 
A)  coding data 
B)  filing data 
C)  classifying data 
D)  updating data

Question 15

In set theory, a two-dimensional collection of information is called a(n) ______________________________.

Accepted Answer

The answer of In set theory, a two-dimensional collection of...

Question 16

A company uses a 7-digit number to identify customers. For example, the customer 1532789 indicates the following information: digits 1-2, state, 15 = Georgia
Digit 3, type of organization, 3 = government agency
Digit 4, credit terms, 2 = 2/10, n/30
Digits 5-7, unique customer identifier, 789
This type of coding scheme is:

Accepted Answer

A)  hierarchical 
B)  block 
C)  significant digit 
D)  sequential 
A)  hierarchical 
B)  block 
C)  significant digit 
D)  sequential

Question 17

Systems that decouple data from system applications are often referred to as having ______________________________ architecture.

Accepted Answer

The answer of Systems that decouple data from system applications...

Question 18

In set theory, a two-dimensional collection of information is called a relation.

Accepted Answer

A) True 
 B)False

Question 19

In the network database model, a child record can have more than one parent record.

Accepted Answer

A) True 
 B)False

Question 20

Data flows that mirror and monitor business operations are called ____ flows.

Accepted Answer

A)  horizontal information 
B)  vertical information 
C)  Sequential 
D)  master data 
A)  horizontal information 
B)  vertical information 
C)  Sequential 
D)  master data

With the centralized database approach to data management, we expect to have:

In a network database model, data are logically organized into two-dimensional tables.

Database table ______________________________ each store one specific attribute of the type of things stored in a table.

A table is in ______________________________ if it is in first normal form and no non-key attribute is dependent on only a portion of the primary key.

Each relationship in an E-R diagram has a ____ that shows the degree to which each entity participates in the relationship.

Which of the following database types has dominance in organizations?

An attribute is equivalent to a field and may also be known as a row.

The ______________________________ is the way data is actually stored on computer hardware.

A(n) ______________________________ is a computer hardware and software system that mimics the human brain's ability to recognize patterns or predict outcomes using less-than-complete information.

The feature of a database management system that enables nontechnical users to access a database and to produce inquiry reports is the:

In the applications approach to business event processing, a data change in one application before updating another application could lead to:

______________________________ is the use of information systems facilities to focus on the collection, organization, integration, and long-term storage of entity-wide data.

Grouping or categorizing data according to common attributes is called:

In set theory, a two-dimensional collection of information is called a(n) ______________________________.

Systems that decouple data from system applications are often referred to as having ______________________________ architecture.

In set theory, a two-dimensional collection of information is called a relation.

In the network database model, a child record can have more than one parent record.

Data flows that mirror and monitor business operations are called ____ flows.

Introduction to Accounting Information Systems

Enterprise Systems

Electronic Business E-Business Systems

Documenting Information Systems

Relational Databases and SQL

Controlling Information Systems: Introduction to Enterprise Risk Management and Internal Control

Controlling Information Systems: Introduction to Pervasive Controls

Controlling Information Systems: Business Process and Application Controls

The Order Entrysales Oes Process

The Billingaccounts Receivablecash Receipts Barcr Process

The Purchasing Process

The Accounts Payablecash Disbursements Apcd Process

The Human Resources Process HR Management and Payroll Processes

Integrated Production Processes IPP

The General Ledger and Business Reporting GLBR Process

Acquiring and Implementing Accounting Information Systems

Filters

Exam 5: Database Management Systems

With the centralized database approach to data management, we expect to have:

In a network database model, data are logically organized into two-dimensional tables.

Database table ______________________________ each store one specific attribute of the type of things stored in a table.

A table is in ______________________________ if it is in first normal form and no non-key attribute is dependent on only a portion of the primary key.

Each relationship in an E-R diagram has a ____ that shows the degree to which each entity participates in the relationship.

Which of the following database types has dominance in organizations?

An attribute is equivalent to a field and may also be known as a row.

The ______________________________ is the way data is actually stored on computer hardware.

A(n) ______________________________ is a computer hardware and software system that mimics the human brain's ability to recognize patterns or predict outcomes using less-than-complete information.

The feature of a database management system that enables nontechnical users to access a database and to produce inquiry reports is the:

In the applications approach to business event processing, a data change in one application before updating another application could lead to:

______________________________ is the use of information systems facilities to focus on the collection, organization, integration, and long-term storage of entity-wide data.

Grouping or categorizing data according to common attributes is called:

In set theory, a two-dimensional collection of information is called a(n) ______________________________.

Systems that decouple data from system applications are often referred to as having ______________________________ architecture.

In set theory, a two-dimensional collection of information is called a relation.

In the network database model, a child record can have more than one parent record.

Data flows that mirror and monitor business operations are called ____ flows.

Introduction to Accounting Information Systems

Enterprise Systems

Electronic Business E-Business Systems

Documenting Information Systems

Relational Databases and SQL

Controlling Information Systems: Introduction to Enterprise Risk Management and Internal Control

Controlling Information Systems: Introduction to Pervasive Controls

Controlling Information Systems: Business Process and Application Controls

The Order Entrysales Oes Process

The Billingaccounts Receivablecash Receipts Barcr Process

The Purchasing Process

The Accounts Payablecash Disbursements Apcd Process

The Human Resources Process HR Management and Payroll Processes

Integrated Production Processes IPP

The General Ledger and Business Reporting GLBR Process

Acquiring and Implementing Accounting Information Systems

Filters