Question 1

The process of developing an enterprise model is:

Accepted Answer

A) incremental 
B) interlocking 
C) iterative 
D) agile 
A) incremental 
B) interlocking 
C) iterative 
D) agile

Question 2

REA database modelling is based on the premise that:

Accepted Answer

A) revenues,expenses and accrual items need to be identified for effective modelling 
B) in every exchange in a process there is a revenue,event and agent involved 
C) in every exchange in a process there is a resource,event and agent involved 
D) none of the options are correct 
A) revenues,expenses and accrual items need to be identified for effective modelling 
B) in every exchange in a process there is a revenue,event and agent involved 
C) in every exchange in a process there is a resource,event and agent involved 
D) none of the options are correct

Question 3

One of the REA model's greatest advantages is that:

Accepted Answer

A) It is extremely easy and cost effective for any business to implement. 
B) It enables all staff to better understand customer needs. 
C) It can store both non-financial and financial data. 
D) It enables businesses to identify which staff are the busiest. 
A) It is extremely easy and cost effective for any business to implement. 
B) It enables all staff to better understand customer needs. 
C) It can store both non-financial and financial data. 
D) It enables businesses to identify which staff are the busiest.

Question 4

Illustrate the process of enterprise model development.

Accepted Answer

First step: Develop a general narrative

Question 5

If we want a table to have no repeating groups,what should we do?

Accepted Answer

A) Select a primary key that uniquely identifies each line in the table. 
B) Remove duplicated records in the table. 
C) Create another table and transfer the duplicated instances into the new table. 
D) Create foreign keys in the table. 
A) Select a primary key that uniquely identifies each line in the table. 
B) Remove duplicated records in the table. 
C) Create another table and transfer the duplicated instances into the new table. 
D) Create foreign keys in the table.

Question 6

In a client-server architecture,the concept of 'fat' means:

Accepted Answer

A) The computer conducts most of the processing 
B) Generous space exists in the computer case for extra components 
C) Bulky laptops 
D) More power consumption 
A) The computer conducts most of the processing 
B) Generous space exists in the computer case for extra components 
C) Bulky laptops 
D) More power consumption

Question 7

Normal forms higher than 3NF are often not performed because:

Accepted Answer

A) the process usually requires artificial assumptions that rarely hold in the business environment 
B) the process is too time-consuming 
C) the process requires special knowledge in database design that is not generally available in the everyday business environment 
D) the process is for academic use only 
A) the process usually requires artificial assumptions that rarely hold in the business environment 
B) the process is too time-consuming 
C) the process requires special knowledge in database design that is not generally available in the everyday business environment 
D) the process is for academic use only

Question 8

Which of the following statements about the REA model is incorrect?

Accepted Answer

A) The REA model emphasises the recording of debits and credits within a relational database environment 
B) The REA provides a structured approach for modelling business processes 
C) The REA model consists of resources,events,and agents. 
D) The REA model provides a template for a data model that can be applied in an accounting information system. 
A) The REA model emphasises the recording of debits and credits within a relational database environment 
B) The REA provides a structured approach for modelling business processes 
C) The REA model consists of resources,events,and agents. 
D) The REA model provides a template for a data model that can be applied in an accounting information system.

Question 9

Discuss the outcomes of the first,second,and the third normal forms and the actions required to achieve them.

Accepted Answer

First normal form
Outcome: A table has n

Question 10

With respect to REA models,which of the following statements is NOT true?

Accepted Answer

A) REA models the exchanges in the various processes in an organisation and brings these exchanges together to form an enterprise system. 
B) REA models concern the developing of the dualities between resources,events and agents. 
C) REA models assists the development of database structures that can be used to capture the details of a business process. 
D) REA models have been implemented in actual accounting systems in practice. 
A) REA models the exchanges in the various processes in an organisation and brings these exchanges together to form an enterprise system. 
B) REA models concern the developing of the dualities between resources,events and agents. 
C) REA models assists the development of database structures that can be used to capture the details of a business process. 
D) REA models have been implemented in actual accounting systems in practice.

Question 11

__________ can be removed by making the non-key attribute that an attribute is dependent on a primary key in a new table with the attribute and by leaving the non-key attribute as a foreign key in the existing table so the attribute is dependent on the primary key but via a non-key attribute.

Accepted Answer

A) Data redundancies 
B) Partial dependencies 
C) Repeating groups 
D) Transitive dependencies 
A) Data redundancies 
B) Partial dependencies 
C) Repeating groups 
D) Transitive dependencies

Question 12

In a client-server system,the client's request is handled by intermediate severs that coordinate the execution of the client request with other servers.This is known as a:

Accepted Answer

A) Single-tier client-server system 
B) Two-tier client-server system 
C) Three-tier client-server system 
D) Multiple-tier client-server system 
A) Single-tier client-server system 
B) Two-tier client-server system 
C) Three-tier client-server system 
D) Multiple-tier client-server system

Question 13

-Refer to the diagram in Q27.The resource that increases is:

Accepted Answer

A) Customer order 
B) Inventory 
C) Customer payment 
D) Cash 
A) Customer order 
B) Inventory 
C) Customer payment 
D) Cash

Question 14

-Refer to the diagram in Q27.The resource that decreases is:

Accepted Answer

A) Customer order 
B) Inventory 
C) Customer payment 
D) Cash 
A) Customer order 
B) Inventory 
C) Customer payment 
D) Cash

Question 15

Subject Table
   
Department Table
  
-Refer to the tables in Q2.How many records are present in the Lecturer Table?

Accepted Answer

A) 4 
B) 5 
C) 6 
D) 30 
A) 4 
B) 5 
C) 6 
D) 30

Question 16

The software that effects transmission of data and control between client and server is called:

Accepted Answer

A) communications middleware 
B) a front-end application 
C) a back-end application 
D) none of the options are correct 
A) communications middleware 
B) a front-end application 
C) a back-end application 
D) none of the options are correct

Question 17

In a client-server architecture,the concept of 'thin' means:

Accepted Answer

A) Slim tower design of the computer case 
B) Laptop computers are less bulky 
C) The computer conducts minimal processing 
D) The computer runs on less power 
A) Slim tower design of the computer case 
B) Laptop computers are less bulky 
C) The computer conducts minimal processing 
D) The computer runs on less power

Question 18

Describe two differences between ER model and REA model.

Accepted Answer

Entities or the "boxes" in an ER model c

Question 19

In the REA diagram shown below,the event that causes an increase is:

Accepted Answer

A) Customer order 
B) Inventory 
C) Customer payment 
D) Cash 
A) Customer order 
B) Inventory 
C) Customer payment 
D) Cash

Question 20

In a client-server system,which of the following software is loaded into the client computers?

Accepted Answer

A) Front-end application software 
B) Back-end application software 
C) Communications middleware 
D) Groupware 
A) Front-end application software 
B) Back-end application software 
C) Communications middleware 
D) Groupware

The process of developing an enterprise model is:

REA database modelling is based on the premise that:

One of the REA model's greatest advantages is that:

Illustrate the process of enterprise model development.

If we want a table to have no repeating groups,what should we do?

In a client-server architecture,the concept of 'fat' means:

Normal forms higher than 3NF are often not performed because:

Which of the following statements about the REA model is incorrect?

Discuss the outcomes of the first,second,and the third normal forms and the actions required to achieve them.

With respect to REA models,which of the following statements is NOT true?

__________ can be removed by making the non-key attribute that an attribute is dependent on a primary key in a new table with the attribute and by leaving the non-key attribute as a foreign key in the existing table so the attribute is dependent on the primary key but via a non-key attribute.

In a client-server system,the client's request is handled by intermediate severs that coordinate the execution of the client request with other servers.This is known as a:

-Refer to the diagram in Q27.The resource that increases is:

-Refer to the diagram in Q27.The resource that decreases is:

Subject Table Department Table -Refer to the tables in Q2.How many records are present in the Lecturer Table?

The software that effects transmission of data and control between client and server is called:

In a client-server architecture,the concept of 'thin' means:

Describe two differences between ER model and REA model.

In the REA diagram shown below,the event that causes an increase is:

In a client-server system,which of the following software is loaded into the client computers?

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 process of developing an enterprise model is:

REA database modelling is based on the premise that:

One of the REA model's greatest advantages is that:

Illustrate the process of enterprise model development.

If we want a table to have no repeating groups,what should we do?

In a client-server architecture,the concept of 'fat' means:

Normal forms higher than 3NF are often not performed because:

Which of the following statements about the REA model is incorrect?

Discuss the outcomes of the first,second,and the third normal forms and the actions required to achieve them.

With respect to REA models,which of the following statements is NOT true?

__________ can be removed by making the non-key attribute that an attribute is dependent on a primary key in a new table with the attribute and by leaving the non-key attribute as a foreign key in the existing table so the attribute is dependent on the primary key but via a non-key attribute.

In a client-server system,the client's request is handled by intermediate severs that coordinate the execution of the client request with other servers.This is known as a:

-Refer to the diagram in Q27.The resource that increases is:

-Refer to the diagram in Q27.The resource that decreases is:

Subject Table Department Table -Refer to the tables in Q2.How many records are present in the Lecturer Table?

The software that effects transmission of data and control between client and server is called:

In a client-server architecture,the concept of 'thin' means:

Describe two differences between ER model and REA model.

In the REA diagram shown below,the event that causes an increase is:

In a client-server system,which of the following software is loaded into the client computers?

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