CS 145

Data Management and Data Systems

Fall 2018

Event Date Description Course Materials
Lecture 1 9/25 Tu Relational Data Model
Concepts: data models, database management system overview
[Slides: Intro, Why databases?]
[Slides: Relational Data Model]
[Class Projects Outline]
Lecture 2 9/27 Th SQL I
Concepts: schemas, select from where
HW: 6a, 6e
[Slides]
Project 1 Release 10/1 Mon See Course Info for general submission information and the regrade policy. [project_part1.pdf]
[project1_submission.py]
[Getting started with BigQuery]
Lecture 3 10/2 Tu SQL II
Concepts: joins, set operators, subqueries
HW: 6d, 6g, lab 2
[Slides]
Lecture 4 10/4 Th SQL III and ER Models
Concepts: grouping and aggregations, nested queries, quantifiers, nulls, nested queries
HW: 6b, 6c, 6f, lab 1
[E/R Slides]
Lecture 5 10/9 Tu Design Theory I
Concepts: Normal forms, functional dependencies, closures, superkeys, keys
HW: 3a, 3b
[Slides]
Lecture 6 10/11 Th Design Theory II
Concepts: Decomposition, BCNF, 3NF, MVDs
HW: 3c, 3d
[See lecture 5 slides]
Project 1 Due 10/12 Fri
Lecture 7 10/16 Tu Transactions I
Concepts: Performance, ACID, Logging
[Slides]
Project 2 Release Exact date TBD
Lecture 8 10/18 Th Transactions II
Lecture 9 10/23 Tu TBD
Lecture 10 10/25 Th TBD
Lecture 11 10/30 Tu TBD
Midterm 11/1 Th In-class (4:30 - 5:50pm)
Project 2 Due Exact date TBD
Lecture 12 11/6 Tu The IO Model & External Sorting I
Project 3 Release Exact date TBD
Lecture 13 11/8 Th The IO Model & External Sorting II
Lecture 14 11/13 Tu Join
Lecture 15 11/15 Th The Details of Joins
Thanksgiving -- no lecture 11/20 Tu
Thanksgiving -- no lecture 11/22 Th
Lecture 16 11/27 Tu The Relational Model
Lecture 17 11/29 Th Optimization Overview
Project 3 Due Exact date TBD
Lecture 18 12/4 Tu
Lecture 19 12/6 Th
Final Exam 12/14 Fr 3:30 - 6:30 p.m

Instructor

shiva
Shiva Shivakumar

Teaching Assistants

jennie
Jennie Chen
jiaxi
Jiaxi Chen
laura
Laura Cruz-Albrecht
alan
Alan Flores-Lopez
vishesh
Vishesh Gupta
todd
Todd Macdonald
leo
Leo Mehr (head)
lantao
Lantao Mei
ben
Ben Parks
amelia
Amelia Vu
lucy
Lucy Wang
anna
Anna Zhu

Office Hours

All OH will be held in Huang Basement, in the large, open collaboration area with desk/tables. The one exception is Prof Shiva's OH, which will be held in Gates 415.
To sign up for OH, use our queue: https://queuestatus.com/queues/259