CS 3200 – Summer B 2026

Important Info

• Syllabus
• Fontenot Office Hours
  • Mon & Wed 11:30 – 12:30 pm (after class) in Classroom
  • If those times don’t work for you, feel free to send me a Slack message and we can find some alternatives that work better.

Lecture Notes

• Note Set 01 – Getting Started
• Note Set 02 – The Relational Model and Relational Algebra (slides with example solutions)
  • Note Set 02b – Relational Algebra Practice – Northwind (Solutions given in class)
  • Note Set 02c – Relational Algebra Practice – Classic Models (Solutions)
• Note Set 03 – Introduction to SQL and the SELECT statement (slides with example solutions)
  • Note Set 03b – Setting up NorthWind in MySQL via DataGrip
  • Updated NorthWind Database Script File
• Note Set 04 – SQL SELECT Part 2 (slides with example solutions)
• Note Set 05 – SQL SELECT Part 3
• SELECT Practice: HuskyGram Queries

• Note Set 06 – Intro to DDL
• Note Set 07 – DDL/DML Part 2
• Note Set 08 – Database Design Part 1
• Note Set 09 – Database Design Part 2
• Note Set 10 – Database Design Part 3
• Note Set 11 – From ER Diagrams to Relational Database

• Note Set 12 – How the Web Works

Exam Prep

Prep Materials for Exam 1

• Cheat Sheet Guidelines
• Exam 1 Material will cover up through the end of SELECT statements.
• SAMPLE EXAM: Spring 2024 Exam 1. (Solutions to Sample Exam)
  • The sample exam is NOT intended to represent the range of content for Exam 1!
  • Use this as a sample for question types, structure, etc.
• Extra Relational Algebra Examples
  • Spring 26 HW 1 w/ solutions

Prep Materials for Exam 2

• The Exam will cover everything after SQL SELECT statements (Anything after NoteSet 5)
• Sample Exam 2
• Another Sample Exam 2
• Remember: Sample exams aren’t meant to be a study guide. Use them as a tool to see the types of questions you might expect.
• Cheat Sheet Guidelines are the same as they were for Exam 1. See Slide linked above.

FonteNotes

• Relational Algebra Extra Notes
• YouTube Playlist of Relational Algebra Examples from lecture notes
  • These are walkthroughs of the examples from Slide Deck 03 on Relational Algebra that I made last year.  The examples are the same.
• Relational Algebra Joins Extra Notes
• Using Notion to Write RA Expressions in LaTeX

Homework Assignments

• HW 01 – Getting Started and Relational Algebra
  • EC Due Date: Sunday, July 5, 2026 @ 11:59 pm EST, uploaded to GradeScope
  • Regular Due Date: Monday, July 6, 2026 @ 11:59 pm EST, uploaded to GradeScope
  • HW 01 Solutions
• HW 02 – RA and SQL SELECTs
  • EC Due Date: Saturday, July 11, 2026 @ 11:59 pm EST, uploaded to GradeScope
  • Regular Due Date: Monday, July 13, 2026 @ 11:59 pm EST, uploaded to GradeScope
• HW03 – Study for Exam 1 & Make a Cheat Sheet – Submit with Exam! 😇
  • Due when you take the exam 🙂
• HW04 – DDL
  • EC Due Date: Sat July 25 @ 11:59 pm
  • Regular Due Date: Monday July 27 @ 11:59 pm
• HW05 – DB Design
  • EC Due Date: Sun Aug 2 @ 11:59 PM EST
  • Regular Due Date: Tuesday Aug 4 @ 11:59 PM EST
• HW06 –
  • EC Due Date:
  • Regular Due Date:

Project Info

• Project Overview
• Phase 1 Requirements
  • Phase 1 Submission Template
• Phase 2 Requirements
  • Phase 2 Submission Template
• Phase 3 Requirements
  • Submission Template Forthcoming

Project Development Tips, Tutorials, and Documentation

• Fontenot’s Video Tutorials for Summer 24 Project
• Low Fidelity Wireframing Guide/Examples
  • I made this during the recent Dialogue in Belgium, and forgot I had it. Hopefully, this is helpful to you all.
• Git and GitHub – Setting up SSH Keys
  • If you want to use git from the command line to interact with GitHub, you need to set up an SSH key pair (the pair consists of a private key and a public key), and then upload the PUBLIC key to GitHub.
  • GitHub’s Documentation for generating and setting up an SSH keypair
    • Make sure you select the correct platform for your laptop using the tabs near the top of the page.
  • YouTube Tutorials:
    • From The Common Coder: How to Set Up an SSH Key for GitHub in 2024 (for Mac and Windows)
    • From Codemify: How to setup SSH for GitHub repository
• Python for Beginners
  • TheNewBoston’s video: Python Tutorial in 30 Minutes
  • If you want a slightly more comprehensive introduction, check out Python Crash Course Playlist from Net Ninja (don’t need to worry about about video #8, for the project at least)
• Flask Framework (for building REST API)
  • In Flask, you can write full-featured web apps, but we will only be using the REST API features of the library.
  • Dave Gray’s video: Python REST API Tutorial for Beginners
  • Tech With Tim’s video: Python REST API Tutorial (you could stop around the 45:00 before he starts talking about databases)
    • This video is a little older, but still very relevant!