Schedule

This is a tentative schedule. Lectures are run by Kenny Lu (KL) and Anh Dinh (AD).

Week
Lecture
Tutorial
1

Intro, ER model (KL)

Reading:

  • DBM: Chapter 1-2
  • DSC: Chaper 7

MySQL, AWS
2

Relational Model, Relational Algebra (KL)

Reading:

  • DBM: Chapter 3-4
  • DSC: Chapter 2,6

Data model + Relational Algebra
3

SQL, NoSQL (KL)

Reading:

  • DBM: Chapter 4-5
  • DSC: Chapter 2-4

SQL
4

Assignment 1 Submission


Functional Dependencies, Normal Forms (KL)

Reading:

  • DBM: Chapter 19
  • DSC: Chapter 8

FD + Normal Forms
5

Storage, Index

Reading:

  • DBM: Chapter 8-11
  • DSC: Chapter 10-11

Storage, Index
6

Project Submission 1


Query Operations (AD)

Reading:

  • DBM: Chapter 12-14
  • DSC: Chapter 12

Query Operations
7

Recess

Recess
8

Project Submission 2


Query Optimization (AD)

Reading:

  • DBM: Chapter 15
  • DSC: Chapter 13

Query Optimization
9

Transactions (AD)

Reading:

  • DBM: Chapter 16-18
  • DSC: Chapter 14-16

Transactions
10

HDFS, MapReduce (KL)

HDFS, MapReduce
11

Project Submission 3


Spark (KL)

Spark
12

Assignment 2 Submission


Yarn, Revision (KL)

Project, Consultation
13

Project Submission 4


Guest Lecture : TBD

Project, Consultation
14

Exam

Exam