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!
- Final Exam: Wed, May 7, 5:30-8pm
- Final project (everything working) is due Fri, May 9.
- Rubric
- Group evaluation: Turn this in on canvas or in person by Fri, May 9.
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 TABLE
statements- Homework Homework 3, due Wed, Mar 19
- Project Project Milestone 2, due Mon, Mar 31
- Mon, Mar 10
- Spring break
- Wed, Mar 12
- Spring break
- Mon, Mar 17
- Review
- Wed, Mar 19
- Database programming in Python
- Mon, Mar 24
- Midterm
- Wed, Mar 26
- NiceGUI basics
- Mon, Mar 31
- More NiceGUI
- Wed, Apr 2
- NiceGUI: login system
- Mon, Apr 7
- Functional dependencies
- Slides
- Wed, Apr 9
- Functional dependencies
- Slides
- Handout: Armstrong’s axioms, BCNF
- Mon, Apr 14
- BCNF and normalization
- Slides
- Handout: 3NF, 4NF
- Wed, Apr 16
- Class canceled
- Mon, Apr 21
- BCNF and normalization
- Slides
- Wed, Apr 23
- Indices and B-trees
- Homework Homework 4, due Fri, May 2
- Handouts: B-trees B-tree deletion
- Homework Homework 4, due Fri, May 2
- Mon, Apr 28
- Finish B-trees, course evals, work time for projects
- Wed, Apr 30
- Project presentations
The Data 8 Website Dark Mode™ is in beta. You can provide feedback about the website here