Question 1

The attitude of businesses towards using REA to implement accounting systems is best described as:

Accepted Answer

A) Keen 
B) Positive 
C) Reluctant 
D) Negative 
A) Keen 
B) Positive 
C) Reluctant 
D) Negative

Question 2

When developing an enterprise model,which of the following sequence is correct?

Accepted Answer

A) Normalisation -> Construct ER Model -> Review ER Model -> Consolidate ER Model 
B) Construct ER Model -> Consolidate ER Model -> Normalisation -> Review ER Model 
C) Construct ER Model -> Normalisation -> Consolidate ER Model-> Review ER Model 
D) Construct ER Model -> Review ER Model -> Normalisation -> Consolidate ER Model 
A) Normalisation -> Construct ER Model -> Review ER Model -> Consolidate ER Model 
B) Construct ER Model -> Consolidate ER Model -> Normalisation -> Review ER Model 
C) Construct ER Model -> Normalisation -> Consolidate ER Model-> Review ER Model 
D) Construct ER Model -> Review ER Model -> Normalisation -> Consolidate ER Model

Question 3

Briefly describe the nature of the REA Accounting Model.

Accepted Answer

The REA Accounting Model defines common

Question 4

Subject Table
   
Department Table
  
-Refer to the tables in Q2.The best attribute to be chosen as the primary key for the Lecturer Table is:

Accepted Answer

A) Surname 
B) Surname and Given_Name 
C) Lecturer_Code 
D) Given _Name 
A) Surname 
B) Surname and Given_Name 
C) Lecturer_Code 
D) Given _Name

Question 5

Subject Table
   
Department Table
  
-Refer to the tables in Q2.What best describes the relationship between the entities Subject and Lecturer?

Accepted Answer

A) A lecturer can teach no subjects but may also teach many subjects 
B) A lecturer always teaches at least one subject 
C) A lecturer always teaches only one subject 
D) A lecturer can,but does not have to,teach only one subject 
A) A lecturer can teach no subjects but may also teach many subjects 
B) A lecturer always teaches at least one subject 
C) A lecturer always teaches only one subject 
D) A lecturer can,but does not have to,teach only one subject

Question 6

The process of normalisation has ______ outcomes and _____ steps to achieve those outcomes:

Accepted Answer

A) three;two 
B) three;three 
C) three;four 
D) none of the options are correct 
A) three;two 
B) three;three 
C) three;four 
D) none of the options are correct

Question 7

What is primary key? How can we design a good primary key?

Accepted Answer

Every table must have a primary key,whic

Question 8

A table in third normal form must not have:

Accepted Answer

A) Abstractive dependencies 
B) Binding dependencies 
C) Transitive dependencies 
D) Substitutive dependencies 
A) Abstractive dependencies 
B) Binding dependencies 
C) Transitive dependencies 
D) Substitutive dependencies

Question 9

Which of the following is true?

Accepted Answer

A) The REA model can store non-financial data and financial data. 
B) The ER model can store only financial data. 
C) The REA model can store only non-financial data. 
D) The ER model can store non-financial data or financial data,but not at the same time. 
A) The REA model can store non-financial data and financial data. 
B) The ER model can store only financial data. 
C) The REA model can store only non-financial data. 
D) The ER model can store non-financial data or financial data,but not at the same time.

Question 10

Controlled redundancies:

Accepted Answer

A) are allowed for the convenience of structuring data,data manipulation or reporting 
B) should be prevented at all costs 
C) permit the formation of tables that promote structural and data independence 
D) none of the options are correct 
A) are allowed for the convenience of structuring data,data manipulation or reporting 
B) should be prevented at all costs 
C) permit the formation of tables that promote structural and data independence 
D) none of the options are correct

Question 11

Redundancies that are allowed for the convenience of structuring data,data manipulation or reporting are referred to as:

Accepted Answer

A) Restricted redundancies 
B) Controlled redundancies 
C) Normalised redundancies 
D) Partial redundancies 
A) Restricted redundancies 
B) Controlled redundancies 
C) Normalised redundancies 
D) Partial redundancies

Question 12

Which of the following combination regarding the client-server architecture is correct?

Accepted Answer

A) A thin client with a fat server 
B) A thin client with a thin server 
C) A fat client with a fat server 
D) Any combination of thin and fat clients and servers is fine. 
A) A thin client with a fat server 
B) A thin client with a thin server 
C) A fat client with a fat server 
D) Any combination of thin and fat clients and servers is fine.

Question 13

It is proposed that there are common patterns of inflows and outflows in every exchange.All such exchanges can be best represented by:

Accepted Answer

A) ER 
B) REA 
C) Relational database 
D) Client-server model 
A) ER 
B) REA 
C) Relational database 
D) Client-server model

Question 14

When is an enterprise model ready for database implementation?

Accepted Answer

An organisation needs to go through the

Question 15

What basic problems does the second normal form solve?

Accepted Answer

The second normal form solves several ba

Question 16

Describe the concept of duality in REA.

Accepted Answer

William McCarthy proposed that in every

Question 17

The goal of normalisation is to form tables that promote:

Accepted Answer

A) structural and query independence 
B) relational and data independence 
C) structural and data independence 
D) relational and query independence 
A) structural and query independence 
B) relational and data independence 
C) structural and data independence 
D) relational and query independence

Question 18

When developing an enterprise model,the connectivities and cardinalities are primarily based on:

Accepted Answer

A) The general narrative of the organisation's operations. 
B) The revision from areas of the organisation with ownership of the operations,policies,and processes. 
C) The Normalisation process. 
D) The consolidation of ER diagrams. 
A) The general narrative of the organisation's operations. 
B) The revision from areas of the organisation with ownership of the operations,policies,and processes. 
C) The Normalisation process. 
D) The consolidation of ER diagrams.

The attitude of businesses towards using REA to implement accounting systems is best described as:

When developing an enterprise model,which of the following sequence is correct?

Briefly describe the nature of the REA Accounting Model.

Subject Table Department Table -Refer to the tables in Q2.The best attribute to be chosen as the primary key for the Lecturer Table is:

Subject Table Department Table -Refer to the tables in Q2.What best describes the relationship between the entities Subject and Lecturer?

The process of normalisation has __ outcomes and _ steps to achieve those outcomes:

What is primary key? How can we design a good primary key?

A table in third normal form must not have:

Which of the following is true?

Controlled redundancies:

Redundancies that are allowed for the convenience of structuring data,data manipulation or reporting are referred to as:

Which of the following combination regarding the client-server architecture is correct?

It is proposed that there are common patterns of inflows and outflows in every exchange.All such exchanges can be best represented by:

When is an enterprise model ready for database implementation?

What basic problems does the second normal form solve?

Describe the concept of duality in REA.

The goal of normalisation is to form tables that promote:

When developing an enterprise model,the connectivities and cardinalities are primarily based on:

Systems Fundamentals

Systems Characteristics and Considerations

Database Concepts I

XBRL Reporting

System Mapping and Documentation

Internal Controls I

Internal Controls II

Transaction Cycle The Revenue Cycle

Transaction Cycle The Expenditure Cycle

Transaction Cycle The Production Cycle

Transaction Cycle The HR Management and Payroll Cycle

Transaction Cycle The General Ledger and Financial Reporting Cycle

Systems Development

Auditing of Accounting Information Systems

Ethics, fraud and Computer Crime

Filters

Exam 4: Database Concepts II

The attitude of businesses towards using REA to implement accounting systems is best described as:

When developing an enterprise model,which of the following sequence is correct?

Briefly describe the nature of the REA Accounting Model.

Subject Table Department Table -Refer to the tables in Q2.The best attribute to be chosen as the primary key for the Lecturer Table is:

Subject Table Department Table -Refer to the tables in Q2.What best describes the relationship between the entities Subject and Lecturer?

The process of normalisation has ______ outcomes and _____ steps to achieve those outcomes:

What is primary key? How can we design a good primary key?

A table in third normal form must not have:

Which of the following is true?

Controlled redundancies:

Redundancies that are allowed for the convenience of structuring data,data manipulation or reporting are referred to as:

Which of the following combination regarding the client-server architecture is correct?

It is proposed that there are common patterns of inflows and outflows in every exchange.All such exchanges can be best represented by:

When is an enterprise model ready for database implementation?

What basic problems does the second normal form solve?

Describe the concept of duality in REA.

The goal of normalisation is to form tables that promote:

When developing an enterprise model,the connectivities and cardinalities are primarily based on:

Systems Fundamentals

Systems Characteristics and Considerations

Database Concepts I

XBRL Reporting

System Mapping and Documentation

Internal Controls I

Internal Controls II

Transaction Cycle The Revenue Cycle

Transaction Cycle The Expenditure Cycle

Transaction Cycle The Production Cycle

Transaction Cycle The HR Management and Payroll Cycle

Transaction Cycle The General Ledger and Financial Reporting Cycle

Systems Development

Auditing of Accounting Information Systems

Ethics, fraud and Computer Crime

Filters

The process of normalisation has __ outcomes and _ steps to achieve those outcomes: