Application
This unit applies to individuals in a range of information and communications technology (ICT) areas who are required to maintain RFID data and make kit available to an RFID system.
Prerequisites
Not applicable.
Elements and Performance Criteria
1. Determine data mapping and integration requirements | 1.1 Identify and document the format of the data from the RFID system, including data schema 1.2 Collect required data, target database requirements and implementation details ensuring uniqueness of entries |
2. Perform data transition | 2.1 Write and test conversion programs and use conversion tools 2.2 Ensure clean data take-on by converting according to database requirements 2.3 Use database adaptors and interfaces for data transition |
3. Check data transition | 3.1 Verify that data transition has been completed according to requirements 3.2 Document programs, procedures and processes according to clients requirements 3.3 Provide conversion reports to client for sign-off |
Required Skills
Required skills
analytical skills to determine data objects required, data structures and business requirements
communication skills to liaise with clients to discuss issues
literacy skills to generate database and sample reports
technical skills to:
build a database using a commercially available database product, including Microsoft Structured Query Language (MS SQL) Server 7.0, Oracle and Sybase
register a data source name (DSN)
use appropriate database data formats
use appropriate RFID data formats
use data conversion programs
use hypertext markup language (HTML) or eXtensible markup language (XML)
use ISO/IEC standard 15962:2004 as a reference
use website administration software and site server utilities.
Required knowledge
client database data structures
client data management and data security policy and procedures
data analysis, particularly in determining data types and data structures and query and report design
data source names in use by the organisation
open database connection (ODC)
primary files and transaction logs to confirm appropriate database activity
quality assurance practices
software tools
system data requirements
system’s current functionality
website foundations.
Evidence Required
The evidence guide provides advice on assessment and must be read in conjunction with the performance criteria, required skills and knowledge, range statement and the Assessment Guidelines for the Training Package.
Overview of assessment | |
Critical aspects for assessment and evidence required to demonstrate competency in this unit | Evidence of the ability to: identify formats of RFID system output and data fields in database analyse, write, install and test conversion programs identify format of data fields of database write or obtain, and install conversion software compile entries in database reports. |
Context of and specific resources for assessment | Assessment must ensure access to: conversion tools database software networked computers organisational guidelines RFID equipment specifications appropriate learning and assessment support when required modified equipment for people with special needs. |
Method of assessment | A range of assessment methods should be used to assess practical skills and knowledge. The following examples are appropriate for this unit: direct observation of candidate configuring an RFID system and database using a range of equipment in a variety of scenarios evaluation of candidate’s documentation that includes programs, procedures and processes review of candidate-generated conversion reports. |
Guidance information for assessment | Holistic assessment with other units relevant to the industry sector, workplace and job role is recommended, where appropriate. Assessment processes and techniques must be culturally appropriate, and suitable to the communication skill level, language, literacy and numeracy capacity of the candidate and the work being performed. Indigenous people and other people from a non-English speaking background may need additional support. In cases where practical assessment is used it should be combined with targeted questioning to assess required knowledge. |
Range Statement
The range statement relates to the unit of competency as a whole. It allows for different work environments and situations that may affect performance. Bold italicised wording, if used in the performance criteria, is detailed below. Essential operating conditions that may be present with training and assessment (depending on the work situation, needs of the candidate, accessibility of the item, and local industry and regional contexts) may also be included.
Database may include: | commercial off-the-shelf (COTS) database packages object-relational databases proprietary databases relational databases software: Access connected to a structured query language (SQL) server DB2 Informix Ingres Microsoft SQL (MS SQL) server Mini SQL (mSQL) MySQL Oracle Sybase. |
Conversion programs may be in: | object-oriented language procedural programming language. |
Conversion tools may include: | analysis of data quality: QDB or Analyze WizRule Unitech Systems Inc cleansing data: Integrity Enterprise or Integrator data-mart management extraction and transformation: Evolutionary Technologies International (ETI) extract InfoPump, InfoHub, InfoRefiner and InfoSuite Passport Warehouse Manager. |
Sectors
Database
Employability Skills
This unit contains employability skills.
Licensing Information
Not applicable.