Unit of competency Outline

Date retreived
23/07/2026 2:51 PM AWST

Whilst all efforts are made to provide accurate and timely information from the relevant source/documentation, please be aware that the information supplied may not be the most current version. The accuracy of the detail has not been confirmed by the Department and therefore should not be relied upon without first confirming the contents.

Build a database

Build a database

Unit of competency
National Code
ICADBS412A
State Code
D7774
TGA Status
Replaced
DTWD Status
Replaced
Current Release Number
1.00
Current Release Date
18/07/2011
View on TGA
State Implementation and Classification
Approved Date
29/09/2011
Field of Education
020303 - Database Management
Original Release Date
29/09/2011
Nominal Hours
30
Description
This unit describes the performance outcomes, skills and knowledge required to build and implement a database using an established design.No licensing, legislative, regulatory or certification requirements apply to this unit at the time of endorsement but users should confirm requirements with the relevant federal, state or territory authority.
Notes
Elements and Performance Criteria
1. Confirm database design
  • 1.1 Review database design documentation, including data structures, queries, reports and user interface
  • 1.2 Compare database access and security feature design with organisational security plan
  • 1.3 Document inconsistencies in database and security design
2. Create prototype
  • 2.1 Develop prototype according to database design
  • 2.2 Populate database tables with suitable data, including current business data
  • 2.3 Write conversion programs to import data from existing systems
  • 2.4 Develop test data to assess database features
  • 2.5 Assess functionality of prototype with client, including identifying errors in program code and modifying screens and reports
  • 2.6 Incorporate feedback from client into prototype
  • 2.7 Obtain client sign-off for the prototype
3. Test database
  • 3.1 Develop implementation plan for the database
  • 3.2 Install database management system software on network
  • 3.3 Populate database tables with business data
  • 3.4 Implement security and access controls
  • 3.5 Test database output and security controls and record results
4. Evaluate database
  • 4.1 Review database with client for final approval
  • 4.2 Complete database documentation
  • 4.3 Identify and document user training requirements
  • 4.4 Seek and secure client acceptance of database
The range statement relates to the unit of competency as a whole. It allows for different work environments and situations that may affect performance. Bold italicised wording, if used in the performance criteria, is detailed below. Essential operating conditions that may be present with training and assessment (depending on the work situation, needs of the candidate, accessibility of the item, and local industry and regional contexts) may also be included.

Database may include:
DB2
Informix
Ingres
Microsoft SQL (MS SQL) server
Mini SQL (mSQL)
MySQL
Oracle
Postgre Structured Query Language (Postgre SQL)
Sybase.
Documentation may follow:
audit trails
International Organization for Standardization (ISO), International Electrotechnical Commission (IEC) and Australian Standards (AS) standards
naming standards
project management templates
report writing principles
version control.
Client may include:
clubs
external organisations
individuals
internal departments
internal employees.
Database management system may include:
distributed or centralised
online
partitioned geographically
thematically distributed.
Requirements may relate to:
application
business
network
people in the organisation
system.
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 ability to:
build and implement a well-structured database that
represents the client's business reality
provides the user with a productive business tool
conforms to the client’s standards and structures.
Context of and specific resources for assessment
Assessment must ensure access to:
business requirements and strategy
database design documentation
database software
programming language
appropriate learning and assessment support when required
modified equipment for people with special needs.
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:
verbal or written questioning to assess candidate’s knowledge of functions and features of databases and the process of developing a prototype
evaluation of database
review of:
database documentation, including security controls
test data used to test database functionality.
Guidance information for assessment
Holistic assessment with other units relevant to the industry sector, workplace and job role is recommended, where appropriate.
Assessment processes and techniques must be culturally appropriate, and suitable to the communication skill level, language, literacy and numeracy capacity of the candidate and the work being performed.
Indigenous people and other people from a non-English speaking background may need additional support.
In cases where practical assessment is used it should be combined with targeted questioning to assess required knowledge.
Replaces
State Code National Code Title Type
D0050 ICAB4170B Build a database Unit of competency
Replaced By
State Code National Code Title Type
AUT52 ICTDBS412 Build a database Unit of competency