^

 
 

Unit of competency details

ICTSAD501 - Model data objects (Release 1)

Summary

Usage recommendation:
Current
Mapping:
MappingNotesDate
Supersedes and is equivalent to ICASAD501A - Model data objectsUpdated to meet Standards for Training Packages 24/Mar/2015

Release Status:
Current
Releases:
ReleaseRelease date
1 1 (this release) 25/Mar/2015


Qualifications that include this unit

CodeSort Table listing Qualifications that include this unit by the Code columnTitleSort Table listing Qualifications that include this unit by the Title columnUsage RecommendationRelease
DEF50217 - Diploma of Enterprise Architecture PracticeDiploma of Enterprise Architecture PracticeCurrent1-2 
ICT40120 - Certificate IV in Information TechnologyCertificate IV in Information TechnologyCurrent1-4 
ICT40515 - Certificate IV in ProgrammingCertificate IV in ProgrammingSuperseded
ICT40518 - Certificate IV in ProgrammingCertificate IV in ProgrammingSuperseded
ICT50115 - Diploma of Information TechnologyDiploma of Information TechnologySuperseded1-2 
ICT50118 - Diploma of Information TechnologyDiploma of Information TechnologySuperseded
ICT50120 - Diploma of Information TechnologyDiploma of Information TechnologySuperseded1-2 
ICT50220 - Diploma of Information TechnologyDiploma of Information TechnologyCurrent1-2 
ICT50515 - Diploma of Database Design and DevelopmentDiploma of Database Design and DevelopmentSuperseded1-3 
ICT50615 - Diploma of Website DevelopmentDiploma of Website DevelopmentSuperseded1-3 
Items per page 10 | 20 | 50 | 100
Displaying items 1 - 10 of 14

Classifications

SchemeCodeClassification value
ASCED Module/Unit of Competency Field of Education Identifier 020301 Conceptual Modelling  

Classification history

SchemeCodeClassification valueStart dateEnd date
ASCED Module/Unit of Competency Field of Education Identifier 020301 Conceptual Modelling  30/Jul/2015 
The content being displayed has been produced by a third party, while all attempts have been made to make this content as accessible as possible it cannot be guaranteed. If you are encountering issues following the content on this page please consider downloading the content in its original form

Unit of competency

Modification History

Release 

Comments 

Release 1

This version first released with ICT Information and Communications Technology Training Package Version 1.0.

Application

This unit describes the skills and knowledge required to understand business operations, identify entities and data, diagrammatically represent their relationships, and prepare a data model.

It applies individuals who have a broad range of analytical, technical and communication skills and who work within broad but established parameters.

No licensing, legislative or certification requirements apply to this unit at the time of publication.

Unit Sector

Systems analysis and design

Elements and Performance Criteria

ELEMENT 

PERFORMANCE CRITERIA 

Elements describe the essential outcomes.

Performance criteria describe the performance needed to demonstrate achievement of the element.

1. Identify entities and relationships

1.1 Analyse business data to understand operations

1.2 Identify boundaries of the system

1.3 Identify entities, attributes, data types and relationships of data

1.4 Review business rules to determine impact

1.5 Document relationships in an entity relationship diagram

2. Develop normalisation

2.1 Identify suitable business data

2.2 Undertake normalisation of business data and document results

2.3 Compare normalisation results with entity relationship diagram

2.4 Reconcile differences between data

3. Validate model

3.1 Validate data model with client

3.2 Resolve issues or recommendations

3.3 Document completed data model

3.4 Submit to client for final approval

Foundation Skills

This section describes language, literacy, numeracy and employment skills incorporated in the performance criteria that are required for competent performance.

Skill 

Performance Criteria 

Description 

Reading

1.1, 1.4, 2.3, 2.4

  • Critically analyses complex documentation from a variety of sources and consolidates information relating to specific criteria to determine requirements

Writing

1.5, 2.2, 2.4, 3.3, 3.4

  • Prepares and produces diagrammatic models and associated documents that convey complex relationships between data
  • Documents outcomes and changes to discussions, using industry relevant terminology and recognised symbols

Oral Communication

3.1-3.4

  • Participates in verbal exchanges by listening and questioning clients to elicit information, resolve issues, and obtain final product and work outcome approval

Interact with others

3.1, 3.2, 3.4

  • Selects, implements and seeks to improve protocols governing communications to clients and co-workers in a range of work contexts
  • Elicits feedback and provides feedback to others

Get the work done

1.1-1.4, 2.1, 3.2, 3.3

  • Accepts responsibility for planning and sequencing complex tasks and workload, negotiating key aspects with others and taking into account capabilities, efficiencies and effectiveness
  • Applies systematic and analytical decision making processes for complex and non-routine situations
  • Uses and investigates new digital technologies and applications to manage and manipulate data and communicate effectively with others, in a secure and stable digital environment

Unit Mapping Information

Code and title 

current version 

Code and title 

previous version 

Comments 

Equivalence status 

ICTSAD501 Model data objects

ICASAD501A Model data objects

Updated to meet Standards for Training Packages

Equivalent unit

Links

Companion Volume implementation guides are found in VETNet - https://vetnet.gov.au/Pages/TrainingDocs.aspx?q=a53af4e4-b400-484e-b778-71c9e9d6aff2

Modification History

Release  2.  This is the second release of this unit of competency in the TLI Transport and Logistics Training Package:

  • Minor word changes and reordering in Knowledge Evidence
  • Minor statement changes in Assessment Conditions.

Release 1.  This is the first release of this unit of competency in the TLI Transport and Logistics Training Package.

Performance Evidence

Evidence required to demonstrate competence in this unit must be relevant to and satisfy all of the requirements of the elements and performance criteria on at least one occasion and include:

  • applying precautions and required action to minimise, control or eliminate hazards that may exist when using communications systems
  • communicating and working effectively with others using available communications systems
  • completing documentation related to work activities when using communications systems
  • following communications security procedures
  • identifying and using required communications technology
  • implementing contingency plans
  • modifying activities depending on differing operational contingencies, risk situations and environments
  • monitoring communications equipment performance and taking appropriate action as required
  • operating and adapting to differences in communications equipment in accordance with operating procedures
  • planning, monitoring and prioritising work activities in terms of planned schedule, including predicting consequences and identifying improvements
  • reading, interpreting and following communications systems instructions, procedures and relevant legislation
  • reporting and/or rectifying identified problems, faults or malfunctions promptly in accordance with workplace procedures
  • using communications equipment
  • working systematically with required attention to detail without injury to self or others, or damage to goods or equipment.

Knowledge Evidence

Evidence required to demonstrate competence in this unit must be relevant to and satisfy all of the requirements of the elements and performance criteria and include knowledge of:

  • communication techniques including barriers to effective communication and how to overcome them
  • features of various communications systems
  • minor routine maintenance procedures for communications equipment
  • pre-operational checks for communications systems and equipment
  • principles of effective communication
  • procedures and protocols for using communications systems during an emergency
  • protocols and procedures for communicating with others using relevant communications technology including public address (PA) systems
  • relevant procedures and duty of care requirements
  • relevant work health and safety (WHS)/occupational health and safety (OHS) responsibilities
  • typical problems that may occur when using communications systems, and appropriate action and solutions.

Assessment Conditions

Assessors must hold credentials specified within the Standards for Registered Training Organisations current at the time of assessment.

Assessment must satisfy the Principles of Assessment and Rules of Evidence and all regulatory requirements included within the Standards for Registered Training Organisations current at the time of assessment.

Assessment must occur in workplace operational situations where it is appropriate to do so; where this is not appropriate, assessment must occur in simulated workplace operational situations that replicate workplace conditions.

Assessment processes and techniques must be appropriate to the language, literacy and numeracy requirements of the work being performed and the needs of the candidate.

Resources for assessment must include:

  • a range of relevant exercises, case studies and/or other simulations
  • relevant and appropriate materials, tools, equipment and personal protective equipment (PPE) currently used in industry
  • applicable documentation, including workplace procedures, regulations, codes of practice and operation manuals.

Links

Companion Volume Implementation Guides are found in VETNet - https://vetnet.gov.au/Pages/TrainingDocs.aspx?q=df441c6e-213d-43e3-874c-0b3f7036d851

 

Assessment requirements

Modification History

Release 

Comments 

Release 1

This version first released with ICT Information and Communications Technology Training Package Version 1.0.

Performance Evidence

Evidence of the ability to:

  • document client business requirements
  • construct an entity relationship diagram
  • construct and document a data model
  • normalise the model
  • validate the model.

Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.

Knowledge Evidence

To complete the unit requirements safely and effectively, the individual must:

  • fully describe:
  • database identifiers and their impact on database usability
  • normalisation rules and processes
  • type hierarchies, including sub-types, super-types and root-types related to development of structured data types
  • validation procedures and processes
  • describe the function and features of:
  • an approach to data modelling, such as the entity-relationship model
  • keys, e.g. unique keys, composite keys, primary keys and primary index
  • time stamps related to the use of keys
  • user defined types, structured types, reference types and user defined functions
  • data types and their application
  • summarise the particular business domain.

Assessment Conditions

Gather evidence to demonstrate consistent performance in conditions that are safe and replicate the workplace. Noise levels, production flow, interruptions and time variances must be typical of those experienced in the systems analysis and design field of work, and include access to:

  • client’s business requirements
  • special purpose tools, equipment and materials
  • industry software packages
  • computer aided software engineering (CASE) tools
  • entity relationship diagrams.

Assessors must satisfy NVR/AQTF assessor requirements.

Links

Companion Volume implementation guides are found in VETNet - https://vetnet.gov.au/Pages/TrainingDocs.aspx?q=a53af4e4-b400-484e-b778-71c9e9d6aff2