Course Title: Model data objects
Part A: Course Overview
Program: C5341 Diploma of Information Technology
Course Title: Model data objects
Portfolio: Vocational Education
Nominal Hours: 30
Regardless of the mode of delivery, represent a guide to the relative teaching time and student effort required to successfully achieve a particular competency/module. This may include not only scheduled classes or workplace visits but also the amount of effort required to undertake, evaluate and complete all assessment requirements, including any non-classroom activities.Terms
Course Code |
Campus |
Career |
School |
Learning Mode |
Teaching Period(s) |
COSC7363C |
City Campus |
TAFE |
650T Vocational Business Education |
Face-to-Face or Internet |
Term1 2017, Term2 2017, Term1 2018, Term2 2018, Term1 2019, Term2 2019 |
Course Contact: Val Christou
Course Contact Phone: +61 3 9925 5076
Course Contact Email: val.christou@rmit.edu.au
Course Description
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.
Pre-requisite Courses and Assumed Knowledge and Capabilities
None
National Competency Codes and Titles
National Element Code & Title: |
ICTSAD501 Model data objects |
Elements: |
1. Identify entities and relationships 2. Develop normalisation 3. Validate model |
Learning Outcomes
Overview of Assessment
In order to achieve competency in this unit, you must provide:
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.
Knowledge Evidence
To complete the unit requirements safely and effectively, you 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
Assessment must be conducted in a safe environment where evidence gathered demonstrates 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.
You are advised that you are likely to be asked to personally demonstrate your assessment work to your teacher to ensure that the relevant competency standards are being met.
Feedback
Feedback will be provided throughout the semester in class and/or online discussions. You are encouraged to ask and answer questions during class time and online sessions so that you can obtain feedback on your understanding of the concepts and issues being discussed. Finally, you can email or arrange an appointment with your teacher to gain more feedback on your progress.
You should take note of all feedback received and use this information to improve your learning outcomes and final performance in the course.