The acs core body of knowledge for information technology professionals

ion and Modelling 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 and 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