Question 1

What are the advantages of database systems?

Accepted Answer

Database systems are designed to eliminate the repetition of data and the incidence of inconsistent data by ensuring data is structured so that it is stored in only one location.This structure allows for data sharing across the organisation and provides the foundation on which any database can be developed.The incidence of errors is reduced considerably by independent data structures,with only one location for entering and manipulating data.Program maintenance is also reduced because there is only one centrally located point,the database management system (DBMS),that requires reprogramming for all data (this will be covered in the next section).This increases the speed and flexibility with which the organisation can prepare information that is crucial to decision making.The centralisation of data and the DBMS enforces consistent standards for data structures and storage across the organisation.It also aids data and system security by having only one access point into the database to control.Given this,and as indicated above,privacy,security and adequate backups to the system are important.

Question 2

Database systems are designed to:

Accepted Answer

A) eliminate the repetition of data and the incidence of inconsistent data by ensuring data is structured so that it is stored in multiple locations. 
B) eliminate the repetition of data and the incidence of inconsistent data by ensuring data is structured so that it is stored in only one location. 
C) increase the repetition of data and the incidence of inconsistent data by ensuring data is structured so that it is stored in multiple locations. 
D) increase the repetition of data and the incidence of inconsistent data by ensuring data is unstructured but that it is stored in only one location. 
A) eliminate the repetition of data and the incidence of inconsistent data by ensuring data is structured so that it is stored in multiple locations. 
B) eliminate the repetition of data and the incidence of inconsistent data by ensuring data is structured so that it is stored in only one location. 
C) increase the repetition of data and the incidence of inconsistent data by ensuring data is structured so that it is stored in multiple locations. 
D) increase the repetition of data and the incidence of inconsistent data by ensuring data is unstructured but that it is stored in only one location. B

Question 3

Describe the key responsibilities of database administrator,database designers,and systems analysts involved in a database system.

Accepted Answer

Database administrators manage the use of the database and ensure that all the functions are working properly.Since a database serves cross-functional information systems and also exists independent of the separate information systems,it requires a technical specialist such as database administrators to monitor performance,deal with changes to the structure and carry out backup procedures.Ensuring that data has privacy controls,security and backup are extremely important tasks of a database administrator.They also give access to staff to different areas of the database depending on the level of access approved for each staff member.

Database designers develop structures and designs that capture data for storage and manipulation.Data structures and designs play a critical role in overcoming some of the limitations that can be inherent in some systems.

Systems analysts and programmers create the screens,reports and procedures by which end users can access and manipulate the data in a database system.

Database designers develop structures and designs that capture data for storage and manipulation.Data structures and designs play a critical role in overcoming some of the limitations that can be inherent in some systems.

Systems analysts and programmers create the screens,reports and procedures by which end users can access and manipulate the data in a database system.

Question 4

Originally,an organisation has sourced all its products from one supplier.Now,the organisation has changed its mind and started to source all its products from various suppliers.This is reflected on an ER diagram as:

Accepted Answer

A) A change in the relationship between the organisation entity and the supplier entity. 
B) A change in the cardinality associated with the supplier side relationship 
C) A change in the number of supplier entities 
D) A change in the cardinality associated with the organisation side of the relationship 
A) A change in the relationship between the organisation entity and the supplier entity. 
B) A change in the cardinality associated with the supplier side relationship 
C) A change in the number of supplier entities 
D) A change in the cardinality associated with the organisation side of the relationship

Question 5

Which of the following is listed in the order from smallest to largest?

Accepted Answer

A) field,data,record,file 
B) file,field,data,record 
C) record,file,data,field 
D) data,field,record,file 
A) field,data,record,file 
B) file,field,data,record 
C) record,file,data,field 
D) data,field,record,file

Question 6

When all data are stored in a central place,which of the following is not essential to ensure data are protected?

Accepted Answer

A) Data privacy 
B) Data security 
C) Data backup 
D) Data normalisation 
A) Data privacy 
B) Data security 
C) Data backup 
D) Data normalisation

Question 7

Data redundancy:

Accepted Answer

A) can lead to a number of data anomalies 
B) is useful in ensuring the integrity of data. 
C) provides a useful backup function in a database. 
D) none of the options are correct. 
A) can lead to a number of data anomalies 
B) is useful in ensuring the integrity of data. 
C) provides a useful backup function in a database. 
D) none of the options are correct.

Question 8

In relational database,a connected set of fields that describe a person,place or thing is referred to as:

Accepted Answer

A) a table 
B) a record 
C) a file 
D) a matrix 
A) a table 
B) a record 
C) a file 
D) a matrix

Question 9

Data redundancy occurs when:

Accepted Answer

A) we keep data that has not been used by an organisation for a number of years 
B) the same data is stored in multiple locations. 
C) emails are stored by an organisation for longer than six months. 
D) when we have the wrong information stored on a customer file 
A) we keep data that has not been used by an organisation for a number of years 
B) the same data is stored in multiple locations. 
C) emails are stored by an organisation for longer than six months. 
D) when we have the wrong information stored on a customer file

Question 10

If data are captured and stored at their most basic level,then:

Accepted Answer

A) these data can be used to answer a very limited number of questions when they are aggregated at a certain level. 
B) these data can be used to answer quite a few questions when they are aggregated at a certain level. 
C) these data cannot be used to answer any question unless they are combined with some other data at a higher aggregated level. 
D) these data are not suitable for answering questions. 
A) these data can be used to answer a very limited number of questions when they are aggregated at a certain level. 
B) these data can be used to answer quite a few questions when they are aggregated at a certain level. 
C) these data cannot be used to answer any question unless they are combined with some other data at a higher aggregated level. 
D) these data are not suitable for answering questions.

Question 11

Student Table
   
Course Table
   
The Course_ID in the student table is best described as:
-Examine the database tables in Q44.Given that the relationship between the student and the course is 1:1,which of the following statement is correct? (i)Only the Course_ID should be added to the student table (ii)Only the Student_ID should be added to the student table (iii)Course_ID should be added to the student table and Student_ID should be added to the course table.

Accepted Answer

A) Either (i)or (ii) 
B) Both (i)and (ii) 
C) Both (ii)and (iii) 
D) Both (i)and (iii) 
A) Either (i)or (ii) 
B) Both (i)and (ii) 
C) Both (ii)and (iii) 
D) Both (i)and (iii)

Question 12

Data anomalies:

Accepted Answer

A) are inconsistencies or errors that exist in a database because of entry or changes 
B) are useful in ensuring the integrity of data 
C) provide a useful backup function in a database 
D) none of the options are correct 
A) are inconsistencies or errors that exist in a database because of entry or changes 
B) are useful in ensuring the integrity of data 
C) provide a useful backup function in a database 
D) none of the options are correct

Question 13

Which of the following is not a problem that a normalisation process is designed to overcome?

Accepted Answer

A) Repeating groups 
B) Data anomalies 
C) Missing data 
D) Data redundancies 
A) Repeating groups 
B) Data anomalies 
C) Missing data 
D) Data redundancies

Question 14

Which of the following statement regarding normalisation is incorrect?

Accepted Answer

A) Normalisation is the process of assigning attributes to entities to eliminate repeating groups and data redundancies. 
B) The goal of normalisation is to form tables representing entities that promote structural and data independence. 
C) Normalisation maximises the efficiency of structure. 
D) Normalisation is the top-down view of designing a database. 
A) Normalisation is the process of assigning attributes to entities to eliminate repeating groups and data redundancies. 
B) The goal of normalisation is to form tables representing entities that promote structural and data independence. 
C) Normalisation maximises the efficiency of structure. 
D) Normalisation is the top-down view of designing a database.

Question 15

Data or facts that are processed in a meaningful form become:

Accepted Answer

A) Intelligence 
B) Information 
C) Knowledge 
D) Wisdom 
A) Intelligence 
B) Information 
C) Knowledge 
D) Wisdom

Question 16

An entity relationship diagram is a method for depicting:

Accepted Answer

A) The logical view of a database. 
B) The physical view of a database. 
C) The relationship between the user interface and the DBMS. 
D) An implementation of a client-server system. 
A) The logical view of a database. 
B) The physical view of a database. 
C) The relationship between the user interface and the DBMS. 
D) An implementation of a client-server system.

Question 17

Define relational database and discuss its constituting elements.

Accepted Answer

Relational database is a database that s

Question 18

What is the highest normal form?

Accepted Answer

A) Third 
B) Fourth 
C) Fifth 
D) Sixth 
A) Third 
B) Fourth 
C) Fifth 
D) Sixth

Question 19

What are the important reasons for database modelling?

Accepted Answer

Firstly,a good database design is the fo

Question 20

Student Table
   
Course Table
   
The Course_ID in the student table is best described as:
-Examine the database tables in Q 44.What is the use of the Course_ID in the student table?

Accepted Answer

A) To link the student table to the course table 
B) To back up Course_ID information in the student table 
C) Both to link the student table to the course table and to back up Course_ID information in the student table 
D) Neither linking the student table to the course table nor backing up Course_ID information in the student table 
A) To link the student table to the course table 
B) To back up Course_ID information in the student table 
C) Both to link the student table to the course table and to back up Course_ID information in the student table 
D) Neither linking the student table to the course table nor backing up Course_ID information in the student table

What are the advantages of database systems?

Database systems are designed to:

Describe the key responsibilities of database administrator,database designers,and systems analysts involved in a database system.

Originally,an organisation has sourced all its products from one supplier.Now,the organisation has changed its mind and started to source all its products from various suppliers.This is reflected on an ER diagram as:

Which of the following is listed in the order from smallest to largest?

When all data are stored in a central place,which of the following is not essential to ensure data are protected?

Data redundancy:

In relational database,a connected set of fields that describe a person,place or thing is referred to as:

Data redundancy occurs when:

If data are captured and stored at their most basic level,then:

Data anomalies:

Which of the following is not a problem that a normalisation process is designed to overcome?

Which of the following statement regarding normalisation is incorrect?

Data or facts that are processed in a meaningful form become:

An entity relationship diagram is a method for depicting:

Define relational database and discuss its constituting elements.

What is the highest normal form?

What are the important reasons for database modelling?

Student Table Course Table The Course_ID in the student table is best described as: -Examine the database tables in Q 44.What is the use of the Course_ID in the student table?

Systems Fundamentals

Systems Characteristics and Considerations

Database Concepts II

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 3: Database Concepts I

What are the advantages of database systems?

Database systems are designed to:

Describe the key responsibilities of database administrator,database designers,and systems analysts involved in a database system.

Originally,an organisation has sourced all its products from one supplier.Now,the organisation has changed its mind and started to source all its products from various suppliers.This is reflected on an ER diagram as:

Which of the following is listed in the order from smallest to largest?

When all data are stored in a central place,which of the following is not essential to ensure data are protected?

Data redundancy:

In relational database,a connected set of fields that describe a person,place or thing is referred to as:

Data redundancy occurs when:

If data are captured and stored at their most basic level,then:

Data anomalies:

Which of the following is not a problem that a normalisation process is designed to overcome?

Which of the following statement regarding normalisation is incorrect?

Data or facts that are processed in a meaningful form become:

An entity relationship diagram is a method for depicting:

Define relational database and discuss its constituting elements.

What is the highest normal form?

What are the important reasons for database modelling?

Student Table Course Table The Course_ID in the student table is best described as: -Examine the database tables in Q 44.What is the use of the Course_ID in the student table?

Systems Fundamentals

Systems Characteristics and Considerations

Database Concepts II

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