(Primary Source: Australian Computer Society Accreditation Manual. Some parts exist elsewhere in this structure)

• Abstraction and Modelling
  • classification
  • classes
  • types and instances
  • generalisation
  • inheritance
  • association and aggregation.
  • Models as partial views providing particular

perspectives - data, processes, objects, events and time, locations, user and organisational structures and roles, motivations and business purposes.

• Semantic data modelling
  • Entity relationship modelling
    • entity types
    • relationship types
    • attribute types
• The Relational Data Model
  • Transforming entity relationship models into relational models
  • Set theory
  • Relational structures
    • domains
    • base relations
    • virtual relations
    • tuples
    • attributes
    • candidate
    • primary and foreign keys
  • Relational integrity constraints
    • entity, referential and domain integrity
  • Relational manipulation operations
    • relational algebra and calculus
• Normalisation
  • Anomalies caused by redundant data in relations
  • Functional dependency, normalisation and normal forms
• The Structured Query Language
  • Data definition statements - create, drop, alter
  • Data manipulation statements - select, update, delete and insert
  • Access control statements - grant, revoke

to top