COMP3311 - Database Systems

Data Modelling

• Overview
• Entity-Relationship Models
• Relational Model

SQL

• Functions
• Triggers
• Aggregates

Relational Algebra

• Operations

Relational Design

• Functional Dependencies
• Closures and Minimal Covers
• Normalisation