Exam 17: Database Design Using the Rea Data Model

A) A lumber yard where customers may pay with cash for all purchases.
B) A buy-here-pay-here auto dealer where a car buyer sends monthly cash payments to the dealer.
C) A consulting firm that offers a variety of consulting services to other businesses.
D) A department store that allows customers to carry a balance and to make installment payments, if they choose.

Correct Answer

verified

Show Answer

A)

B)

C)

D)

Correct Answer

verified

Show Answer

A) one-to-one.
B) one-to-many.
C) many-to-many.
D) many-to-none.

Correct Answer

verified

Show Answer

Correct Answer

verified

Cardinalities describe the nat...

View Answer

Show Answer

A) includes a promise to engage in future economic exchanges.
B) increases the organization's stock of an economic resource.
C) reduces the organization's stock of a resource that has economic value.
D) reduces the organization's liabilities.

Correct Answer

verified

Show Answer

A) A lumber yard where customers may pay with cash for all purchases.
B) A buy-here-pay-here auto dealer where a car buyer sends monthly cash payments to the dealer.
C) A consulting firm that offers a variety of consulting services to other businesses.
D) A department store that allows customers to carry a balance and to make installment payments, if they choose.

Correct Answer

verified

Show Answer

Correct Answer

verified

Show Answer

A) Each organization will have its own unique REA diagram.
B) An REA diagram for a given organization will change over time.
C) Data modeling and REA diagram development involve complex and repetitive processes.
D) Redrawing an REA diagram several times during development is uncommon.

Correct Answer

verified

Show Answer

A) standardizing source document format.
B) identifying non-value added activities.
C) storing financial and nonfinancial data in the same database.
D) organizing data to simplify data retrieval and analysis.

Correct Answer

verified

Show Answer

A) REA diagram.
B) data diagram.
C) ERP diagram.
D) ER diagram.

Correct Answer

verified

Show Answer

A) only in the systems analysis stage
B) only in the conceptual design stage
C) in both the systems analysis and design stages
D) neither the systems analysis nor the design stages

Correct Answer

verified

Show Answer

A) Each sale is associated with a single order, and there is a time lag between the time an order is taken and delivery of the product.
B) Each sale can be comprised of multiple orders, and each order can be associated with multiple sales or no sales.
C) Each sale can be comprised of multiple orders, and each order can be associated with one or more sales.
D) Each sale is associated with a single order, and there is no time lag between the time an order is taken and delivery of the product.

Correct Answer

verified

Show Answer

A) commitment
B) exchange
C) stockflow
D) duality

Correct Answer

verified

Show Answer

A) implementation and conversion.
B) data modeling.
C) database operation and maintenance.
D) system auditing.

Correct Answer

verified

Show Answer

A) includes a promise to engage in future economic exchanges.
B) increases the organization's stock of an economic resource.
C) reduces the organization's stock of a resource that has economic value.
D) increases the organization's liabilities.

Correct Answer

verified

Show Answer

A) is used in many areas of business and science.
B) was developed specifically for use in designing accounting information systems.
C) classifies data into relationships, entities and accounts.
D) is a graphical technique for portraying a database schema.

Correct Answer

verified

Show Answer

A) UML.
B) (Min, Max) .
C) DFD.
D) Maximums only.

Correct Answer

verified

Show Answer

A) internal; resource
B) external; entity
C) internal; employee
D) internal; external

Correct Answer

verified

Show Answer