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 five distinct entities,two M:N relationships and three 1:N relationships in a relational database?

(Multiple Choice)

4.8/5

(44)

Question 81

When comparing REA diagrams used to design an AIS with a traditionally designed AIS,

(Multiple Choice)

4.9/5

(38)

Question 82

Which of the following is not one of the steps in implementing an REA diagram in a relational database?

(Multiple Choice)

4.8/5

(34)

Question 83

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

(Multiple Choice)

4.7/5

(42)

Question 84

Which of the following attributes would typically be included in the table that stores data about the Customer entity in a relational database?

(Multiple Choice)

4.9/5

(40)

Question 85

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 86

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.9/5

(37)

Question 87

A query that extracts,for a given time period,the total amount of all sales events for which there is no corresponding receive cash event will yield

(Multiple Choice)

4.8/5

(45)

Question 88

Which of the following is false with regards to REA models?

(Multiple Choice)

4.9/5

(40)

Question 89

A query that extracts,for a given time period,all sales events for which there is no corresponding receive cash event on the date of the sales event will yield

(Multiple Choice)

4.8/5

(31)

Question 90

The primary key for 1:1 relationship tables

(Multiple Choice)

4.9/5

(32)

Question 91

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

(Multiple Choice)

4.8/5

(39)

Question 92

Which of the following is true with regards to REA diagrams and relational databases?

(Multiple Choice)

4.8/5

(27)

Question 93

Queries need to be created every time to retrieve information from a database.

(True/False)

4.9/5

(39)

Question 94

In an integrated REA diagram,every event must be linked to

(Multiple Choice)

4.8/5

(36)

Question 95

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

(Multiple Choice)

4.8/5

(40)

Question 96

In an integrated REA diagram,every agent must be linked to

(Multiple Choice)

4.9/5

(44)

Question 97

From the choices below,identify the attribute below that would make the best primary key.

(Multiple Choice)

4.9/5

(34)

Question 98

Showing 81 - 98 of 98

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?

When comparing REA diagrams used to design an AIS with a traditionally designed AIS,

Which of the following is not one of the steps in implementing an REA diagram in a relational database?

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

Which of the following attributes would typically be included in the table that stores data about the Customer entity in a relational database?

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

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

A query that extracts,for a given time period,the total amount of all sales events for which there is no corresponding receive cash event will yield

Which of the following is false with regards to REA models?

A query that extracts,for a given time period,all sales events for which there is no corresponding receive cash event on the date of the sales event will yield

The primary key for 1:1 relationship tables

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

Which of the following is true with regards to REA diagrams and relational databases?

Queries need to be created every time to retrieve information from a database.

In an integrated REA diagram,every event must be linked to

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

In an integrated REA diagram,every agent must be linked to

From the choices below,identify the attribute below that would make the best primary key.

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