Exam 18: Implementing an Rea Model in a Relational Database

Explore all topics

How many tables are needed to implement an REA data model that has three distinct entities,two M:N relationships and two 1:N relationships in a relational database?

(Multiple Choice)

4.8/5

(32)

Question 21

How many tables are needed to implement an REA data model that has five distinct entities,two M:N relationships and three 1:N relationships in a relational database?

(Multiple Choice)

4.9/5

(36)

Question 22

What are the advantages of the REA data model over the traditional AIS model?

(Essay)

4.8/5

(40)

Question 23

Two or more primary keys of other database tables that,together,become the unique identifier or primary key of an M:N relationship table are called

(Multiple Choice)

4.7/5

(42)

Question 24

Identify the attribute below that would not make a good primary key.

(Multiple Choice)

4.9/5

(35)

Question 25

How many tables are needed to implement an REA data model that has three distinct entities,two M:N relationships and two 1:N relationships in a relational database?

(Multiple Choice)

4.8/5

(31)

Question 26

Attributes other than the primary key are

(Multiple Choice)

4.8/5

(37)

Question 27

Which of the statements below is false with regards to generating financial statements from an REA-based relational database?

(Multiple Choice)

4.9/5

(43)

Question 28

How many tables are needed to implement an REA data model that has four distinct entities,three M:N relationships and one 1:N relationships in a relational database?

(Multiple Choice)

4.8/5

(35)

Question 29

Which of the statements below is false with regards to creating database tables from an REA diagram?

(Multiple Choice)

4.8/5

(43)

Question 30

An integrated REA diagram merges multiple copies of some entities in order to

(Multiple Choice)

4.9/5

(46)

Question 31

Identify the attribute below that would not make a good primary key.

(Multiple Choice)

5.0/5

(30)

Question 32

A query that extracts,for a given time period,all purchases for which there is no corresponding disburse cash event will yield

(Multiple Choice)

4.9/5

(40)

Question 33

Implementation of this REA diagram into a relational database would require how many tables?

(Multiple Choice)

5.0/5

(41)

Question 34

Integrating separate REA diagrams developed for individual transaction cycles into a single,comprehensive enterprise-wide data model

(Multiple Choice)

4.8/5

(35)

Question 35

In a complete REA model of any organization,every resource must be connected to at least one ________ that increases that resource and to at least one event that decreases it.

(Multiple Choice)

4.7/5

(42)

Question 36

Integrating separate REA diagrams into a single comprehensive enterprise-wide model of the organization requires understanding what the ________ in each separate diagram reveal about the organization's business policies and activities.

(Multiple Choice)

4.9/5

(39)

Question 37

Explain where in the REA model you can find the information normally found in a ledger.

(Essay)

4.9/5

(33)

Question 38

The primary key for M:N relationship tables

(Multiple Choice)

4.8/5

(37)

Question 39

In a relational database designed according to the REA model,where is information about transactions stored?

(Multiple Choice)

4.8/5

(35)

Question 40

Showing 21 - 40 of 98

Exam 18: Implementing an Rea Model in a Relational Database

How many tables are needed to implement an REA data model that has three distinct entities,two M:N relationships and two 1:N relationships in a relational database?

How many tables are needed to implement an REA data model that has five distinct entities,two M:N relationships and three 1:N relationships in a relational database?

What are the advantages of the REA data model over the traditional AIS model?

Two or more primary keys of other database tables that,together,become the unique identifier or primary key of an M:N relationship table are called

Identify the attribute below that would not make a good primary key.

How many tables are needed to implement an REA data model that has three distinct entities,two M:N relationships and two 1:N relationships in a relational database?

Attributes other than the primary key are

Which of the statements below is false with regards to generating financial statements from an REA-based relational database?

How many tables are needed to implement an REA data model that has four distinct entities,three M:N relationships and one 1:N relationships in a relational database?

Which of the statements below is false with regards to creating database tables from an REA diagram?

An integrated REA diagram merges multiple copies of some entities in order to

Identify the attribute below that would not make a good primary key.

A query that extracts,for a given time period,all purchases for which there is no corresponding disburse cash event will yield

Implementation of this REA diagram into a relational database would require how many tables?

Integrating separate REA diagrams developed for individual transaction cycles into a single,comprehensive enterprise-wide data model

In a complete REA model of any organization,every resource must be connected to at least one ________ that increases that resource and to at least one event that decreases it.

Integrating separate REA diagrams into a single comprehensive enterprise-wide model of the organization requires understanding what the ________ in each separate diagram reveal about the organization's business policies and activities.

Explain where in the REA model you can find the information normally found in a ledger.

The primary key for M:N relationship tables

In a relational database designed according to the REA model,where is information about transactions stored?

Conceptual Foundations of Accounting Information Systems

Overview of Transaction Processing and Enterprise Resource Planning Systems

Systems Documentation Techniques

Relational Databases

Computer Fraud

Computer Fraud and Abuse Techniques

Control and Accounting Information Systems

Controls for Information Security

Confidentiality and Privacy Controls

Processing Integrity and Availability Controls

Auditing Computer-Based Information Systems

The Revenue Cycle: Sales to Cash Collections

The Expenditure Cycle: Purchasing to Cash Disbursements

The Production Cycle

The Human Resources Management and Payroll Cycle

General Ledger and Reporting System

Database Design Using the Rea Data Model

Special Topics in Rea Modeling

Introduction to Systems Development and Systems Analysis

Ais Development Strategies

Systems Design, implementation, and Operation

Filters