Unit of competency Outline

Date retreived
23/07/2026 5:12 AM 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
ICTDBS415
State Code
OAP92
TGA Status
Current
DTWD Status
Approved
Current Release Number
1.00
Current Release Date
30/01/2019
View on TGA
State Implementation and Classification
Approved Date
22/05/2019
Field of Education
020303 - Database Management
Original Release Date
22/05/2019
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 to 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 database design documentation, including data structures, queries, reports, and user interfaces to identify organisational data management, access and security requirements
  • 1.2 Evaluate sufficiency of database access and security feature design to organisational data security plan
  • 1.3 Document and rectify inconsistencies between database design and organisational data security plan
2. Create a prototype database
  • 2.1 Develop prototype database according to database design
  • 2.2 Populate database tables with current organisational data to test database implementation
  • 2.3 Write conversion programs to import data from existing systems in accordance with scope specified in database design documentation
  • 2.4 Assess functionality of prototype with user, including identifying errors in program code and modifying user interfaces and reports
  • 2.5 Incorporate feedback from user into prototype
  • 2.6 Obtain user approval of prototype
3. Deploy the database
  • 3.1 Develop implementation plan for database aligned with user acceptance criteria
  • 3.2 Install database management system software on network in accordance with implementation plan
  • 3.3 Populate database tables with organisational data in accordance with implementation plan
  • 3.4 Implement security and access controls in accordance with database design documentation and implementation plan
  • 3.5 Test and document database output and security controls, and record results in accordance with database design documentation
4. Evaluate the database
  • 4.1 Review the database against user acceptance criteria and rectify discrepancies
  • 4.2 Complete database documentation in accordance with user acceptance criteria
  • 4.3 Identify and document user training requirements from database design documentation
  • 4.4 Seek and secure user acceptance of database in accordance with user acceptance criteria
No information
No information
Replaces
State Code National Code Title Type
AUT52 ICTDBS412 Build a database Unit of competency