What is REA data model

The REA data model was developed specifically for use in designing accounting information systems. It focuses on business semantics underlying an organization’s value chain activities. It provides guidance for identifying the entities to be included in a database and structuring the relationships among the entities.

What is the REA model What does it mean for accountants?

Resources, events, agents (REA) is a model of how an accounting system can be re-engineered for the computer age. REA was originally proposed in 1982 by William E. McCarthy as a generalized accounting model, and contained the concepts of resources, events and agents (McCarthy 1982).

What is the REA core pattern?

REA core pattern is a conceptual structure of relationships between the resources, events, and agents that constitute the transactional/transformational core of an economic exchange/conversion process.

What are three basic types of entities in Rea?

– The REA data model prescribes a basic pattern for how the three types of entities (resources, events, and agents) should relate to one another.

What are the basic principles and design considerations for a rea model?

What are the basic principles and design considerations for a REA model? The basic principles for an REA model have the common purpose of organizing a database and providing instruction on how to properly read it. The REA is organized by Resources, Events, and Agents.

How does the REA model affect accounting information systems?

The REA model views accounting data collection as a system to collect data about the resources, events, and agents within business processes. … An REA model suggests that the basic data collected should be the resources, events, and agents in this exchange.

What is the resource in Rea?

The REA model is best understood by understanding the “R” the “E” and the “A”. Resources: Economic resources or claims are objects that are under the control of an economic agent. Economic resources/claims may things such as goods, services, rights, obligations, claims.

Which of the following types of relationships in an REA diagram must be implemented as a separate table in a relational database?

An REA diagram contains four instances of the Employee entity. How many tables does this require in a relational database? A business orders mass-produced merchandise frequently throughout the year.

Why is depreciation not represented as an event REA data model?

Depreciation is not modeled as an event in the REA diagram because it is an accounting concept that arbitrarily allocates the cost of an acquired resource to different fiscal periods.

What does REA modeling allow us to determine in database design?

The REA data model was developed specifically for use in designing accounting information systems. It focuses on business semantics underlying an organization’s value chain activities. It provides guidance for identifying the entities to be included in a database and structuring the relationships among the entities.

Article first time published on

What is composite attribute?

“Composite attribute is an attribute where the values of that attribute can be further subdivided into meaningful sub-parts.” Typical examples for composite attribute are; Name – may be stored as first name, last name, middle initial.

Why are journals and ledgers not modeled in an REA diagram?

Journals and ledgers are not modeled in REA diagrams. According to the REA philosophy, information systems should support only the needs of accounting professionals. … Modern managers need both financial and nonfinancial information that traditional GAAP-based accounting systems are incapable of providing.

Which of the following is not likely to be depicted as an entity in the REA data model?

Which of the following is not likely to be depicted as an entity in the REA data model? Invoices are paper outputs of a database—they do not meet the definition of being either a resource, an event, or an agent and, therefore, are not modeled as an entity in an REA diagram.

In which stage's of the database design process should accountants participate?

In which stage(s) of the database design process should accountants participate? data modeling. A(n) ________ diagram graphically depicts a database’s contents by showing entities and relationships.

How are flowcharts used in accounting information systems?

Flowcharts help users of Accounting Information System to understand the step sequences of accounting processes. Use ConceptDraw DIAGRAM with Accounting Flowcharts solution to document and communicate visually how accounting processes work, and how each operation is done.

Which types of events are included in entity relationship diagrams?

Entity Relationship Diagram, also known as ERD, ER Diagram or ER model, is a type of structural diagram for use in database design. An ERD contains different symbols and connectors that visualize two important information: The major entities within the system scope, and the inter-relationships among these entities.

What is the name of the agent the revenue cycle interacts with?

The revenue cycle involves interactions with your customers. You sell goods or services and get cash.

In which stages of the database design process does data modeling occur?

Data modeling is the process of defining a database so that it faithfully represents all aspects of the organization, including its interactions with the external environment. Data modeling occurs during both the systems analysis and conceptual design stages of database design.

What is the first step to implementing an REA diagram in a relational database?

1. STEP 1: Create a table for each distinct entity in the diagram and each many-to-many relationship.
2. STEP 2: Assign attributes to appropriate tables.
3. STEP 3: Use foreign keys to implement one-to-one and one-to-many relationships.

Why are diamonds sometimes used to represent relationships in an REA diagram?

E) Although people might want to use diamonds to represent relationships, they should in fact be using rectangles to represent the relationships – diamonds are supposed to be used to represent the resources, events, agents, and locations in REA modeling.

How do you write business rules for ERD?

1. How things work here.
2. Start with a single instance of each entity.
3. Always stated in pairs—define relationship from perspective of each related entity.
4. Become the verbs in the relationships.
5. Determine cardinality and participation.
6. The basis for stored procedures and triggers.

What are the competitive advantages of using the REA model?

Competitive advantages from the REA approach can be see via value chain analysis. Value chain analysis distinguishes between primary activities (create value) and support activities (assist performing primary activities). REA provides a model for identifying and differentiating between these activities.

What does PK mean in database?

Primary key (PK) – value which uniquely identifies every row in the table. Foreign keys (FK) – values match a primary or alternate key inherited from some other table. Alternate Keys (AK) – key associated with one or more columns whose values uniquely identify every row in the table, but which is not the primary key.

What is difference between composite and derived attribute?

Composite attribute − Composite attributes are made of more than one simple attribute. … Derived attribute − Derived attributes are the attributes that do not exist in the physical database, but their values are derived from other attributes present in the database.

What is an ER model in database?

An Entity–relationship model (ER model) describes the structure of a database with the help of a diagram, which is known as Entity Relationship Diagram (ER Diagram). An ER model is a design or blueprint of a database that can later be implemented as a database. … An ER diagram shows the relationship among entity sets.

What are support events quizlet?

Support Events. control, planning, and other management activities; but not directly affect resources. Agents.