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 344 staff and your peers. If you need to talk about anything personal or offline, see us during office hours or email the instructor (hji14@ cs.washington.edu) 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.
She/her pronouns, hji14@cs
OH: Fridays 10-11 am @ Zoom (Link on Canvas)
She/her pronouns, edenski@cs
OH: Tuesday 9 - 11 am @ Zoom (Link on Canvas)
He/him pronouns, chrish66@cs
OH: Thursdays 11-1 @ Gates 131
He/him pronouns, aaronkim@cs
OH: Wednesday 12-1 @ Allen 4th floor breakout, Thursday 2:30-3:30 @ Allen 3rd floor breakout
She/her pronouns, kaur13@cs
OH: Monday 9-10 am & 12:30-1:30 @ Zoom (Link on Canvas)
See Canvas (under Panopto tab) for lecture recordings
Week 4
Monday, July 8
Database Design - ER Diagrams cont.
4.1 - 4.6
Friday, July 12
Cancelled
Wednesday, July 17
Transactions - Serializability
18.1, 18.2
Wednesday, August 7
SQL++ Wrap up
Wednesday, August 14
No class (project day)
AA - 2:20 - 3:20 PM DEN 112 : Eden/Kiran
AB - 1:10 - 2:10 PM JHN 022: Chris/Aaron
Section 1, June 20: slides, demo
Section 2, June 27: slides, worksheet, solutions
No section on July 4
Section 4, July 11: slides, worksheet, solutions
Section 5, July 18: slides, worksheet, solutions
Section 6, July 25: slides, worksheet, solutions
Section 7, August 1: slides, worksheet, solutions
Section 8, August 8: demo
Section 9, August 15: HW6 Help
HW1 due Monday, June 24 @ 11pm (specification, submit on Gradescope)
HW2 due Monday, July 1 Tuesday July 2 @ 11pm (spec)
HW3 due Friday, July 12 @ 11pm (spec, Azure setup guide)
HW4 due Friday, July 19 @ 11pm (spec)
HW5 due Friday, July 26 Monday July 29 @ 11pm (spec)
HW6: Flight Application Project (spec, E/R diagram, schema)
Milestone 0 due Wednesday, July 31 @ 11pm (no late days!)
Milestone 1 due Wednesday, August 7 @ 11pm
Milestone 2 due Wednesday, August 14 Thursday August 15 @ 11pm (applied the extra late day given to everyone)
There will be two quizzes for this course. Both exams will be offered on Gradescope and can be taken at home.
Quiz 1 releases Monday July 22 at 8am, due Wednesday July 24 at 12pm. Topics are similar problems to HW 1, HW 2, and HW 3, as well as relational algebra conceptual questions from the slides. The quiz should only take around 30-40 minutes to complete.
For practice problems, see midterm exam questions from Autumn 2018 and 2019
OPTIONAL Quiz 2 releases Thursday August 15 at 8am, due Friday August 16 at 2pm. Multiple choices questions from materials throughout the quarter. The quiz should only take around 30-40 minutes to complete.
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
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