Category Map Managing Data
Data - Anomolies
including: insert, delete and update 12 ATAR
Data - Data Integrity
referential, domain, and entity integrity 12 GEN, 11 ATAR, 12 ATAR
Data - Data Management Techniques
Managing Data storage using files and folders 11GEN
Data - Data Modelling
using Chen's notation ER diagrams 11 ATAR , 12 ATAR
Data - Data Protection Methods
encryption 12 GEN, 11 ATAR
authentication 12 GEN, 11 ATAR
Data - Data Types
number, date, currency, text/string, Boolean 12 GEN, 11 ATAR
Data - Data Warehouse, Data Marts, Data Mining
structures 12 ATAR
role of data mining 12 ATAR
compare DW and DM as data storage and distribution 12 ATAR
Data - Validation Rules
purpose and types 12 ATAR
Database - Data Dictionary
purpose 12 ATAR
elements 12 ATAR
Database - Documentation
purpose for the user 12 GEN, 11 ATAR, 12 ATAR
Database - Interface and Nav Design
within database systems 12 GEN, 11 ATAR, 12 ATAR
Database - Features of Database Software
components of a single table database 11GEN
data entry forms 11GEN
simple search techniques 11GEN
create a simple query 11GEN
simple data types 11GEN
Database - Types of Databases
distributed, centralised 12 ATAR
online, local 12 ATAR
Ethical and Legal Issues
ethics in storage of personal data 11GEN
relating to personal use and storage of data 12 GEN, 11 ATAR, 12 ATAR
information about individuals kept by organisations 12 GEN, 11 ATAR
use of online databases 12 GEN
of data warehouses, marts and mining 12 ATAR
impact of privacy laws on storage and distribution of data 12 ATAR
disposal of personal data 12 ATAR
Features of Spreadsheet Software
spreadsheet terms cell, formula, label etc 12 GEN
spreadsheet terms lookup tables 11 ATAR
simple functions 11GEN
simple formulae 11GEN
Features of Word Processing Software
common formatting functions 11GEN
RDBMS - Key Types in a Relational Database
primary, composite and foreign keys 12 ATAR
RDBMS Normalisation
Overview 12 ATAR
to 3rd normal form 12 ATAR
RDBMS - Resolving M:N relationships
purpose 12 ATAR
how to resolve them 12 ATAR
RDBMS - Cardinality
1:1, 1:M, M:1, M:N 12 ATAR
Theory - Other Data Concepts
data definition 12 ATAR
data duplication 12 ATAR
data redundancy 12 GEN, 11 ATAR, 12 ATAR
data manipulation 12 ATAR
data security 12 ATAR
THEORY - Hierarchical Structure of Data
character/byte, field, record, table/relation 12 GEN, 11 ATAR
THEORY - Open Systems in Database interconnectivity
role for open systems in database interconnectivity 12 ATAR
development and management in data driven websites 12 ATAR
SKILLS - Apply Simple Control Structures
including IF statements and calculations 12 ATAR
SKILLS - SQL
insert, update and select queries (up to two tables) 12 ATAR