Question 1

List and define three database anomalies.

Accepted Answer

Deletion - Deleting one record may cause deletion of unintended relevant information.
Update - Updating data requires updating multiple records.
Insertion - Inserting a record is prevented if the primary key value is unknown.

Question 2

Well-designed databases and queries determine whether accounting professionals are able to retrieve accurate accounting data.

Accepted Answer

A) True 
 B)False  True

Question 3

For a single occurrence of one entity (one customer), cardinality defines the maximum and minimum number of occurrences that might relate to the other entity (sales orders).

Accepted Answer

A) True 
 B)False  True

Question 4

________ rules define attribute limitations, referential integrity, and cardinality of relationships among entities.

Accepted Answer

The answer of ________ rules define attribute limitations, referential integrity,...

Question 5

Match the database integrity rule to the appropriate definition.
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 primary key value cannot be null (empty).
D)The field values must be from a predefined domain.
-Rule 2: Primary Key Integrity

Accepted Answer

The answer of Match the database integrity rule to the...

Question 6

Which of the following is an example of a Data Definition Language command?

Accepted Answer

A) Insert 
B) Update 
C) Drop 
D) Delete 
A) Insert 
B) Update 
C) Drop 
D) Delete

Question 7

How are business entities and their relationships identified?

Accepted Answer

A) Determining the business rules for business transactions 
B) Determining the entity identifiers 
C) Normalizing the database 
D) Analyzing business transactions 
A) Determining the business rules for business transactions 
B) Determining the entity identifiers 
C) Normalizing the database 
D) Analyzing business transactions

Question 8

In database modeling performed in the database designer realm, the term entity can refer to

Accepted Answer

A) Place 
B) Event 
C) Object 
D) B and C 
A) Place 
B) Event 
C) Object 
D) B and C

Question 9

Which of the following statements about SQL is false?

Accepted Answer

A) SQL is a nonprocedural language. 
B) SQL is a procedural language. 
C) SQL can query many records from one or more tables with a single statement. 
D) SQL can manipulate relational database object. 
A) SQL is a nonprocedural language. 
B) SQL is a procedural language. 
C) SQL can query many records from one or more tables with a single statement. 
D) SQL can manipulate relational database object.

Question 10

Which symbol represents a cardinality of a maximum: many and minimum: 0?

Accepted Answer

A)    
B)    
C)    
D)    
A)    
B)    
C)    
D)

Question 11

In an ERD diagram, a relationship between entities is represented as

Accepted Answer

A) PK symbol listed by attribute 
B) Connector lines 
C) Square box 
D) Crow's feet symbols 
A) PK symbol listed by attribute 
B) Connector lines 
C) Square box 
D) Crow's feet symbols

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

In designer terminology, for a one-to-one relationship, the maximum occurrence possible for each entity is one.

Accepted Answer

A) True 
 B)False

Question 14

List the ERD design steps that are independent of the database structure.

Accepted Answer

Step 1: Determine the relevant business

Question 15

Match the database realm to the appropriate activity.
A)Update data
B)Create database tables
C)Create database model
-Database designer realm

Accepted Answer

The answer of Match the database realm to the appropriate...

Question 16

All the entity identifiers that uniquely identify the entity are called ________ keys in the database builder realm.

Accepted Answer

The answer of All the entity identifiers that uniquely identify...

Question 17

In the REA model, the ________ event compensates the consumed resource with a different or same type of resource.

Accepted Answer

A) Purchasing 
B) Buying 
C) Giving 
D) Taking 
A) Purchasing 
B) Buying 
C) Giving 
D) Taking

Question 18

Match the ERD symbols to the definition.
A)Entity relationship
B)Entity identifier
C)Relationship cardinality
D)Entity
E)Entity Attributes
-

Accepted Answer

The answer of Match the ERD symbols to the definition.
A)Entity...

Question 19

Which symbol represents a cardinality of a maximum: 1 and minimum: 0?

Accepted Answer

A)    
B)    
C)    
D)    
A)    
B)    
C)    
D)

Question 20

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

Accepted Answer

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

List and define three database anomalies.

Well-designed databases and queries determine whether accounting professionals are able to retrieve accurate accounting data.

For a single occurrence of one entity (one customer), cardinality defines the maximum and minimum number of occurrences that might relate to the other entity (sales orders).

________ rules define attribute limitations, referential integrity, and cardinality of relationships among entities.

Which of the following is an example of a Data Definition Language command?

How are business entities and their relationships identified?

In database modeling performed in the database designer realm, the term entity can refer to

Which of the following statements about SQL is false?

Which symbol represents a cardinality of a maximum: many and minimum: 0?

In an ERD diagram, a relationship between entities is represented as

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

In designer terminology, for a one-to-one relationship, the maximum occurrence possible for each entity is one.

List the ERD design steps that are independent of the database structure.

Match the database realm to the appropriate activity. A)Update data B)Create database tables C)Create database model -Database designer realm

All the entity identifiers that uniquely identify the entity are called ________ keys in the database builder realm.

In the REA model, the ________ event compensates the consumed resource with a different or same type of resource.

Match the ERD symbols to the definition. A)Entity relationship B)Entity identifier C)Relationship cardinality D)Entity E)Entity Attributes -

Which symbol represents a cardinality of a maximum: 1 and minimum: 0?

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

Accounting Systems Insights

XBRL: Intelligent Business Reporting

Accounting and Sustainability Intelligence

Accounting and Business Intelligence

Integrated Enterprise Systems

Business Processes: Purchasing, Sales, and Payroll Cycles

Accounting Systems and Business Processes

Accounting Interface: Database Forms, Queries, and Reports

Accounting Databases

Accounting System Development

The Risk Intelligent Enterprise: Enterprise Risk Management

Cybersecurity

Fraud and Internal Control

Filters

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

List and define three database anomalies.

Well-designed databases and queries determine whether accounting professionals are able to retrieve accurate accounting data.

For a single occurrence of one entity (one customer), cardinality defines the maximum and minimum number of occurrences that might relate to the other entity (sales orders).

________ rules define attribute limitations, referential integrity, and cardinality of relationships among entities.

Which of the following is an example of a Data Definition Language command?

How are business entities and their relationships identified?

In database modeling performed in the database designer realm, the term entity can refer to

Which of the following statements about SQL is false?

Which symbol represents a cardinality of a maximum: many and minimum: 0?

In an ERD diagram, a relationship between entities is represented as

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

In designer terminology, for a one-to-one relationship, the maximum occurrence possible for each entity is one.

List the ERD design steps that are independent of the database structure.

Match the database realm to the appropriate activity. A)Update data B)Create database tables C)Create database model -Database designer realm

All the entity identifiers that uniquely identify the entity are called ________ keys in the database builder realm.

In the REA model, the ________ event compensates the consumed resource with a different or same type of resource.

Match the ERD symbols to the definition. A)Entity relationship B)Entity identifier C)Relationship cardinality D)Entity E)Entity Attributes -

Which symbol represents a cardinality of a maximum: 1 and minimum: 0?

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

Accounting Systems Insights

XBRL: Intelligent Business Reporting

Accounting and Sustainability Intelligence

Accounting and Business Intelligence

Integrated Enterprise Systems

Business Processes: Purchasing, Sales, and Payroll Cycles

Accounting Systems and Business Processes

Accounting Interface: Database Forms, Queries, and Reports

Accounting Databases

Accounting System Development

The Risk Intelligent Enterprise: Enterprise Risk Management

Cybersecurity

Fraud and Internal Control

Filters