CS 3200 – Summer 2 2025

Important Info

• Syllabus
• TA Office Hour Schedule Coming Soon
• Fontenot Office Hours
  • Tuesday & Thursday 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
  • Extra Relational Algebra Practice — Solutions
• Note Set 03 – SQL Part 1
  • 03b – Setting up Northwind DB
• Note Set 04 – SQL Part 2
• Note Set 05 – SQL Part 3
• Note Set 06 – HuskyGram Queries — Sample Solutions
  • HuskyGram Sub Query Practice
• Note Set 07 – SQL Part 4 (SELECT Wrap Up) END OF MATERIAL FOR EXAM 1!
• Note Set 08 – SQL DDL Part 1
• Note Set 09 – SQL DDL Part 2
• Note Set 10 – SQL DDL Part 3
• Note Set 11 – Database Design Part 1
• Note Set 12 – Database Design Part 2
• Note Set 13 – Database Design Part 3 — HuskyWorks Solution
• Note Set 14 – ER Diagram –> Relational DB Diagram
• Note Set 15 – How the Web Works
• Note Set 16 – Designing and Implementing a REST API

Exam Prep

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 SQL questions used the Northwind Data Model.
  • Material coverage might be slightly different.
  • Use this as a sample for types of questions, structure, etc.
• Exam 1 SQL Queries will use the Chinook Data Model

Exam 2

• Spring 2024 Exam 2 – Sample Solutions
• Cheat sheet requirements are exactly the same as for Exam 1.
• Material will officially cover everything since Exam 1 to the end of Note Set 14.

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: Sunday July 6 @ 11:59 pm
  • Regular Due Date: Monday July 7 @ 11:59 pm
  • HW 01 – Solutions
• HW 02 – Relational Algebra & SQL
  • EC Due Date: July 13 @ 11:59 pm
  • Regular Due Date: July 14 @ 11:59 pm
• HW03 – Exam Cheat Sheet
  • Submitted with Exam
• HW04 – SQL DDL
  • EC Due Date: July 27 @ 11:59pm to GradeScope
  • Regular Due Date: July 28 @ 11:59pm to GradeScope
• HW05 – ER Modeling
  • EC Due Date: Aug 3 @ 11:59 pm to GradeScope
  • Regular Due Date: Aug 4 @ 11:59 pm to GradeScope
• HW06 – Review with Crossword
  • EC Due Date: Wednesday, August 13 @ 11:59 pm to GradeScope
  • Regular Due Date: Thursday Aug 14 @ 11:59 pm to GradeSceop

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

• Streamlit Tutorial: Go to khouryodyssey.org, log in, set up your profile and check out the Groups tab. You should be in a group for this course. In it, there should be a Streamlit Tutorial droplet (a learning module).
• Sample Streamlit Apps Repository

The Project Template Repository

• https://github.com/NEU-CS3200/25su2-Project-Template

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!