ICTSAD501 Model data objects

Release: 1

ICTSAD501 Model data objects

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