CS3200 – Intro to Databases – Fall 2024

• Note Set 01 – Getting Started
• Note Set 02 – The Relational Model of Data and Relational Algebra
  • Notes with Problem Solutions Included
  • Extra Notes on Relational Algebra
  • On Relational Algebra Joins
  • Tips on Using Notion to write LaTeX equations for Rel Alg
  • Playlist of Some Rel Alg Problems
  • Extra Example Relational Algebra Queries with Chinook **New**
• Note Set 03 – SQL SELECT Statements
  • Note Set 03b – MySQL and Docker
• Note Set 05 – SQL INSERT, UPDATE, DELETE
• Note Set 06 – SQL CREATE
• Note Set 07 – Advanced SQL
• 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)

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
  • EC Due Date
  • Regular Due Date
• 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

• Prep Materials for Exam 1
  • Coming Soon
• Prep Materials for Exam 2
  • Coming Soon

Information on the course project will be released later in the semester.