Aug 26: Relational Model, SQL Basics

Learning Objectives

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

• Describe the structure of the relational model, including constraints.
• Write simple CRUD (Create, Read, Update, Delete) queries in SQL.

Lesson Outline

Lecture Slides [45 min]

• 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

• Read sections 1.2–1.3 of the book
• Get started on HW1 before Thursday