Question 1

In a REA model, an agent is related to a resource through an event.

Accepted Answer

A) True 
 B)False

Question 2

In an ERD diagram, relationship cardinality 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 3

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 4

Which of the following is a way to collect information about business transactions?

Accepted Answer

A) Interviewing users 
B) Reviewing source documents 
C) Observing procedures 
D) All the above 
A) Interviewing users 
B) Reviewing source documents 
C) Observing procedures 
D) All the above

Question 5

In an REA model, entities are business objects or events.

Accepted Answer

A) True 
 B)False

Question 6

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 7

What are the steps for designing an ERD?

Accepted Answer

Step 1: Determine the relevant business

Question 8

What is the purpose of an entity relationship diagram?

Accepted Answer

An entity relationship diagram

Question 9

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

Accepted Answer

Step 1: Determine the relevant business

Question 10

For an ERD, what do the business rules define?

Accepted Answer

A) Entities 
B) Business transactions 
C) Attribute limitations 
D) Entity attributes 
A) Entities 
B) Business transactions 
C) Attribute limitations 
D) Entity attributes

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

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

Accepted Answer

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

Question 13

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

Accepted Answer

To identify entity relationships in a sp

Question 14

List the ERD design steps that are dependent on the database structure.

Accepted Answer

Step 7: Add business-related a

Question 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

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

Question 17

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

Accepted Answer

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

Question 18

List and define the first three normalization rules.

Accepted Answer

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

Question 19

In a REA model, a resource has an intangible value.

Accepted Answer

A) True 
 B)False

Question 20

When using normalization for database development, all the attributes are placed in

Accepted Answer

A) Three large tables 
B) Two huge tables 
C) One large table 
D) B and C 
A) Three large tables 
B) Two huge tables 
C) One large table 
D) B and C

In a REA model, an agent is related to a resource through an event.

In an ERD diagram, relationship cardinality is represented as

How are business entities and their relationships identified?

Which of the following is a way to collect information about business transactions?

In an REA model, entities are business objects or events.

In an ERD diagram, an entity identifier is represented as

What are the steps for designing an ERD?

What is the purpose of an entity relationship diagram?

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

For an ERD, what do the business rules define?

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

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

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

List the ERD design steps that are dependent on the database structure.

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

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

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

List and define the first three normalization rules.

In a REA model, a resource has an intangible value.

When using normalization for database development, all the attributes are placed in

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

In a REA model, an agent is related to a resource through an event.

In an ERD diagram, relationship cardinality is represented as

How are business entities and their relationships identified?

Which of the following is a way to collect information about business transactions?

In an REA model, entities are business objects or events.

In an ERD diagram, an entity identifier is represented as

What are the steps for designing an ERD?

What is the purpose of an entity relationship diagram?

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

For an ERD, what do the business rules define?

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

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

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

List the ERD design steps that are dependent on the database structure.

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

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

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

List and define the first three normalization rules.

In a REA model, a resource has an intangible value.

When using normalization for database development, all the attributes are placed in

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