Question 1

When building a traditional accounting system using REA,the REA model:

Accepted Answer

A) is implemented as it is 
B) is implemented as a relational database 
C) is implemented as business processes 
D) is implemented as an ER model 
A) is implemented as it is 
B) is implemented as a relational database 
C) is implemented as business processes 
D) is implemented as an ER model B

Question 2

Which of the following is NOT true about the differences between REA and ER diagrams?

Accepted Answer

A) ER diagrams do not have events. 
B) REA diagrams do not show cardinalities. 
C) In an REA diagram,entities are sorted into separate columns. 
D) Both REA and ER diagrams show relationships. 
A) ER diagrams do not have events. 
B) REA diagrams do not show cardinalities. 
C) In an REA diagram,entities are sorted into separate columns. 
D) Both REA and ER diagrams show relationships. B

Question 3

For more convenient and quicker structuring,manipulating or reporting,one can:

Accepted Answer

A) Pursue the highest normal form possible through normalisation. 
B) Eliminate data redundancies. 
C) Leave the repeating groups as they are. 
D) Create controlled redundancies via lower forms of normalisation. 
A) Pursue the highest normal form possible through normalisation. 
B) Eliminate data redundancies. 
C) Leave the repeating groups as they are. 
D) Create controlled redundancies via lower forms of normalisation. D

Question 4

A client-server system distributes computing functions between two types of ________ and _______ processes: servers and clients

Accepted Answer

A) dependent;autonomous 
B) dependent;non - autonomous 
C) independent;autonomous 
D) independent;non - autonomous 
A) dependent;autonomous 
B) dependent;non - autonomous 
C) independent;autonomous 
D) independent;non - autonomous

Question 5

What normal form is the Lecturer Table at?
Lecturer Table
 
Subject Table
 
Department Table

Accepted Answer

A) First normal form 
B) Second normal form 
C) Third normal form 
D) The table is not at any normal form. 
A) First normal form 
B) Second normal form 
C) Third normal form 
D) The table is not at any normal form.

Question 6

In an e-commerce environment: (i)An organisation can open up its database to its suppliers (ii)An organisation can allow its employees to access internal databases from outside of the company (iii)An organisation can open up its database to its customers

Accepted Answer

A) (i)& (iii) 
B) (i)& (ii) 
C) (ii)& (iii) 
D) (i), (ii)& (iii) 
A) (i)& (iii) 
B) (i)& (ii) 
C) (ii)& (iii) 
D) (i), (ii)& (iii)

Question 7

Normalisation is the process of ____________ to eliminate repeating groups and data redundancies.

Accepted Answer

A) assigning primary keys to database tables. 
B) assigning attributes to entities. 
C) assigning foreign keys to database tables. 
D) assigning relationships to entities. 
A) assigning primary keys to database tables. 
B) assigning attributes to entities. 
C) assigning foreign keys to database tables. 
D) assigning relationships to entities.

Question 8

-Refer to the diagram in Q27.The event that causes a decrease is:

Accepted Answer

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

Question 9

A table in second normal form must not have:

Accepted Answer

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

Question 10

If an organisation decided to open up its database to its suppliers,it must: (i)Discuss with the suppliers how electronic connections are done (ii)Discuss with the suppliers how relevant costs are shared (iii)Discuss with the suppliers what data are actually needed by them

Accepted Answer

A) (i)(ii) 
B) (ii)(iii) 
C) (i)(iii) 
D) (i)(ii)(iii) 
A) (i)(ii) 
B) (ii)(iii) 
C) (i)(iii) 
D) (i)(ii)(iii)

Question 11

The client-server architecture is based on three major components,namely:

Accepted Answer

A) PCs,servers,and network 
B) Hardware,software,and people 
C) Hardware,software,and communications middleware 
D) Computers,network,and people 
A) PCs,servers,and network 
B) Hardware,software,and people 
C) Hardware,software,and communications middleware 
D) Computers,network,and people

Question 12

Discuss the three major components of the client-server architecture.

Accepted Answer

Client-server architecture is based on t

Question 13

Client-server systems can normally be classified as:

Accepted Answer

A) Single-tier and multiple-tier 
B) Two-tier and three-tier 
C) Internal-tier and external-tier 
D) Single-tier and two-tier 
A) Single-tier and multiple-tier 
B) Two-tier and three-tier 
C) Internal-tier and external-tier 
D) Single-tier and two-tier

Question 14

Which normal form is sufficient for most business applications?

Accepted Answer

A) Second normal form 
B) Third normal form 
C) Fourth normal form 
D) Fifth normal form 
A) Second normal form 
B) Third normal form 
C) Fourth normal form 
D) Fifth normal form

Question 15

Normalisation is a modelling technique used specifically for which type of database?

Accepted Answer

A) Hierarchical 
B) Network 
C) Relational 
D) Object oriented 
A) Hierarchical 
B) Network 
C) Relational 
D) Object oriented

Question 16

To maximise the flexibility of the database structure in the business environment,achieving the _______ normal form is sufficient.

Accepted Answer

A) Third 
B) Boyce-Codd 
C) Fourth 
D) Fifth 
A) Third 
B) Boyce-Codd 
C) Fourth 
D) Fifth

Question 17

__________ occurs where one attribute is dependent on another,but neither is part of the primary key.

Accepted Answer

A) Partial dependency 
B) Transitive dependency 
C) Data redundancy 
D) Repeating group 
A) Partial dependency 
B) Transitive dependency 
C) Data redundancy 
D) Repeating group

Question 18

Subject Table
   
Department Table
  
-Refer to the tables in Q2.How many attributes 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 19

Duality in the REA model refers to:

Accepted Answer

A) Debits equalling credits when recording a transaction 
B) The relationship between events that bring about an increase and decrease in resources 
C) An event can only relate to one resource and each event can only relate to one other event 
D) Each event needing two related agents - an internal and external agent 
A) Debits equalling credits when recording a transaction 
B) The relationship between events that bring about an increase and decrease in resources 
C) An event can only relate to one resource and each event can only relate to one other event 
D) Each event needing two related agents - an internal and external agent

Question 20

What are the normal forms beyond the third normal form? Are these normal forms used in general business scenarios?

Accepted Answer

There are normalisation processes beyond

When building a traditional accounting system using REA,the REA model:

Which of the following is NOT true about the differences between REA and ER diagrams?

For more convenient and quicker structuring,manipulating or reporting,one can:

A client-server system distributes computing functions between two types of __ and _ processes: servers and clients

What normal form is the Lecturer Table at? Lecturer Table Subject Table Department Table

In an e-commerce environment: (i)An organisation can open up its database to its suppliers (ii)An organisation can allow its employees to access internal databases from outside of the company (iii)An organisation can open up its database to its customers

Normalisation is the process of ____________ to eliminate repeating groups and data redundancies.

-Refer to the diagram in Q27.The event that causes a decrease is:

A table in second normal form must not have:

If an organisation decided to open up its database to its suppliers,it must: (i)Discuss with the suppliers how electronic connections are done (ii)Discuss with the suppliers how relevant costs are shared (iii)Discuss with the suppliers what data are actually needed by them

The client-server architecture is based on three major components,namely:

Discuss the three major components of the client-server architecture.

Client-server systems can normally be classified as:

Which normal form is sufficient for most business applications?

Normalisation is a modelling technique used specifically for which type of database?

To maximise the flexibility of the database structure in the business environment,achieving the _______ normal form is sufficient.

__________ occurs where one attribute is dependent on another,but neither is part of the primary key.

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

Duality in the REA model refers to:

What are the normal forms beyond the third normal form? Are these normal forms used in general business scenarios?

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

When building a traditional accounting system using REA,the REA model:

Which of the following is NOT true about the differences between REA and ER diagrams?

For more convenient and quicker structuring,manipulating or reporting,one can:

A client-server system distributes computing functions between two types of ________ and _______ processes: servers and clients

What normal form is the Lecturer Table at? Lecturer Table Subject Table Department Table

In an e-commerce environment: (i)An organisation can open up its database to its suppliers (ii)An organisation can allow its employees to access internal databases from outside of the company (iii)An organisation can open up its database to its customers

Normalisation is the process of ____________ to eliminate repeating groups and data redundancies.

-Refer to the diagram in Q27.The event that causes a decrease is:

A table in second normal form must not have:

If an organisation decided to open up its database to its suppliers,it must: (i)Discuss with the suppliers how electronic connections are done (ii)Discuss with the suppliers how relevant costs are shared (iii)Discuss with the suppliers what data are actually needed by them

The client-server architecture is based on three major components,namely:

Discuss the three major components of the client-server architecture.

Client-server systems can normally be classified as:

Which normal form is sufficient for most business applications?

Normalisation is a modelling technique used specifically for which type of database?

To maximise the flexibility of the database structure in the business environment,achieving the _______ normal form is sufficient.

__________ occurs where one attribute is dependent on another,but neither is part of the primary key.

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

Duality in the REA model refers to:

What are the normal forms beyond the third normal form? Are these normal forms used in general business scenarios?

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

A client-server system distributes computing functions between two types of __ and _ processes: servers and clients