Question 1

How many types of relationships are possible between entities?

Accepted Answer

There are three main types of relationships between entities: one-to-one, one-to-many, and many-to-many.

Question 2

Identify the statement below that is false with respect to cardinalities.

Accepted Answer

The maximum cardinality represents the maximum number of instances of one entity that can be associated with a single instance of another entity in a relationship. It can be one or many, but not zero. Zero would imply no relationship exists, which contradicts the concept of establishing a cardinality in the first place.

Question 3

Every company can have more than one banking relationships,and each bank can have a business relationship with more than one company.Thus,the cardinality that exists between company and bank is

Accepted Answer

Since each company can have multiple banking relationships and each bank can have relationships with multiple companies, the cardinality between company and bank is many-to-many.

Question 4

Which of the following statements is false regarding REA diagrams?

Accepted Answer

Redrawing an REA diagram several times during development is actually common and expected, as it is part of the iterative process of data modeling and refining the diagram to accurately represent the organization's business processes.

Question 5

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

Accepted Answer

An event can involve multiple agents, hence the cardinality pattern would be 1:N. On the other hand, an agent can be involved in multiple events too, so it cannot be 0:1. The option of 0:N is also possible, but since an event should have at least one agent involved, the minimum cardinality is set to 1. Therefore, the standard cardinality pattern for a relationship between an event and an agent is 1:N.

Question 6

Which of the following graphical symbols represents a minimum cardinality of one and a maximum cardinality of one?

Accepted Answer

The symbol in choice B represents a one-to-one relationship, meaning that each occurrence on one side is associated with only one occurrence on the other side. The other symbols represent one-to-many, many-to-one, or many-to-many relationships.

Question 7

Identify the minimum cardinality of any REA diagram relationship.

Accepted Answer

REA diagrams use the minimum cardinality of 0 or 1.

Question 8

Which of the following graphical symbols represents a minimum cardinality of zero and a maximum cardinality of many?

Accepted Answer

The answer of Which of the following graphical symbols represents...

Question 9

The maximum cardinality of any REA diagram relationship is

Accepted Answer

The maximum cardinality of a relationship in an REA diagram can be either one or many, as an entity can have multiple relationships with other entities. However, it cannot be zero, as there must be a connection between entities in the diagram. Additionally, it cannot be "none" as this is not a valid option for cardinality in database design.

Question 10

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 11

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

As stated in the question, every citizen in the United States has one social security number, and no two citizens have the same social security number. This means that each social security number is uniquely tied to one citizen, and each citizen has only one social security number. Therefore, the cardinality between social security numbers and citizens is one-to-one.

Question 12

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

Accepted Answer

The internal agents are the resources, such as equipment, inventory, cash, etc., while the external agents are the entities, such as customers, suppliers, creditors, etc. Therefore, each event in an REA model will have at least one internal (resource) agent and one external (entity) agent involved in the event. Thus option D is the correct answer.

Question 13

What is Cardinalities?

Accepted Answer

The answer of What is Cardinalities?...

Question 14

Which of the following graphical symbols represents a minimum cardinality of one and a maximum cardinality of many?

Accepted Answer

The answer of Which of the following graphical symbols represents...

Question 15

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 16

Identify the most likely relationship where cardinalities have zero minimums and N maximums.

Accepted Answer

The answer of Identify the most likely relationship where cardinalities...

Question 17

Which of the following graphical symbols represents a minimum cardinality of zero and a maximum cardinality of one?

Accepted Answer

The answer of Which of the following graphical symbols represents...

Question 18

The first step in developing an REA diagram for a specific transaction cycle begins with identifying

Accepted Answer

The first step in developing an REA diagram for a specific transaction cycle is to identify the relevant events, such as sales, purchases, and payments. These events are the key drivers of the transaction cycle and help define the flow of resources and information within the system. The other elements, such as agents involved, resources affected, and relationship cardinalities, are all important, but they are typically identified after the events have been identified.

Question 19

Which of the following statements is true about the development of an REA model?

Accepted Answer

The main objective of the REA (resources, events, agents) model is to model basic value-chain activities. It is not focused on data entry events or information retrieval events. The REA diagram models the flow of resources, the events that impact those resources, and the agents involved in those events.

Question 20

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

Since every person can have more than one friend and can be a friend to more than one person, the cardinality between friends and people is many-to-many.

Quiz 17: Database Design Using the Rea Data Model

How many types of relationships are possible between entities?

Identify the statement below that is false with respect to cardinalities.

Every company can have more than one banking relationships,and each bank can have a business relationship with more than one company.Thus,the cardinality that exists between company and bank is

Which of the following statements is false regarding REA diagrams?

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

Which of the following graphical symbols represents a minimum cardinality of one and a maximum cardinality of one?

Identify the minimum cardinality of any REA diagram relationship.

Which of the following graphical symbols represents a minimum cardinality of zero and a maximum cardinality of many?

The maximum cardinality of any REA diagram relationship is

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

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

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

What is Cardinalities?

Which of the following graphical symbols represents a minimum cardinality of one and a maximum cardinality of many?

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

Identify the most likely relationship where cardinalities have zero minimums and N maximums.

Which of the following graphical symbols represents a minimum cardinality of zero and a maximum cardinality of one?

The first step in developing an REA diagram for a specific transaction cycle begins with identifying

Which of the following statements is true about the development of an REA model?

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