CS 3200 – Summer 2 2024

Important Info

• Syllabus
• TA Office Hour Schedule
• Fontenot Office Hours
  • Tu & Thur 10:30 – 11:30 (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

• Lecture Notes 01 – Welcome
• Lecture Notes 02 – The Relational Model
• Lecture Notes 03 – Relational Algebra (with Solutions to RA problems)
  • Lecture Notes 03b – Relational Algebra Practice
• Lecture Notes 04 – SQL Part 1
  • Lecture Notes 04b – Docker & MySQL
• Lecture Notes 05 – SQL Part 2
• Lecture Notes 06 – SQL Part 3
  • Challenge Problem
• 07 – SQL Practice Problems (below)
• 08 – DDL
• 09 – MySQL SQL
• 10 – HuskyGram Schema
• 11 – Generating Mock Data
• 12 – Database Design – Part 1
• 13 – Database Design – Part 2
• 14 – Database Design – Part 3
• 14b – HuskyWorks ER Model Example
• 15 – ERD to Database
• 16 – How the Internet Works
• 17 – Intro to Streamlit
• 18 – REST APIs

Exam Prep

Exam 1

• SQL Practice Problems – Huskygram
  • SQL Practice Problem Solutions – Huskygram
• Exam 01 Cheat Sheet Guidelines
• Previous Exam 01
• Exam 01 Database Diagram

Exam 2

• Spring 2024 Exam 2
  • Note – The material coverage might be slightly different between the Spring 2024 exam 2 and the one you will take on Thursday.
  • Sample Solutions
• Cheat sheet requirements are exactly the same as for Exam 1.
  • Any cheat sheets over the allowed size may result in a 0 (zero) on the exam.
• Material will cover everything from Slide Set 08 to Slide Set 15 (inclusive)

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
  • EC Due Date: July 7 @ 11:59 pm to GradeScope
  • Regular Due Date: July 8 @ 11:59 pm to GradeScope
• HW 02 – Relational Algebra
  • EC Due Date: July 14 @ 11:59 pm to GradeScope
  • Regular Due Date: July 15 @ 11:59 pm to GradeScope
  • HW 02 Solutions
• HW03 – SQL Select
  • EC Due Date: July 21 @ 11:59 pm to GradeScope
  • Regular Due Date: July 22 @11:59 pm to GradeScope
• HW04 – DDL & DML
  • EC Due Date: July 28 @ 11:59 pm to GradeScope
  • Regular Due Date: July 29 @ 11:59 to Gradescope
  • Question 2 DDL Solution
• HW05 – ER Modeling
  • EC Due Date: Aug 4 @ 11:59 pm to GradeScope
  • Regular Due Date: Aug 5 @ 11:59 to GradeScope
  • ERD solution for the Hospital Problem
• HW06 – The Hardest Homework Assignment Ever
  • EC Due Date: Aug 13 @ 11:59 pm to GradeScope
  • Regular Due Date: Aug 14 @ 11:59 pm to GradeScope

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 (more to come as well)
• 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!