Question 1

Relationships that affect the quantity of a resource are sometimes referred to as ________ relationships.

Accepted Answer

Relationships that affect the quantity of a resource are referred to as stockflow relationships, as they involve the movement or flow of a stock or quantity of a resource between two parties. Commitment, exchange, and duality are other types of relationships that may exist between parties, but they do not necessarily involve changes in the quantity or stock of a resource.

Question 2

What is the minimum number of external agents that must participate in each REA event?

Accepted Answer

The answer of What is the minimum number of external...

Question 3

Which is a true statement about the REA data model?

Accepted Answer

The REA data model classifies entities into three distinct categories: Resources, Events, and Agents.

Question 4

What is the minimum number of agents that must participate in each REA event?

Accepted Answer

The answer of What is the minimum number of agents...

Question 5

The "get" event represents an activity which

Accepted Answer

The "get" event indicates an increase in the organization's stock of an economic resource, which could be through various means such as purchase, acquisition, or production. Option A refers to a promise, which is not an activity, and option C refers to a decrease in resources, which is opposite to the "get" event. Option D refers to an incorrect statement.

Question 6

Identify the item below that would be classified as a resource by the REA data model.

Accepted Answer

An IOU from a customer represents a claim to future economic benefit and would be classified as a resource by the REA data model.

Question 7

Each event in an REA model will in most cases have at least one ________ agent and one ________ agent involved with the event.

Accepted Answer

In an REA model, events refer to activities that change the state of resources or entities. Agents are the individuals or organizations that participate in events. An event is usually initiated by an internal agent, such as an employee or a department, and involves at least one external agent, such as a customer, supplier, or other business partner. Therefore, the best choice is D.

Question 8

An REA diagram must link every event to at least one ________ and two ________.

Accepted Answer

An REA diagram (Resources, Events, Agents) must link every event to at least one resource and two agents, reflecting the economic model that tracks resources, the events that affect them, and the agents who participate in the events.

Question 9

Describe an REA data model.

Accepted Answer

The answer of Describe an REA data model....

Question 10

REA models are usually depicted in which diagramming form?

Accepted Answer

REA models are typically depicted using entity-relationship diagrams, which show the relationships between entities, such as resources, events, and agents, and the flows of resources between them. Decision tree diagrams are used to illustrate decision-making processes, if-then diagrams are used for logical statements, and stock-flow diagrams are used to represent dynamic systems.

Question 11

Identify the item below that would be classified as an event by the REA data model.

Accepted Answer

A customer sale is an example of an event in the REA data model as it involves an exchange of goods or services between parties. Option A refers to a liability and Option B refers to a person or position and thus cannot be classified as events in the REA data model. Option D suggests that there is no answer, which is incorrect.

Question 12

Assume that you are looking at a REA diagram that depicts only one event.Which of the following must be on the REA diagram?

Accepted Answer

The answer of Assume that you are looking at a...

Question 13

Every person in the world has a birthdate,but no person has more than one birthdate.Thus,the cardinality that exists between birthdate and people is

Accepted Answer

Each birthdate can be shared by many people, but each person has only one birthdate, making it a one-to-many relationship.

Question 14

The "give" event represents an activity which

Accepted Answer

The "give" event involves the act of providing or transferring something to another party, which often results in a reduction of the organization's stock of a resource that has economic value. This is in contrast to the "receive" event, which involves an increase in the organization's stock of an economic resource. The "give" event does not necessarily involve a promise to engage in future economic exchanges, as this would depend on the specific context of the event. Therefore, option C is the best choice.

Question 15

Identify the item below that would be classified as an agent by the REA data model.

Accepted Answer

In the REA data model, an agent is a person or entity that can make economic decisions, such as buying or selling goods or services. The CFO, as a person responsible for financial affairs of the organization, would be considered an agent in this context. A) an IOU from a customer would be classified as a liability; C) a customer sale would be classified as an exchange event. D) "none of the above" is not the correct answer in this case.

Question 16

Every person in the world can have more than one friend,and each person in the world can be a friend to more than one person.Thus,the cardinality that exists between friends and people is

Accepted Answer

This is because each person can have multiple friends and each friend can have multiple people they consider their friend. Therefore, there is not a one-to-one relationship between friends and people, and it is not one-to-many because one person can have more than one friend. The only option left is many-to-many.

Question 17

Every citizen in the United States has one social security number,but no two citizens have the same social security number.Thus,the cardinality that exists between social security numbers and citizens is

Accepted Answer

The relationship between social security numbers and citizens is a one-to-one relationship because one social security number can only be assigned to one citizen and each citizen can only have one social security number.

Question 18

What is the standard cardinality pattern for a relationship between an event and an agent?

Accepted Answer

An event can have multiple agents participating in it (1:N), for example, multiple actors participating in a movie shooting, multiple athletes participating in a sports event, etc. Similarly, an agent can participate in multiple events (1:N), for example, an actor can have multiple movie shootings, an athlete can participate in multiple sports events, etc. Therefore, the best choice for the cardinality pattern between an event and an agent is 1:N.

Question 19

Identify the notation below that is not used to represent cardinality information.

Accepted Answer

DFD (Data Flow Diagram) does not use notation to represent cardinality information; it focuses on the flow of data within a system rather than relationships between data entities.

Question 20

Identify the notation often used to represent cardinality information.

Accepted Answer

Crow's feet notation, also known as Chen notation, is often used to represent cardinality information in ER diagrams. It uses crow's feet symbols on the lines connecting entities to indicate the relationship cardinality. For example, a "many" relationship from entity A to entity B would be represented by a crow's foot symbol on the line connecting the two entities.

Quiz 17: Database Design Using the Rea Data Model