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:
Slide Decks and Lecture Notes:
- Note Set 01 – Getting Started
- Note Set 02 – The Relational Model of Data and Relational Algebra
- Note Set 03 – SQL Part 1
- Note Set 04 – SQL Part 2
- Note Set 05 – MySQL Intro
- Note Set 06 – SQL Part 3
- Note Set 07 – SQL Part 4 – DDL
- Note Set 08 – SQL Part 5 – More DDL
- Note Set 09 – DB Design Part 1
- Note Set 10 – DB Design Part 2
- Note Set 11 – DB Design Part 3
- Note Set 12 – From ER Diagram to Database Diagram
- Note Set 13 – How the Web Works – Delivered via Lecture from White Board
- Note Set 14 – Designing & Implementing a REST API
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: Sunday, Jan 26 @ 11:59 pm to Gradescope
- Regular Due Date: Tuesday, Jan 28 @ 11:59 pm to Gradescope
- HW 02 – SQL #1
- EC Due Date: Sunday, Feb 9 @ 11:59 pm to GradeScope
- Regular Due Date: Tuesda,y Feb 11 @ 11:59 pm to GradeScope
- You will only submit 1 .sql file for this assignment – NO pdf, and no question matching.
- HW 03 – SQL – DDL
- EC Due Date: Sunday, Feb 23 @ 11:59 pm to GradeScope
- Regular Due Date: Tuesday, Feb 25 @ 11:59 pm to GradeScope
- Reference Solution – SQL
- Reference Solution 2
- HW 04 – Design
- EC Due Date: March 23 @ 11:59pm to GradeScope
- Regular Due Date: March 25 @ 11:59 pm to GradeScope
- Reference Solution – Remember, there’s more than one right answer for the design question
- HW 05 – Project
- EC Due Date: April 13 @ 11:59 pm
- Regular Due Date: April 15 @ 11:59pm
- HW 06 – Review Crossword Puzzle
- Submit on time and you get the EC
- Regular Due Date – Thurs April 17 @ 11:59pm
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: 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 2 Requirements Due: Tuesday, April 1, 2025, @ 11:59 pm EST
- Phase 3 Requirements Due: Officially Due Tuesday April 15 @ 11:59 EST; Accepted until Thursday April 17 @ 12 noon EST without penalty.
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
- GitHub’s Documentation for generating and setting up an SSH keypair
- 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
- 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!