Unit of competency Outline

Date retreived
22/07/2026 10:23 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
ICTDBS412
State Code
AUT52
TGA Status
Replaced
DTWD Status
Replaced
Current Release Number
1.00
Current Release Date
25/03/2015
View on TGA
State Implementation and Classification
Approved Date
16/09/2015
Field of Education
020303 - Database Management
Original Release Date
16/09/2015
Nominal Hours
30
Description
This unit describes the skills and knowledge required to build, implement, test and evaluate a database, using an established design.It applies individuals employed as database administrators and designers who are required to build databases for information storage and retrieval requirements.No licensing, legislative or certification requirements apply to this unit at the time of publication.
Notes
Elements and Performance Criteria
1. Confirm the database design
  • 1.1 Review the database design documentation, including data structures, queries, reports and user interface
  • 1.2 Compare the database access and security feature design with the organisational security plan
  • 1.3 Document inconsistencies in the database and security design
2. Create a prototype
  • 2.1 Develop a prototype according to the 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 the prototype with the client, including identifying errors in the program code, and modifying screens, and reports
  • 2.6 Incorporate feedback from the client into the prototype
  • 2.7 Obtain client sign-off for the prototype
3. Test the database
  • 3.1 Develop an implementation plan for the database
  • 3.2 Install database management system software on the network
  • 3.3 Populate the 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 the database
  • 4.1 Review the database with the 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 the database
No information
No information
Replaces
State Code National Code Title Type
D7774 ICADBS412A Build a database Unit of competency
Replaced By
State Code National Code Title Type
OAP92 ICTDBS415 Build a database Unit of competency