<<O>>  Difference Topic ConceptualModeling (r1.1 - 11 Feb 2006 - Main.nova)
Line: 1 to 1
Added:
>
>
META TOPICPARENT OntologyProject
(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
View topic | Diffs | r1.1 | More
Revision -
Revision r1.1 - 11 Feb 2006 - 16:55 - Main.nova