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
Project 1 Release 10/1 Mon See Course Info for general submission information and the regrade policy. [project_part1.pdf]
[Getting started with BigQuery]
Lecture 3 10/2 Tu SQL II
Concepts: joins, set operators, subqueries
HW: 6d, 6g, lab 2
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
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
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


Shiva Shivakumar

Teaching Assistants

Jennie Chen
Jiaxi Chen
Laura Cruz-Albrecht
Alan Flores-Lopez
Vishesh Gupta
Todd Macdonald
Leo Mehr (head)
Lantao Mei
Ben Parks
Amelia Vu
Lucy Wang
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