Link Search Menu Expand Document

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.

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
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
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