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 anything else, 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 (email below).
For additional details about the class, please refer to the Canvas Website.
CSE 344 Staff
We have a staff of 10 awesome TAs who will be checking the message board regularly M-F, and who will be available during office hours for in person questions
Natalie Fetsch (instructor)
She/her pronouns, nfetsch@cs
Allison G
She/her
Amal Jacob
He/him
I’m looking forward to getting back into cycling in the sun again and getting more time to read. Also excited to participate in this year’s IAPLC, an aquarium contest!
Aparna K
She/her
Something I'm looking forward to this quarter: Spending time outdoors in the sun!
Chris Hunt
chrish66@cs
He/him
I am looking forward to doing more outdoor bouldering this quarter
Ethan Bai
He/Him
Looking forward to more spring skiing/snowboarding and spending time outside with friends!
Hongyi Ji
She/her
Looking forward to enjoy my last quarter both as a TA and at UW!
Jihan Yao
He/Him
As a AI PhD student, I am interested in assessing machine learning models’ capability to generalize beyond trained data and identify their own limitations. I am looking forward to finalizing my ongoing projects and expecting collaboration opportunities. In my spare time, I am mostly devoted to gyms and games. My most exciting game Shadow of the Erdtree will come out soon!
Nina Okubo
She/her
I just came back from studying abroad in Germany so I’m looking forward to being back on campus and working with everyone in-person again
Rituraj Sohoni
He/Him
Something I’m looking forward to this quarter is graduating and starting my professional journey. Other than that, I’m looking forward to all the Formula 1 races!
Sumedh Panatula
He/Him
Looking forward to going kayaking on the waterfront!
Office Hour Schedule
Section Schedule
Projected Calendar
See Canvas (under Panopto tab) for lecture recordings
Note: Topics will be the same as previous quarters. Slides have been copied from previous quarters to give students the opportunity to look ahead at upcoming topics, and quarter-specific information such as assignment due dates will be updated as the quarter progresses
Date
Slides
April 10
ER Diagrams (cont.)
April 19
Serializability (cont.)
April 26
-
Week 7
May 6
Parallel Databases (cont.)
May 15
Lecture as office hours - no formal class, bring your questions :)
Week 9
May 20
SQL++ (cont.)
May 24
HW7 overview and work-through
Week 10
May 27
No class, holiday
May 29
Unrecorded lecture, career topics
May 31
Unrecorded lecture, career topics
Section
See myuw.washington.edu for the quiz section you are signed up for.
Materials
Section 1 : slides, demo, section recording
Section 2: slides, worksheet, worksheet solutions
Section 3: slides, worksheet, worksheet solutions
Section 4: slides, worksheet, worksheet solutions
Section 5: slides, worksheet, worksheet solutions
Section 6: slides, worksheet, worksheet solutions
Section 7: slides, worksheet, worksheet solutions, demo
Section 8: slides, worksheet, worksheet solutions, demoT1, demoT2
Section 9: Flight Application Homework Support
Section 10: slides, worksheet, worksheet solutions
Assignments:
Due dates will be released on a rolling basis to ensure that when a due date is released, it will not be adjusted later.
HW1 due Thurs 4/4 @ 11pm (spec here)
HW2 due Mon 4/15 @ 11pm (spec here)
HW3 due Fri 4/26 @ 11pm (spec here, Azure setup guide)
HW4 due Fri 5/3 @ 11pm (spec here. You may find this BCNF example helpful if you want more BCNF practice first)
HW5 due Fri 5/10 @ 11pm (spec here)
HW6: Flight Application Project (spec here, E/R diagram, schema)
Milestone 0 due May 10 @ 11pm
This is the only assignment where we will have a "soft" deadline and a "hard" deadline
Milestone 1 due 17 @ 11pm
Milestone 2 due 24 27 @ 11pm UPDATE: Moved to be due the 27th because of the autograder issues
HW7 due May 31 @ 11pm (helpful guide, spec)
Exams
There will be no exams for this course.
Other Resources
Textbook
Completely optional: Database Systems: The Complete Book (2nd Edition) <errata>
This textbook is not required for the course. The slides and lectures are sufficient to succeed. It is provided purely for students who would like to learn more or would like a second source of knowledge. You can find corresponding readings with previous versions of the course websites
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