INFS1200 — Dashboard

Course landing note · 12 weeks · 32 notes

Week 1

Lectures

• 2026-02-23 · Conceptual Database Design and the ER Model

Labs

• Practical 1: Course Tools

Concepts

• ER Diagram Notation
• Relationship Constraints

Week 2

Lectures

• 2026-03-02 · Weak Entities, the EER Model and Design Choices

Tutorials

• Applied Class 1: Intro to DBMS and Basic ERD
• Case Study 1: Dirt Road Driving

Concepts

• ER Diagram Notation
• Relationship Constraints

Week 3

Lectures

• 2026-03-09 · The Relational Model and Integrity Constraints

Tutorials

• Applied Class 2: Entity Relationship Diagrams
• Case Study 2: Dirt Road Driving

Concepts

• ER Diagram Notation
• Relational Mapping Notation
• Relationship Constraints

Week 4

Lectures

• 2026-03-16 · ER to Relational Mapping

Tutorials

• Applied Class 3: Relational Integrity
• Case Study 3: Dirt Road Driving

Concepts

• ER Diagram Notation
• Relational Mapping Notation

Week 5

Tutorials

• Applied Class 4: Entity Relationship Mapping

Concepts

• ER Diagram Notation
• Relational Mapping Notation

Week 6

Lectures

• 2026-03-30 · Basic SQL Syntax: Data Definition and Data Manipulation Language

Tutorials

• Applied Class 5: Basic SQL syntax, DDL and DML
• Case Study 4: EasyDrive Insurance (DDL & DML)

Concepts

• Relational Mapping Notation

Week 7

Lectures

• 2026-04-06 · Aggregation, Grouping and Multiple Relation Queries

Tutorials

• Applied Class 6: DQL Aggregation and Grouping
• Case Study 5: EasyDrive Insurance (Queries)

Week 8

Lectures

• 2026-04-13 · Nested Queries, Views and Generative AI & SQL

Tutorials

• Applied Class 7: DQL Multiple Relation SQL Queries

Week 9

Tutorials

• Applied Class 8: DQL Nested Queries and Views

Week 10

Lectures

• 2026-04-27 · Database Design Guidelines and Functional Dependencies

Tutorials

• Applied Class 9: Functional Dependencies
• Case Study 8: Dirt Road Driving (Payroll System — Anomalies and FDs)

Week 11

Lectures

• 2026-05-04 · Normalisation and Relational Database Schema Design

Tutorials

• Applied Class 10: Normalisation, BCNF Decomposition and 3NF Synthesis
• Case Study 9: Payroll System (BCNF Decomposition and 3NF Synthesis)

Week 12

Lectures

• 2026-05-11 · Database Security

Tutorials

• Tutorial 5.1: Database Security

Reference notes

Every evergreen concept note in the course, with the weeks that link to it.

• ER Diagram Notation — weeks 1, 2, 3, 4, 5
• Relational Mapping Notation — weeks 3, 4, 5, 6
• Relationship Constraints — weeks 1, 2, 3