COMP 340: Databases
Spring 2025
Administrivia
- Instructor: Phillip Kirlin
- Office hours: Mon 3:30-4:45, Tue/Thu 11-12:15, Wed 9:30-10:45 in Briggs 209. Also available by appointment.
- Canvas page: Use for grades, online assignment submissions, and assignment solutions.
- Syllabus and additional policies.
- Sign up for the CS Slack!
Calendar
- Wed, Jan 15
- Introduction
- Slides
- Mon, Jan 20
- MLK Holiday
- Wed, Jan 22
- Data models
- Slides
- Reading: FCDB Chapter 1
- Mon, Jan 27
- Relational algebra
- Slides
- Reading: FCDB 2.4
- Wed, Jan 29
- Relational algebra, start SQL
- Handout: Database connection instructions
- Reading: FCDB 6.1
- Homework Homework 1, due Mon, Feb 3
- Project Project Milestone 1, due Monday, Feb 10
- Handout: Database connection instructions
- Mon, Feb 3
- SQL II
- Queries
- Reading: FCDB 6.2
- Wed, Feb 5
- SQL Practice
- Mon, Feb 10
- SQL III (subqueries)
- Queries
- Reading: FCDB 6.3
- Wed, Feb 12
- SQL IV (aggregation and grouping)
- Queries
- Reading: FCDB 6.4
- Mon, Feb 17
- Creating tables
- Queries
- Homework Homework 2, due Mon, Feb 24
- Wed, Feb 19
- Snow day
- Mon, Feb 24
- E/R Diagrams I
- Slides
- Wed, Feb 26
- E/R Diagrams II
- Slides
- Mon, Mar 3
- E/R Diagrams III
- Slides
- Wed, Mar 5
- E/R Diagrams IV
- Slides
- Converting diagrams to
CREATE TABLEstatements- Homework Homework 3, due Wed, Mar 19
- Project Project Milestone 2, due Mon, Mar 31
- Mon, Mar 10
- Review
- Wed, Mar 12
- Spring break
- Mon, Mar 17
- Spring break
- Wed, Mar 19
- Review
- Mon, Mar 24
- Database programming in Python
- Wed, Mar 26
- Midterm
- Mon, Mar 31
- TBA
- Wed, Apr 2
- TBA
- Mon, Apr 7
- TBA
- Wed, Apr 9
- TBA
- Mon, Apr 14
- TBA
- Wed, Apr 16
- TBA
- Mon, Apr 21
- TBA
- Wed, Apr 23
- TBA
- Mon, Apr 28
- TBA
- Wed, Apr 30
- TBA
The Data 8 Website Dark Mode™ is in beta. You can provide feedback about the website here