Unit of competency Outline

Date retreived
23/07/2026 5:36 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.

Create basic databases

Create basic databases

Unit of competency
National Code
ICTDBS403
State Code
AUT57
TGA Status
Replaced
DTWD Status
Transition (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
40
Description
This unit describes the skills and knowledge required to design, develop and test a database in order to meet a specification.It applies to individuals who may be either database, or web designers, required to create a simple database to store information for an online application, using a simple entity relational database.No licensing, legislative or certification requirements apply to this unit at the time of publication.
Notes
Elements and Performance Criteria
1. Analyse the requirements for the database
  • 1.1 Determine the information that the database is required to hold
  • 1.2 Develop a written requirement report for the functionality of the database
  • 1.3 Complete the documentation, and submit it to the appropriate person for approval
2. Use data modelling to design the database to suit requirements
  • 2.1 Design an entity-relationship (ER) diagram to model the relationships between the entities and the attributes that the database will hold
  • 2.2 Develop primary and foreign keys to link the entities
  • 2.3 Develop a data dictionary
  • 2.4 Complete the documentation, and submit it to the appropriate person for approval
3. Create a database on a web or database server
  • 3.1 Use the appropriate language on a web or database server to create one or more databases
  • 3.2 Use the appropriate language on a web or database server to create tables
  • 3.3 Populate the database fields
4. Test the database and debug
  • 4.1 Test the database on the web or database server
  • 4.2 Ensure that the information represented matches the requirements
No information
No information
Replaces
State Code National Code Title Type
D7769 ICADBS403A Create basic databases Unit of competency
Replaced By
State Code National Code Title Type
OBU92 ICTDBS416 Create basic relational databases Unit of competency