CS 3200 – Summer 2 2025

Important Info

• Syllabus
• TA Office Hour Schedule Coming Soon
• Fontenot Office Hours
  • Tu & Wed 8:45 – 9:45 (before class) in classroom (Mugar 201)
  • 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 – Welcome
• Note Set 02 – The Relational Model of Data & Relational Algebra
• Note Set 03 – SQL Part 1
• Note Set 05 – SQL Part 2
• Note Set 06 – SQL Part 3
  • Challenge Problem
• Note Set 07 – SQL Practice Problems (below)

Exam Prep

Exam 1

• Coming soon!

Exam 2

• Coming Soon!

FonteNotes

• Relational Algebra Extra Notes
• YouTube Playlist of Relational Algebra Examples from lecture Notes
  • These are walk throughs 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:
  • Regular Due Date:
• HW 02 – Relational Algebra & SQL
  • EC Due Date:
  • Regular Due Date:
• HW03 – More SQL
  • EC Due Date:
  • Regular Due Date:
• HW04 – DDL & DML
  • EC Due Date:
  • Regular Due Date:
• HW05 – ER Modeling
  • EC Due Date:
  • Regular Due Date:
• HW06 – The Hardest Homework Assignment Ever
  • EC Due Date:
  • Regular Due Date:

Project Info

• Project Overview and Phase 1 Handout
  • Phase 1 Submission Template
• Phase 2 Handout – Design the Database
  • Phase 2 Submission Template
• Phase 3 Handout – Building the App
  • Phase 3 Submission Template

Project Development Tips, Tutorials, and Documentation

• Fontenot’s Video Tutorials for Summer 24 Project
• 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!