Unit of competency Outline

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

Design databases

Design databases

Unit of competency
National Code
BSBITA401
State Code
AUI22
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
15/09/2015
Field of Education
020305 - Systems Analysis And Design
Original Release Date
15/09/2015
Nominal Hours
30
Description
This unit describes the skills and knowledge required to design and develop a database (including queries, forms and reports) to meet a defined need using existing data.It applies to individuals who may work independently or within an administrative support role, with the responsibility to use databases to store and retrieve data using commercially available database software.No licensing, legislation or certification requirements apply to this unit at the time of publication.
Notes
Elements and Performance Criteria
1. Design database
  • 1.1 Review organisational and task requirements to confirm scope and functionality of database design, including data redundancy
  • 1.2 Develop a logical data model to identify and classify data into types
  • 1.3 Select appropriate software according to organisational and task requirements and required scope and functionality of database
  • 1.4 Confirm database design with appropriate person
2. Develop database
  • 2.1 Set field attributes according to data type and link databases by a common field in accordance with software procedures
  • 2.2 Identify primary key to uniquely identify data
  • 2.3 Identify foreign keys to establish associations between data
  • 2.4 Use software functions and formulae to meet organisational and task requirements
  • 2.5 Create password and access system according to organisational and task requirements
3. Develop queries, forms and reports
  • 3.1 Develop queries as required by organisational and task requirements
  • 3.2 Develop input screens or forms to access required data
  • 3.3 Develop reports according to organisational and task requirements
4. Test and finalise database
  • 4.1 Populate database with sample dataset for testing
  • 4.2 Assess and document effectiveness of data relationships, query forms and reports
  • 4.3 Address any errors in database design
  • 4.4 Name and store database in accordance with organisational requirements and exit the application without data loss or damage
  • 4.5 Confirm database readiness with appropriate person
No information
No information
Replaces
State Code National Code Title Type
D0774 BSBITA401A Design databases Unit of competency
Replaced By
State Code National Code Title Type
OAE68 BSBITA411 Design and develop relational databases Unit of competency