Description: In this course, we will introduce the basics of modern data management. You will learn about schema design, data modeling, query languages, building database applications, transactions, and many other topics. Through lectures, sections, and assignments, you will learn about and understand how real-world data management systems work, and how they touch upon many aspects of our daily lives.
Questions and Comments: If you have any questions or comments about lecture, sections, assignments, exams, or whatever, post on the discussion board. This is the fastest way to get in contact with the 414 staff and your peers. If you need to talk about anything personal or offline, see us during office hours or email the instructor (maas @ cs) to set up a meeting. And we love feedback! If you have any concerns, comments, or suggestions let us know through this anonymous feedback tool.
Stephanie Zhang
She/her pronouns, szhang79@cs
OH: Thursdays 2-3PM @Allen School 3rd Floor Breakout
Prati Dhamija
He/him pronouns, prati13@cs
OH: Monday 4:30-5:30PM @ Allen School 4th Floor Breakout (CSE1)
Aaditya Desai
Eden Chmielewski
She/her pronouns, edenski@cs
OH: Wednesday 12:25PM - 1:25PM @ Allen Center 4th Floor Breakout
Ethan Sylvia
He/They pronouns, ethans24@cs
OH: Friday 12:30pm-1:30pm Friday @ Allen Center 4th Room Breakout (CSE1)
Alexander Hughes
Calendar
See Canvas (under Panopto tab) for lecture & section recordings.
Date
Slides
Reading
Friday, October 22
Database Design - FDs continued
Week 6
Monday, November 1
Transactions - Schedules (cont)
18.1, 18.2
Friday, November 5
Midterm (on Gradescope or in class)
Wednesday, November 17
Parallel Databases (cont.)
20.1, 20.2
Wednesday, November 24
Holiday (No class)
Friday, November 26
Holiday (No class)
Section
Time slots
Lecture A/B (3:30-4:30PM)
8:30 - 9:20 AG/CA: Shourya Srivastava
11:30 - 12:20 AE/BE: Eden Chmielewski & Aaditya Srivathsan
12:30 - 1:20 AA/BA: Ethan Sylvia
1:30 - 2:20 AB/BB: Lakshay Sahni & Nishtha Agarwal
2:30 - 3:20 AC/BC: Abhishek Shah
3:30 - 4:20 AD/BD: Steve Ma
Lecture C (12:30-1:30PM)
9:30 - 10:20 CB: Shivam Bhatia & Alexander Hughes
11:30 - 12:20 CC: Aadi Jain & Stephanie Zhang
12:30 - 1:20 CD: Prati Dhamija & Aaditya Desai @ WFS 201
4:30 - 5:20 PM Online: Gibbs Geng (link)
Materials
Section 1, 09/30/21: Slides; Compilation of demo queries; Recording
Section 2, 10/7/21: Slides; Worksheet; Solution; Recording;
Section 3, 10/14/21: Slides; Worksheet; Solution; Recording;
Section 4, 10/21/21: Slides; Worksheet; Solution; Recording;
Section 5, 10/28/21: Slides; Worksheet; Solution (without RA Q2), Solution RA Q2; Recording;
Assignments
HW1 due October 8 @ 11pm (Specification , Follow Gradescope link for lecture A/B or C as appropriate)
HW 2 due October 18 @ 11pm (Specification, Follow Gradescope link for lecture A/B or C as appropriate)
HW 3 due October 29 @ 11pm (Specification, Azure Setup Guide, Follow Gradescope link for lecture A/B or C as appropriate, Setup demo from 344)
HW 4 due Nov 8 @ 11pm (Specification, Follow Gradescope link for lecture A/B or C as appropriate)
HW 5 due Nov 16 @ 11pm (Specification, Follow Gradescope link for lecture A/B or C as appropriate)
HW 6 due Dec 8 @ 11pm (Java Spec, python Spec)
HW 7 (optional) (Specification)
Exams
There will be a midterm and a final for this course. Both exams will be offered on Gradescope and can be taken at home . This midterm will look similar to a traditional CSE 414 midterm exam, but you will not be graded on the accuracy of your answers for the first submission. Instead, after you take the exam you will be asked to compare your responses to a published key, annotate your answers to indicate areas you made mistakes, and submit your corrected version. When taking the midterm the first time, you are allowed one page of handwritten notes (front and back.)
Midterm exam - Friday Nov. 5 (in-class or at home on Gradescope). Revision due Monday Nov. 15
Most similar to 414au2018 (sample solutions)
Links to midterm on gradescope:
Lecture A/B: https://www.gradescope.com/courses/320041/assignments/1636526
Lecture C: https://www.gradescope.com/courses/320042/assignments/1636757
Final exam - Finals week (Opens on Gradescope Dec 12th midnight, closes on Dec 16th 11:00pm)
Will cover all topics but extra emphasis on materials from lecture and section in the later half of the course.
No programming in SQL++ required, just conceptual questions on semi-structured data and JSON
Most similar to 414au2018 (sample solutions)
Links to final on gradescope:
Lecture A/B: https://www.gradescope.com/courses/320041/assignments/1714699
Lecture C: https://www.gradescope.com/courses/320042/assignments/1716117
Other Resources
Textbook
Database Systems: The Complete Book (2nd Edition) <errata>
The library has the following that you might find useful if you require another explanation of a topic.
Fundamentals of database systems by Elsmasri and Navathe
Database management systems by Raghu Ramakrishnan and Johannes Gehrke
Foundations of database systems by Abiteboul, Hull and Vianu
Past Lecture Recordings (for UW students)
Look at the course webpage for a schedule of what topic was taught when.
CSE 414 Spring 2020 - Mark Friedman - videos, course webpage
CSE 414 Winter 2020 - Shana Hutchison - videos, course webpage
CSE 344 Spring 2019 - Jonathan Leang - videos, course webpage