CSE 414 - 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 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.
CSE 414 Staff
Rachel Phuong
She/her pronouns, rphuong@cs
OH: Tuesday 10:00am - 11:00am (zoom link)
Davin Kyi
He/him pronouns, davin123@cs
OH: Saturday 1:00pm - 2:00pm (zoom link)
Ivan Belikov
He/him pronouns, ivanb13@uw
OH: Monday 2:30pm - 3:30pm (zoom link)
Eden Chmielewski
She/her pronouns, edenski@cs
OH: Monday 9:00am - 10:00am (zoom link)
Divya Rangarajan
She/her pronouns, divyar28@cs
OH: Thursday 3:00pm - 4:00pm @ CSE1 220
Arjun Jagnani
He/him pronouns, ajagnani@uw
OH: Monday 11:00am - 12:00pm @ CSE1 4th Floor Breakout
Ananya Sharma
She/her pronouns, ananya03@uw
OH: Tuesday 4:00pm - 5:00pm (zoom link)
Huong Ngo
She/her pronouns, hvn2002@uw
OH: Wednesday 5:00pm - 6:00pm (zoom link)
Calendar
See Canvas (under Panopto tab) for lecture recordings
Date
Slides
Reading
Wednesday, October 5
SQL Joins (cont.)
Friday, October 21
Database Design - ER Diagrams cont.
2.1
Wednesday, November 2
Transactions - Serializability cont.
18.1, 18.2
Friday, November 11
No class (holiday)
Friday, November 18
Parallel Databases (cont.)
Wednesday, November 23
No class (holiday)
Friday, November 25
No class (holiday)
Section
Time Slots
AA/BA - 12:30 - 1:20 PM (PCAR 395): Ananya/Qirui
AB/BB - 1:30 - 2:20 PM (SMI 107): Kush/Jevin
AC/BC - 2:30 - 3:20 PM (MOR 225): Arjun/Davin
AD/BD - 3:30 - 4:20 PM (BLD 392): Rachel
AE/BE - 11:30 - 12:20 PM (SIG 230): Ivan/Hongyi
CB - 9:30 - 10:20 AM (MGH 238): Divya/Huong
CC - 11:30 - 12:20 PM (MGH 241): Nishtha/Nina
CD - 12:30 - 1:30 PM (ARC G070): Kashyap/Hadif
Materials
Section 1, September 29th: slides (AE/BE), slides (CB), slides (CC), demo
Section 2, October 6th: slides (CB), slides (CC), worksheet, solutions, demo (AE)
Section 3, October 13th: slides(AB), slides(CB), slides (CC), worksheet, solutions, demo (AB)
Section 4, October 20th: slides (CB), worksheet, solutions
Section 5, October 27th: slides(CB), slides(CC), worksheet, solutions
Section 6, November 3rd: slides (CC), worksheet, solutions
Section 7, November 10th: slides(CC), worksheet 1 (solutions1), worksheet 2 (solutions2)
Section 8, November 17th: slides(CB), worksheet, solutions
Section 9, December 1st: slides(CC), worksheet, solutions
Assignments
HW1 due Friday, October 7 @ 11pm (specification, follow Gradescope link for lecture A/B or C as appropriate)
HW2 due Monday, October 17th @ 11pm (spec)
HW3 due Wednesday, October 26th @ 11pm (spec, setup guide, demo)
HW4 due Monday, November 7th @ 11pm (spec)
HW5 due Monday, November 14th @ 11pm (spec)
HW6 setup due Monday, November 21st @ 11pm (python spec) (java spec)
Part 1 due Sunday, November 27th @ 11pm
Part 2 due Friday, December 2nd @ 11pm
HW7 due Friday, December 9th @ 11pm (spec)
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 .
Midterm quiz
Releases on Gradescope Thursday November 3rd, due on Friday November 4th at 11am (morning)
Topics on the midterm are similar problems to HW 1 -3, as well as conceptual questions on relational algebra from the slides.
For more practice problems, see midterm exam questions from Autumn 2018 and 2019
Final exam (take home)
Releases on Gradescope Monday December 12th, due on Wednesday December 14th 11pm (evening)
Similar length to midterm quiz, covering material from HW 4, 5, 6, and conceptual questions on semi-structured data models (no SQL++ on the quiz)
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