Sep 01: Relational Model

Learning Objectives

After today's class, you should be able to:

• Describe the structure of the relational model, including keys and constraints.
• Write simple SELECT statements that filter and sort rows.

Lesson Outline

Lecture Slides [45 min]

• Debrief Week 1 reading (tutor mode)
• Relational Model and SQL Basics

Lab Activity [30 min]

• SQLite (DB Browser) Parts 5–7
• Complete the lab and submit your sqlite-lab.sql on Gradescope
• This file should contain your notes and responses to all the exercises

Your To-Do List

• Submit the Week 2 reading ← due Wednesday
• Get started on HW1