Unit of competency Outline

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

Design a database

Unit of competency
National Code
ICTDBS502
State Code
AUT67
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
50
Description
This unit describes the skills and knowledge required to establish client needs and technical requirements and to design a database that meets those requirements.It applies to individuals employed as database administrators and 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 Meet with the client, and conduct a user-needs analysis, to determine database functionality
  • 1.2 Analyse the results of a user-needs analysis to identify technical requirements
  • 1.3 Develop a conceptual model of the database
  • 1.4 Submit the conceptual model to the client for review
  • 1.5 Evaluate client feedback and make changes as required
2. Develop a logical data model
  • 2.1 Identify the attributes and determine the data types
  • 2.2 Undertake the normalisation of attributes
  • 2.3 Develop an entity-relationship (ER) diagram in order to clarify the cardinality of relationships
  • 2.4 Document attributes, normalised data, and the ER diagram
  • 2.5 Forward documentation to the client for confirmation
3. Design the data structures
  • 3.1 Confirm primary and foreign keys for tables
  • 3.2 Review client business rules
  • 3.3 Identify the referential integrity constraints
  • 3.4 Establish database management system constraints and incorporate into database design
  • 3.5 Develop the validation rules for data
  • 3.6 Design indexes and develop the data dictionary
  • 3.7 Document the database design
4. Design queries, screens and reports
  • 4.1 Design the user interface for database, including menus, input screens and outputs
  • 4.2 Design queries, based on requirements
  • 4.3 Design output reports, based on requirements
  • 4.4 Compare the physical design with the conceptual model, or user-needs analysis
  • 4.5 Incorporate changes as required
5. Design access and security systems
  • 5.1 Review the business security plan as a basis for commencing the access and security design
  • 5.2 Design the password and access system for the database
  • 5.3 Identify multiple-user requirements
  • 5.4 Develop client access profiles using the client business model
6. Confirm the database design
  • 6.1 Identify the database backup and recovery requirements
  • 6.2 Develop and document the database backup and restore procedures
  • 6.3 Submit the database, and documentation, to the client for final approval
No information
No information
Replaces
State Code National Code Title Type
D7776 ICADBS502A Design a database Unit of competency
Replaced By
State Code National Code Title Type
OBU88 ICTDBS506 Design databases Unit of competency