Welcome to home base for my Spring 2025 section of CS 3200 – Introduction to Databases – at Northeastern. Expand the sections below for additional information.
Quick Finds:
- TA Office Hour Schedule
- Using the Khoury Office Hours App
- Video Tutorials
Slide Decks and Lecture Notes:
- Note Set 01 – Getting Started
- Note Set 02 – The Relational Model of Data and Relational Algebra
Homework Assignments:
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: Jan 12@ 11:59 pm to Gradescope
- Regular Due Date: Jan 14 @ 11:59 pm to Gradescope
- HW 01 – Relational Algebra
- EC Due Date:
- Regular Due Date:
- HW 02 – SQL #1
- EC Due Date:
- Regular Due Date:
- You will only submit 1 .sql file for this assignment – NO pdf.
- HW 03 – SQL #2 – 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 –
- EC Due Date –
- Regular Due Date –
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
- 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.
Course Project:
IMPORTANT: There are a lot of details that you’ll need to consider and follow as you complete the project. Please (please. please) read all of the instructions closely and fully!
- Fall 2024 Project Overview
- Phase 1 Requirements Due: Friday, Nov 8, 2024, @11:59pm EST (submission directions in template linked below)
- Phase 2 Requirements Due: Tuesday, Nov 19, 2024, @ 11:59 pm (directions in the template below)
- Phase 3 Requirements. Due Dec 4 @ 11:59 pm
Extra Support:
- 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
gitfrom 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
- If you want to use
- 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!