CS 3200 – Database Design – Fall 2023

Important Info:

• Syllabus
• Join my Slack and then join channel #23f-cs3200
• Make sure you have been added to Piazza.  DM Dr. Fontenot on Slack if you can’t access it.
• TA Office Hour Schedule

Lecture Notes:

• Lecture 01 Notes
• Lecture 02 Notes – The Relational Model
• Lecture 03 Notes – Relational Algebra
• Lecture 04 Notes – SQL Part 1
  • Setting Up Northwind SQLite DB in DataGrip
  • Challenge Problem Solution
• Lecture 05 Notes – SQL Part 2
• Lecture 06 Notes – SQL DDL
• Lecture 07 Notes – Getting Started with Docker and MySQL
• Lecture 08 Notes – MySQL
• Lecture 09 Notes – Advanced SQL
• Lecture 10 Notes – Auto Increment and Indexing
• Lecture 11 Notes – Design I
• Lecture 12 Notes – Design II
• Lecture 13 Notes – Design III
• Lecture 14 Notes – ER -> Relational Mapping
  • Lecture 14 with Diagrams
• Lecture 15 Notes – Databases in Modern Apps (and Your Project)
• Lecture 16 Notes – Designing & Implementing a REST API
• Lecture 17 Notes – Data Data Data

Exam 1 Prep:

• Schema Diagram that will be used for Exam 1
• Exam 1 Review Slides
• Cheat Sheet Rules
• Sample Exam 1
  • Version without answers

Exam 2 Prep:

• Exam 2 Review Slides
• Exam 2 Sample Questions

FonteNotes:

• Relational Algebra Extra Notes
• YouTube Playlist of Relational Algebra Examples from lecture Notes
  • These are walk throughs of the examples from Slide Deck 03 on Relational Algebra that I made last year.  The examples are the same.
• Relational Algebra Joins Extra Notes

Homework Assignments:

• Homework 01
  • Early EC Deadline: Sunday September 10, 2023 @ 11:59pm
  • Regular Deadline: Tuesday September 12, 2023 @ 11:59pm
• Homework 02 – Relational Algebra
  • Submit to GradeScope
  • Early EC Deadline: September 24, 2023 @ 11:59pm
  • Regular Deadline: September 26, 2023 @ 11:59pm
  • LaTeX Source for the Assignment is posted on Slack (provided graciously by James Sweeney)
    • Note: you may use this as a starting point for composing your solutions.  But don’t feel like you need to learn LaTeX for HW02. This is just 1 option.
• Homework 03 – SQL
  • Submit to GradeScope
  • Early EC Deadline: Oct 8 @ 11:59 pm
  • Regular Deadline: Oct 10 @ 11:59pm
• Homework 04 – SQL DDL
  • Submit to GradeScope
  • Early ED Deadline: Oct 22 @ 11:59 pm
  • Regular Deadline: Oct 24 @ 11:59 pm
• Homework 05 – ER Modeling and AppSmith
  • Submit to GradeScope
  • Early EC Deadline: Nov 12 @ 11:59pm
  • Regular Deadline: Nov 14 @ 11:59pm
• Homework 06 – REST Matrix
  • Regular Deadline: Dec 4 @ 11:59 pm
  • EC Deadline: Dec 2 @ 11:59pm
  • Submit to GradeScope

Course Project:

NOTE: You may not use your 2 day extensions on submissions for the course project!

• High Level Project Overview
• Phase 1 Submission Instructions and Document – Project Overview, Features, and Personas
  • Due Tuesday Nov 7, 2023 @ 11:59pm (directions in document)
• Phase 2 – Data Modeling and Implementation
  • Phase 2 Template
  • Due Tuesday Nov 21, 2023 @ 11:59 pm Sunday Nov 26 @ 11:59 uploaded to Gradescope
  • Note: to submit your DB Creation/Bootstrap file (the actual SQL), you can copy and paste it into the Phase 2 document (at the end) OR add it as a PDF to the end of your Phase 2 Design Document.
• Phase 3 – Building API, UI Creation, Putting it All Together
  • Phase 3 Template
  • Submit to GradeScope
  • Due Wednesday Dec 6, 2023 @11:59 pm (NO EXTENSIONS)

Extra Notes for Project:

• Docker Compose and Docker Command Cheat Sheet
• YouTube Playlist of Videos  on the entire process for the project (from Spring 23, but basically the same setup)