Unit of competency
Modification History
Release |
Comments |
Release 1 |
This version first released with ICT Information and Communications Technology Training Package Version 1.0. |
Application
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.
Unit Sector
Database
Elements and Performance Criteria
ELEMENT |
PERFORMANCE CRITERIA |
Elements describe the essential outcomes. |
Performance criteria describe the performance needed to demonstrate achievement of the element. |
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 |
Foundation Skills
This section describes language, literacy, numeracy and employment skills incorporated in the performance criteria that are required for competent performance.
Skill |
Performance Criteria |
Description |
Reading |
1.1-1.3, 2.5, 2.6, 4.1, 4.3 |
|
Writing |
1.3, 2.3, 2.7, 3.1, 3.5, 4.2 |
|
Oral Communication |
1.1, 2.5-2.7, 4.1, 4.3, 4.4 |
|
Interact with others |
4.4 |
|
Get the work done |
All |
|
Unit Mapping Information
Code and title current version |
Code and title previous version |
Comments |
Equivalence status |
ICTDBS412 Build a database |
ICADBS412A Build a database |
Updated to meet Standards for Training Packages |
Equivalent unit |
Links
Companion Volume implementation guides are found in VETNet - https://vetnet.gov.au/Pages/TrainingDocs.aspx?q=a53af4e4-b400-484e-b778-71c9e9d6aff2