Question 1

In building an ERD, in which step is the database application chosen?

Accepted Answer

A) Step 2: Determine the business rules for a specific business transaction. 
B) Step 7: Add business-related attributes to the ERD. 
C) Step 9: Develop relational database tables. 
D) Step 10: Build relational database tables. 
A) Step 2: Determine the business rules for a specific business transaction. 
B) Step 7: Add business-related attributes to the ERD. 
C) Step 9: Develop relational database tables. 
D) Step 10: Build relational database tables.

Question 2

What is the difference between a procedural programming language and a non-procedural programming language?

Accepted Answer

In a procedural programming language, th

Question 3

In a REA model, the relationship between the two events is called economic duality and represents resource exchange.

Accepted Answer

A) True 
 B)False

Question 4

In a one-to-many relationship in an ERD, the entity on the one side (customer)is called a ________ entity and the entity on the many side (sales order)is called a ________ entity.

Accepted Answer

Parent, ch

Question 5

The REA model shows what is given and what is taken in a business exchange.

Accepted Answer

A) True 
 B)False

Question 6

SQL DML statements are used to build queries required for accounting and financial applications.

Accepted Answer

A) True 
 B)False

Question 7

________ 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 8

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

Accepted Answer

A) Create 
B) Select 
C) Alter 
D) Drop 
A) Create 
B) Select 
C) Alter 
D) Drop

Question 9

List and define the first three normalization rules.

Accepted Answer

Rule 1: First Normal Form (1NF). No fiel

Question 10

The ________ database structure is used by data warehouses.

Accepted Answer

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

Question 11

What are the steps for designing an ERD?

Accepted Answer

Step 1: Determine the relevant business

Question 12

Why does a database designer need to understand a business's rules?

Accepted Answer

To identify entity relationships in a sp

Question 13

Which of the following is not a database anomaly?

Accepted Answer

A) Update 
B) Commit 
C) Deletion 
D) Insertion 
A) Update 
B) Commit 
C) Deletion 
D) Insertion

Question 14

________ store data that is analyzed for business intelligence to enhance tactical and strategic decision making.

Accepted Answer

The answer of ________ store data that is analyzed for...

Question 15

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 16

In an ERD diagram, an entity identifier 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 17

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

Accepted Answer

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

Question 18

Which REA diagraming rule states every event entity must relate to a resource entity?

Accepted Answer

A) Rule 1. Resource-event relationship 
B) Rule 2. Event-event relationship 
C) Rule 3. Agent-event relationship 
D) Rule 4. Agent-agent relationship 
A) Rule 1. Resource-event relationship 
B) Rule 2. Event-event relationship 
C) Rule 3. Agent-event relationship 
D) Rule 4. Agent-agent relationship

Question 19

The database ________ creates the database model.

Accepted Answer

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

Question 20

What is data modeling?

Accepted Answer

Data modeling, is a technique used to de

In building an ERD, in which step is the database application chosen?

What is the difference between a procedural programming language and a non-procedural programming language?

In a REA model, the relationship between the two events is called economic duality and represents resource exchange.

In a one-to-many relationship in an ERD, the entity on the one side (customer)is called a entity and the entity on the many side (sales order)is called a entity.

The REA model shows what is given and what is taken in a business exchange.

SQL DML statements are used to build queries required for accounting and financial applications.

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

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

List and define the first three normalization rules.

The ________ database structure is used by data warehouses.

What are the steps for designing an ERD?

Why does a database designer need to understand a business's rules?

Which of the following is not a database anomaly?

________ store data that is analyzed for business intelligence to enhance tactical and strategic decision making.

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

In an ERD diagram, an entity identifier is represented as

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

Which REA diagraming rule states every event entity must relate to a resource entity?

The database ________ creates the database model.

What is data 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

In building an ERD, in which step is the database application chosen?

What is the difference between a procedural programming language and a non-procedural programming language?

In a REA model, the relationship between the two events is called economic duality and represents resource exchange.

In a one-to-many relationship in an ERD, the entity on the one side (customer)is called a ________ entity and the entity on the many side (sales order)is called a ________ entity.

The REA model shows what is given and what is taken in a business exchange.

SQL DML statements are used to build queries required for accounting and financial applications.

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

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

List and define the first three normalization rules.

The ________ database structure is used by data warehouses.

What are the steps for designing an ERD?

Why does a database designer need to understand a business's rules?

Which of the following is not a database anomaly?

________ store data that is analyzed for business intelligence to enhance tactical and strategic decision making.

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

In an ERD diagram, an entity identifier is represented as

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

Which REA diagraming rule states every event entity must relate to a resource entity?

The database ________ creates the database model.

What is data 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

In a one-to-many relationship in an ERD, the entity on the one side (customer)is called a entity and the entity on the many side (sales order)is called a entity.