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.

Question 2

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

Accepted Answer

The answer of What is the difference between a procedural...

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

The answer of In a one-to-many relationship in an ERD,...

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

Question 9

List and define the first three normalization rules.

Accepted Answer

The answer of List and define the first three normalization...

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

The answer of What are the steps for designing an...

Question 12

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

Accepted Answer

The answer of Why does a database designer need to...

Question 13

Which of the following is not a database anomaly?

Accepted Answer

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

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

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

The answer of What is data modeling?...

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?