ConceptualModeling < Main

Main

Main.ConceptualModelingr1.1 - 11 Feb 2006 - 16:55 - Main.novatopic end

(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

End of topic
Skip to action links | Back to top

You are here: Main > ConceptualModeling

to top