Welcome to home base for my Fall 2024 section of CS 3200. 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 SELECT Statements
- Note Set 04 – SQL SELECT Statements (Part 2).
- Note Set 05 – SQL SELECT Statements (Part 3)
- Note Set 06 – SQL SELECT Wrap Up and DDL
- Note Set 07 – Advanced DDL **NEW**
- Note Set 08 – Relational DB Design – From Problem to Data Model
- Note Set 09 – Relational DB Design – From Data Model to Implementation
- Note Set 10 – Relational DBs in the Software Stack
- Note Set 11 – Project Kickoff
- Note Set 12 – DB Normalization (If time)
- Note Set 13 – Transaction Processing (If time)
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: Sept 8 @ 11:59 pm to Gradescope
- Regular Due Date: Sept 10 @ 11:59 pm to Gradescope
- HW 01 – Relational Algebra
- EC Due Date: Sept 15 @ 11:59pm to Gradescope
- Regular Due Date: Sept 17 @11:59pm to Gradescope
- HW 02 – SQL #1
- EC Due Date: Sept 29 @ 11:59pm to Gradescope
- Regular Due Date: Oct 1 @ 11:59 to Gradescope
- You will only submit 1 .sql file for this assignment – NO pdf.
- HW 03
- EC Due Date
- Regular Due Date
- HW 04
- EC Due Date
- Regular Due Date
- HW 05
- 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 **NEW**
- 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
- Coming Soon
Course Project:
Information on the course project will be released later in the semester.