Unit of competency Outline

Date retreived
22/07/2026 11:35 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.

Identify physical database requirements

Identify physical database requirements

Unit of competency
National Code
ICTDBS401
State Code
AUX21
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
35
Description
This unit describes the skills and knowledge required to identify the scope, and the physical and security requirements of a database.It applies to individuals employed as database administrators who are required to plan a database to a user’s requirements.No licensing, legislative or certification requirements apply to this unit at the time of publication.
Notes
Elements and Performance Criteria
1. Identify the database scope
  • 1.1 Review the requirements of the user, and the current system’s architecture
  • 1.2 Determine database size from the requirements and the technical specifications
  • 1.3 Document the database design, and scope, of the project
  • 1.4 Evaluate several database management systems against the requirements, and make the appropriate selection
2. Identify the database requirements
  • 2.1 Review the technical specifications for the database
  • 2.2 Identify the database tables and relationships
  • 2.3 Identify the database data dictionary, table attributes and keys
  • 2.4 Determine the database reports based on the acceptance criteria and requirements
3.Identify the security requirements
  • 3.1 Review the system security plan
  • 3.2 Clarify and confirm that the database management system, and user security, aligns with the system security plan
  • 3.3 Identify, evaluate and record database performance, recovery and audit trail needs
4. Seek client feedback and approval
  • 4.1 Present database scope, technical requirements and security documentation to the user for feedback
  • 4.2 Review user feedback and adjust the database documentation, as required
  • 4.3 Present database documentation to the user for final approval
No information
No information
Replaces
State Code National Code Title Type
D7767 ICADBS401A Identify physical database requirements Unit of competency
Replaced By
State Code National Code Title Type
OAQ09 ICTDBS413 Determine database requirements Unit of competency