Jan 22: 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
• Be sure to submit at the end of class; resubmit by midnight if you want to clean up anything

Your To-Do List

• Read sections 1.2–1.3 of the book
• Have a look at HW1