Unit of competency Outline

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

Design databases

Design databases

Unit of competency
National Code
ICTDBS506
State Code
OBU88
TGA Status
Current
DTWD Status
Approved
Current Release Number
1.00
Current Release Date
21/07/2020
View on TGA
State Implementation and Classification
Approved Date
15/01/2021
Field of Education
020303 - Database Management
Original Release Date
15/01/2021
Nominal Hours
50
Description
This unit describes the skills and knowledge required to establish client needs and technical requirements and to design a database that meets identified requirements.It applies to those who are employed in roles including database administrators or designers who are required to design databases.No licensing, legislative or certification requirements apply to this unit at the time of publication.
Notes
Elements and Performance Criteria
1. Determine database requirements
  • 1.1 Conduct user-needs analysis with required personnel and determine database functionality requirements
  • 1.2 Determine user-needs analysis technical requirements
  • 1.3 Develop conceptual model of database according to organisational requirements
  • 1.4 Submit conceptual model to required personnel
  • 1.5 Seek and respond to feedback and make required changes
2. Develop logical data model
  • 2.1 Identify attributes and determine data types
  • 2.2 Undertake normalisation of attributes
  • 2.3 Develop entity-relationship (ER) diagram and clarify cardinality of relationships
  • 2.4 Document attributes, normalised data and ER diagram
  • 2.5 Submit documentation to required personnel and seek and respond to feedback
3. Design data structures
  • 3.1 Confirm primary and foreign keys according to technical requirements
  • 3.2 Identify referential integrity constraints and organisational business rules
  • 3.3 Establish database management system constraints and incorporate into database design
  • 3.4 Design and develop data validation rules, indexes and data dictionary
  • 3.5 Document database design according to organisational policies and procedures
4. Design queries, screens and reports
  • 4.1 Design database according to organisational requirements
  • 4.2 Design required queries and output reports
  • 4.3 Compare physical design against conceptual model and user-needs analysis
  • 4.4 Incorporate all required changes into database design
5. Design access and security systems
  • 5.1 Review existing business security plan and use as design base
  • 5.2 Design database password and access system
  • 5.3 Identify multiple-user requirements
  • 5.4 Develop required organisational access profiles
6. Confirm database design
  • 6.1 Determine database backup and recovery requirements
  • 6.2 Develop and document database backup and restore procedures
  • 6.3 Submit database and documentation to required personnel
  • 6.4 Seek and respond to feedback from required personnel
  • 6.5 Obtain final task sign off from required personnel
No information
No information
Replaces
State Code National Code Title Type
AUT67 ICTDBS502 Design a database Unit of competency