Unit of competency Outline

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

Create basic relational databases

Create basic relational databases

Unit of competency
National Code
ICTDBS416
State Code
OBU92
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
40
Description
This unit describes the skills and knowledge required to design, develop and test relational databases to meet specifications.It applies to individuals who are database support staff, application programmers and web designers who are required to create a simple database to store information for an online, desktop, web or mobile device application, using a simple entity relational database on a web or database server environment.No licensing, legislative or certification requirements apply to this unit at the time of publication.
Notes
Elements and Performance Criteria
1. Prepare to create relational database
  • 1.1 Determine organisational database functionality requirements
  • 1.2 Document organisational database requirements
  • 1.3 Gather required data according to task requirements
  • 1.4 Submit document to required personnel and according to organisational policies and procedures
  • 1.5 Seek and respond to documentation feedback according to organisational policies and procedures
2. Design relational database
  • 2.1 Design entity-relationship (ER) diagram to model relationships between entities, including entity attributes according to functionality requirements
  • 2.2 Define primary and foreign keys and implement relationships
  • 2.3 Normalise database model
  • 2.4 Develop data dictionary and detail entity attributes according to functionality requirements
  • 2.5 Document ER diagram and data dictionary, including data model, and submit to required personnel
  • 2.6 Seek feedback from required personnel, and update data model according to feedback
3. Create relational database
  • 3.1 Use required language on web and database server to create relational database according to confirmed task design
  • 3.2 Create tables according to required language and ER diagram
  • 3.3 Populate database fields according to task requirements
  • 3.4 Test and fix database problems on web and database server
4. Finalise relational database and required documentation
  • 4.1 Determine alignment between represented information and task requirements
  • 4.2 Confirm and submit all task documentation to required personnel
  • 4.3 Seek and respond to feedback on task delivery and documentation
  • 4.4 Save changes and obtain final task signoff from required personnel
No information
No information
Replaces
State Code National Code Title Type
AUT57 ICTDBS403 Create basic databases Unit of competency