INFS1200 — Dashboard
Course landing note · 12 weeks · 66 notes
Study guides: Full course · Week 1 · Week 2 · Week 3 · Week 4 · Week 5 · Week 6 · Week 7 · Week 8 · Week 9 · Week 10 · Week 11 · Week 12
Week 1
Lectures
- 2026-02-23 · Conceptual Database Design and the ER Model
Labs
Concepts
Week 2
Lectures
- 2026-03-02 · Weak Entities, the EER Model and Design Choices
Tutorials
Concepts
Week 3
Lectures
- 2026-03-09 · The Relational Model and Integrity Constraints
Tutorials
Concepts
Week 4
Lectures
- 2026-03-16 · ER to Relational Mapping
Tutorials
Concepts
- Conceptual Database Design
- Entity Types and Attributes
- ER Design Choices
- ER Diagram Notation
- ER Mapping Pitfalls
- ER to Relational Mapping
- Foreign Keys
- Integrity Constraints
- Relational Keys
- Relational Mapping Notation
- Relationship Types
- Specialisation and Generalisation
- Update Operations and Constraint Violations
Week 5
Tutorials
Concepts
Week 6
Lectures
Tutorials
Concepts
Week 7
Lectures
- 2026-04-06 · Aggregation, Grouping and Multiple Relation Queries
Tutorials
Concepts
Week 8
Lectures
- 2026-04-13 · Nested Queries, Views and Generative AI & SQL
Tutorials
Concepts
Week 9
Tutorials
Concepts
Week 10
Lectures
Tutorials
- Applied Class 9: Functional Dependencies
- Case Study 8: Dirt Road Driving (Payroll System — Anomalies and FDs)
Concepts
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)
Concepts
Week 12
Lectures
- 2026-05-11 · Database Security
Tutorials
Concepts
Reference notes
Every evergreen concept note in the course, with the weeks that link to it.
- 3NF Synthesis — week 11
- Aggregation and Grouping — week 7
- Attribute Closure and Finding Keys — week 10
- Conceptual Database Design — weeks 1, 4
- Database Access Control — week 12
- DBMS Fundamentals — weeks 1, 2
- Decomposition and BCNF Design — weeks 10, 11
- Entity Types and Attributes — weeks 1, 2, 4
- ER Design Choices — weeks 2, 3, 4
- ER Diagram Notation — weeks 1, 2, 3, 4, 5
- ER Mapping Pitfalls — weeks 4, 5
- ER to Relational Mapping — weeks 1, 2, 4, 5
- Foreign Keys — weeks 3, 4
- Functional Dependencies — week 10
- INFS1200 Diagram Notation — week 12
- Integrity Constraints — weeks 1, 3, 4
- Interpreting ER Diagrams — weeks 1, 2, 3
- Minimal Cover — week 11
- Nested Queries (Subqueries) — weeks 8, 9
- Normal Forms (1NF to BCNF) — weeks 10, 11
- NULLs in SQL — weeks 1, 3, 6, 10
- Relational Division — weeks 8, 9
- Relational Keys — weeks 3, 4
- Relational Mapping Notation — weeks 3, 4, 5, 6
- Relationship Constraints — weeks 1, 2, 3
- Relationship Types — weeks 1, 3, 4
- Specialisation and Generalisation — weeks 1, 2, 4
- SQL Data Definition Language (DDL) — weeks 3, 6
- SQL Data Manipulation: INSERT, UPDATE, DELETE — week 6
- SQL Injection — week 12
- SQL Joins — weeks 7, 8
- SQL Set Operations — weeks 7, 8
- SQL Views — weeks 8, 9
- The Relational Model — week 3
- The SELECT Statement and Its Clause Order — weeks 6, 7, 8
- Update Anomalies and Informal Design Guidelines — week 10
- Update Operations and Constraint Violations — weeks 3, 4, 6