Required skills

literacy skills to interpret and evaluate the purposes and features of databases

numeracy skills to utilise software functions and formulae and to establish data relationships and queries

planning and organising skills to establish database design

problemsolving skills to address inconsistencies in database design and data relationships

Required knowledge

advanced functions of database software applications

impact of formatting and design on the presentation and readability of data

key provisions of relevant legislation from all forms of government standards and codes that may affect aspects of business operations such as

antidiscrimination legislation

ethical principles

codes of practice

privacy laws

occupational health and safety

The Evidence Guide provides advice on assessment and must be read in conjunction with the performance criteria required skills and knowledge range statement and the Assessment Guidelines for the Training Package

Overview of assessment

Critical aspects for assessment and evidence required to demonstrate competency in this unit

Evidence of the following is essential

producing a database containing a minimum of three tables and incorporating queries reports and forms

knowledge of advanced functions of database software app

Context of and specific resources for assessment

Assessment must ensure

access to office equipment and resources

access to sample data

Method of assessment

A range of assessment methods should be used to assess practical skills and knowledge The following examples are appropriate for this unit

direct questioning combined with review of portfolios of evidence and third party workplace reports of onthejob performance by the candidate

review of databasedesign

review of database testing

demonstration of techniques

Guidance information for assessment

Holistic assessment with other units relevant to the industry sector workplace and job role is recommended for example

IT use units

other IT analysis and design units

Organisational and task requirements may include:

Scope and functionality of database may include:

Software may include:

Appropriate person may include:

Software functions may include:

Formulae may include:

Naming and storage may include: