CSE 344 - Introduction to Database Systems
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 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.
CSE 344 Staff
Eden Chmielewski (instructor)
She/her pronouns, edenski@cs
OH: Friday 3:30 -4:30pm @ CSE1 5th Floor Breakout
Zareef Amyeen
He/him pronouns, zamyeen@cs
OH: Tuesday 5:00-6:00pm @ Zoom
Winston Bullen
He/him pronouns, wbullen@cs
OH: Monday 1:30-2:30 @ CSE1 4th Floor Breakout
Friday 3:30-4:30pm @ CSE1 5th Floor Breakout
Amal Jacob
He/him pronouns, amalj3@cs
OH: Thursday 5:00-6:00pm @ CSE1 2nd Floor Breakout
Friday 10:30-12:00pm @ CSE1 2nd Floor Breakout
Arjun Jagnani
Yitong Shan
She/her pronouns, yitonsh@uw
OH: Thursday 3:30-4:30pm @ Zoom
Rituraj Sohoni
He/him pronouns, rituraj8@cs
OH: Monday 3:30-4:30pm @ CSE2 131
Zage Rebecca Hart Strassberg-Phillips
She/her pronouns, zages@cs
OH: Tuesday 11:30-12:30pm @ CSE1 2nd Floor Breakout
Office Hour Schedule
Calendar
See Canvas (under Panopto tab) for lecture recordings
Date
Slides
Reading
Week 3
Monday, January 15
No class (Martin Luther King Jr. Day)
Week 4
Monday, January 22
SQL Subqueries (cont.)
Friday, January 26
ER Diagrams (cont.)
2.1
Friday, February 2
BCNF Decomposition (cont.)
Wednesday, February 7
Serializability (cont.)
Week 8
Monday, February 19
No class (Presidents' Day)
Friday, February 23
Tuning and Indexing (cont.)
8.3-4, 14.1-7
Friday, March 1
SQL++ (cont.)
Wednesday, March 6
Parallel Databases (cont.)
Section
Time Slots
AA (ECE 025) - 8:30 - 9:20 AM: Amal and Zage
AB (MGH 254) - 9:30 - 10:20 AM: Rituraj and Sumedh
AC (JHN 111) - 10:30 - 11:20 AM: Allison and Aparna
AD (AND 010) - 12:30 - 1:20 PM: Winston and Chris
AE (MOR 225) - 9:30 - 10:20 AM: Yitong and Zareef
Materials
Section 1, January 4th: slides, demo, section recording
Section 2, January 11th: slides, worksheet, worksheet solutions
Section 3, January 18th: slides, worksheet, worksheet solutions
Section 4, January 25th: slides, worksheet, worksheet solutions
Section 5, February 1st: slides, worksheet, worksheet solutions
Section 6, February 8th: slides, worksheet, worksheet solutions
Section 7, February 15th: slides, worksheet, worksheet solutions, demo
Section 8, February 22nd: slides, worksheet, worksheet solutions, demoT1, demoT2
Section 9, February 29th: Flight Application Homework Support
Section 10, March 7th: slides, worksheet, worksheet solutions
Assignments
HW1 due Friday, January 12th @ 11pm (details on Gradescope)
Note: If you're waiting for a spot in the course to open, the spec can be accessed here
HW2 due Monday, January 22nd @ 11pm (spec)
HW3 due Friday, February 2nd @ 11pm (spec, Azure setup guide)
HW4 due Friday, February 9th @ 11pm (spec)
HW5 due Friday, February 16th @ 11pm (spec)
HW6: Flight Application Project (spec)
Milestone 0 due Friday, February 16th @ 11pm (no late days!)
Milestone 1 due Friday, February 23rd Sunday, February 25th @ 11pm
Milestone 2 due Friday, March 1st Sunday, March 3rd @ 11pm
HW7 due Sunday, March 10th @ 11pm (spec, helpful guide) (no late days!)
Exams
There will be two quizzes for this course. Both exams will be offered on Gradescope and can be taken at home.
Quiz 1 releases Tuesday, Feb. 13th at 7am, due Wednesday, Feb. 14th at 2pm. Topics are similar to HW1, HW2, and HW3, 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
Quiz 2 releases Tuesday, March 12th at 7am, due Wednesday, March 13th at 2pm. Topics are similar to the homework sets and will focus on HW4, HW5, and HW7. The quiz should only take around 60 minutes to complete.
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