CS 3200 – Database Design – Spring 2023

Important Info

• Syllabus
• Join my Slack Org: Click > here <.
• If you can’t see the course on Piazza, please DM Fontenot.
• Coming Soon:
  • TA Office Hours Info

Lecture Notes

• Introduction
• The Relational Model
• Relational Algebra (Solutions for Part 1)
  • 9:15 Section Relational Algebra Solutions from Jan 19
  • 10:30 Section Relational Algebra Solutions from Jan 19
  • YouTube Playlist with some Rel Alg Problem examples I made
• SQL DQL
• Adding Northwind to DataGrip
• SQL DML
• SQL DDL
• ER Modeling
• ER Model -> Relations
• … and more to come …

Homework Assignments

• HW 01 – Introduction and DataGrip Setup
  • EC Due Date: Jan 15 @ 11:59pm to GradeScope
  • Regular Due Date:  Jan 17 @ 11:59pm to GradeScope
• HW 02 – Relational Model and Relational Algebra
  • EC due Date: Jan 29 @ 11:59 to GradeScope
  • Regular Due Date: Jan 31 @ 11:59 to GradeScope
• HW 03
• HW 04
• HW 05
• HW 06

Semester Project

… More info coming soon …