Question 1

Operational databases almost exclusively use the ________ structure.

Accepted Answer

relational

Question 2

Information assets are the new currency of business.

Accepted Answer

A) True 
 B)False  True

Question 3

Match the database realm to the appropriate activity.
-Database designer realm

Accepted Answer

A) Create database tables 
B) Update data 
C) Create database model 
A) Create database tables 
B) Update data 
C) Create database model C

Question 4

Match the database integrity rule to the appropriate definition.
-Rule 1: Entity Integrity

Accepted Answer

A) Each record in the database must have a unique identifier called a primary key. 
B) Data referenced and stored in related tables must be consistent across the database. 
C) The field values must be from a predefined domain. 
D) The primary key value cannot be null (empty). 
A) Each record in the database must have a unique identifier called a primary key. 
B) Data referenced and stored in related tables must be consistent across the database. 
C) The field values must be from a predefined domain. 
D) The primary key value cannot be null (empty).

Question 5

The database integrity rule Primary Key Integrity states each record in the database must have a unique identifier called a primary key.

Accepted Answer

A) True 
 B)False

Question 6

________ databases contain data collected by other organizations and agencies, such as the Securities and Exchange Commission (SEC).

Accepted Answer

The answer of ________ databases contain data collected by other...

Question 7

The largest provider of relational database tools is Sun Microsystems Inc.

Accepted Answer

A) True 
 B)False

Question 8

________ is a technique used to develop an anomaly-free database with database integrity.

Accepted Answer

Database m

Question 9

________ databases can be classified as (1)operational databases, (2)data warehouses, or (3)XBRL databases.

Accepted Answer

The answer of ________ databases can be classified as (1)operational...

Question 10

The database integrity rule Referential Integrity states that field values must be from a predefined domain.

Accepted Answer

A) True 
 B)False

Question 11

Database modeling may require additional investment of time as the database is being developed.

Accepted Answer

A) True 
 B)False

Question 12

The database ________ creates the database model.

Accepted Answer

The answer of The database ________ creates the database model....

Question 13

________ are a crucial component of the enterprise system, containing intellectual property.

Accepted Answer

The answer of ________ are a crucial component of the...

Question 14

The ________ database structure is used by data warehouses.

Accepted Answer

The answer of The ________ database structure is used by...

Question 15

Database anomalies are problems within a database table that result in inaccurate or incomplete data.

Accepted Answer

A) True 
 B)False

Question 16

Match the database integrity rule to the appropriate definition.
-Rule 4: Referential Integrity

Accepted Answer

A) Each record in the database must have a unique identifier called a primary key. 
B) Data referenced and stored in related tables must be consistent across the database. 
C) The field values must be from a predefined domain. 
D) The primary key value cannot be null (empty). 
A) Each record in the database must have a unique identifier called a primary key. 
B) Data referenced and stored in related tables must be consistent across the database. 
C) The field values must be from a predefined domain. 
D) The primary key value cannot be null (empty).

Question 17

The database ________ creates the database.

Accepted Answer

The answer of The database ________ creates the database....

Question 18

Database anomalies are removed through ________ and/or database modeling.

Accepted Answer

The answer of Database anomalies are removed through ________ and/or...

Question 19

Match the database integrity rule to the appropriate definition.
-Rule 3: Domain Integrity

Accepted Answer

A) Each record in the database must have a unique identifier called a primary key. 
B) Data referenced and stored in related tables must be consistent across the database. 
C) The field values must be from a predefined domain. 
D) The primary key value cannot be null (empty). 
A) Each record in the database must have a unique identifier called a primary key. 
B) Data referenced and stored in related tables must be consistent across the database. 
C) The field values must be from a predefined domain. 
D) The primary key value cannot be null (empty).

Question 20

Match the database integrity rule to the appropriate definition.
-Rule 2: Primary Key Integrity

Accepted Answer

A) Each record in the database must have a unique identifier called a primary key. 
B) Data referenced and stored in related tables must be consistent across the database. 
C) The field values must be from a predefined domain. 
D) The primary key value cannot be null (empty). 
A) Each record in the database must have a unique identifier called a primary key. 
B) Data referenced and stored in related tables must be consistent across the database. 
C) The field values must be from a predefined domain. 
D) The primary key value cannot be null (empty).

Operational databases almost exclusively use the ________ structure.

Information assets are the new currency of business.

Match the database realm to the appropriate activity. -Database designer realm

Match the database integrity rule to the appropriate definition. -Rule 1: Entity Integrity

The database integrity rule Primary Key Integrity states each record in the database must have a unique identifier called a primary key.

________ databases contain data collected by other organizations and agencies, such as the Securities and Exchange Commission (SEC).

The largest provider of relational database tools is Sun Microsystems Inc.

________ is a technique used to develop an anomaly-free database with database integrity.

________ databases can be classified as (1)operational databases, (2)data warehouses, or (3)XBRL databases.

The database integrity rule Referential Integrity states that field values must be from a predefined domain.

Database modeling may require additional investment of time as the database is being developed.

The database ________ creates the database model.

________ are a crucial component of the enterprise system, containing intellectual property.

The ________ database structure is used by data warehouses.

Database anomalies are problems within a database table that result in inaccurate or incomplete data.

Match the database integrity rule to the appropriate definition. -Rule 4: Referential Integrity

The database ________ creates the database.

Database anomalies are removed through ________ and/or database modeling.

Match the database integrity rule to the appropriate definition. -Rule 3: Domain Integrity

Match the database integrity rule to the appropriate definition. -Rule 2: Primary Key Integrity

Accounting Systems Insights

Accounting Databases

Accounting Interface: Database Forms, Queries, and Reports

Accounting Systems and Business Processes

Business Processes: Purchasing, Sales, and Payroll Cycles

Integrated Enterprise Systems and Cloud Computing

Accounting and Business Intelligence

Accounting and Sustainability Intelligence

XBRL: Intelligent Business Reporting

Fraud and Internal Control

Cybersecurity

The Risk Intelligent Enterprise: Enterprise Risk Management

Accounting System Development

Filters

Exam 14: Database Design: ERD, REA, and SQL

Operational databases almost exclusively use the ________ structure.

Information assets are the new currency of business.

Match the database realm to the appropriate activity. -Database designer realm

Match the database integrity rule to the appropriate definition. -Rule 1: Entity Integrity

The database integrity rule Primary Key Integrity states each record in the database must have a unique identifier called a primary key.

________ databases contain data collected by other organizations and agencies, such as the Securities and Exchange Commission (SEC).

The largest provider of relational database tools is Sun Microsystems Inc.

________ is a technique used to develop an anomaly-free database with database integrity.

________ databases can be classified as (1)operational databases, (2)data warehouses, or (3)XBRL databases.

The database integrity rule Referential Integrity states that field values must be from a predefined domain.

Database modeling may require additional investment of time as the database is being developed.

The database ________ creates the database model.

________ are a crucial component of the enterprise system, containing intellectual property.

The ________ database structure is used by data warehouses.

Database anomalies are problems within a database table that result in inaccurate or incomplete data.

Match the database integrity rule to the appropriate definition. -Rule 4: Referential Integrity

The database ________ creates the database.

Database anomalies are removed through ________ and/or database modeling.

Match the database integrity rule to the appropriate definition. -Rule 3: Domain Integrity

Match the database integrity rule to the appropriate definition. -Rule 2: Primary Key Integrity

Accounting Systems Insights

Accounting Databases

Accounting Interface: Database Forms, Queries, and Reports

Accounting Systems and Business Processes

Business Processes: Purchasing, Sales, and Payroll Cycles

Integrated Enterprise Systems and Cloud Computing

Accounting and Business Intelligence

Accounting and Sustainability Intelligence

XBRL: Intelligent Business Reporting

Fraud and Internal Control

Cybersecurity

The Risk Intelligent Enterprise: Enterprise Risk Management

Accounting System Development

Filters