SWEN 304 Lecture Schedule (2021, T1)

This schedule is subjust ot some minor changes.
Week of Term Start Lecture Topics Readings from the Textbook (6th edition) Assignments and Projects
Week 1 22 February
  • Chapter 1
  • Chapter 2
 
Week 2 1 March
  • Chapter 3
 
Week 3 8 March
  • Chapters 7 and 8
 
Week 4 15 March
  • Chapters 4 and 5
  • Sections 6.1-6.5
 
Week 5 22 March
  • Chapter 19
  • PostgreSQL Manual
Assignment 1 due
Week 6 29 March

   
Study break 2 April - 18 April
Week 7 19 April
  • Query Optimization Tutorial 1
  • Cost-Based Query Optimization
  • Query Optimization Tutorial 2
  • Chapter 15
Project 1 due
Week 8 26 April
  • Update Anomalies
  • Functional Dependencies
  • FD Tutorial
  • Chapter 16
 
Week 9 3 May
  • Normal Forms
  • Decomposition and Synthesis
  • Normalization Tutorial
  • Chapter 7
  • Chapter 8
Assignment 2 due
Week 10 10 May
  • Lossless join decomposition Tutorial
  • Java DataBase Connectivity (JDBC)
  • JDBC Tutorial
  • Chapter 9
  • The Java Tutorial
 
Week 11 17 May
  • Transaction Processing
  • Concurrency Control
  • Transaction tutorial
  • Chapter 21
  • Chapter 22
Assignment 3 due
Week 12

24 May

  • Chapter 23

Project 2