CS3200 – Intro to Databases – Fall 2025

• Note Set 01 – Introductions and Course Overview
• Note Set 02 – The Relational Model and Relational Algebra
• Note Set 03 – Introduction to SQL, MySQL, and SELECT Part I
• Note Set 04 – SELECT Part II
• Note Set 05 – SELECT Part III
• Note Set 06 – DDL Part I
• Note Set 07 – DDL Part II
• Note Set 08 – Designing a Database Part I
• Note Set 09 – Designing a Database Part II
• Note Set 10 – Designing a Database Part III
• Note Set 11 – ER Modeling –> Relational Database Model

Remember to submit all HW assignments to GradeScope, and when appropriate, MATCH THE QUESTIONS TO THE PROPER PAGE IN YOUR PDF!

• Mini HW 00 – Handout
  • EC Due Date: Sept 7 @ 11:59 pm EST to Gradescope
  • Regular Due Date: Sept 9 @ 11:59 pm EST to Gradescope
• HW 01 – Relational Algebra
  • EC Due Date: Sunday Sept 14 @ 11:59pm EST
  • Regular Due Date: Tuesday Sept 16 @ 11:59pm EST
• HW 02 – SQL #1
  • EC Due Date:
  • Regular Due Date:
• HW 03 – SQL – DDL
  • EC Due Date:
  • Regular Due Date:
• HW 04 – Design
  • EC Due Date:
  • Regular Due Date:
• HW 05 – Project
  • EC Due Date:
  • Regular Due Date:
• HW 06 – Review Crossword Puzzle
  • Submit on time and you get the EC
  • Regular Due Date –

• 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
    • Material coverage might be slightly different.
    • Use this as a sample for types of questions, structure, etc.
    • Solutions will be posted ASAP
  • Exam 1 SQL Queries will use the Chinook Data Model
• Prep Materials for 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.
  • You should know how to interpret Docker Compose files as well as write simple GET routes in Flask that retrieve information from a database.

IMPORTANT: You’ll need to consider and follow many details as you complete the project. Please (please please) read all of the instructions closely and fully!

Project Template GitHub Repository

• Spring 2025 Project Overview
• Phase 1 Requirements Due: Tuesday, March 25, 2025, @ 11:59pm EST (submission directions in template linked below)
  • Phase 1 Submission Template
• Phase 2 Requirements Due: Tuesday, April 1, 2025, @ 11:59 pm EST
  • Phase 2 Submission Template
• Phase 3 Requirements Due: Officially Due Tuesday April 15 @ 11:59 EST; Accepted until Thursday April 17 @ 12 noon EST without penalty.
  • Phase 3 Submission Template

Extra Support:

• Tutorial Videos for the Project Template Repo + Coding
• Git and GitHub –
  • As a team, you’ll need to use Git and GitHub to collaborate on code. You can use a graphical tool such as GitHub desktop or the VS Code git integration. If you want to use the command line, you’ll need to set up SSH Keys
    • 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!