Aug 27: Relational Model, DML

Learning Objectives

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

• Explain the relational model structure and relational operations.
• Write SELECT, INSERT, UPDATE, and DELETE statements in SQL.

Lesson Outline

Lecture Slides [20 min]

• Introduction to HW 1
• Python Refresher

Lecture Slides [20 min]

• Relational Model and DML
• Based on Chapter 2 from the zyBook

Lab Activity [35 min]

• SQLite (DB Browser)
• Parts 1–3 last week, Parts 4–7 today

Your To-Do List

• Read zyBook sections 2.1 – 2.6
  • Ideally before Thursday's class
• Start working on HW 1 (due Monday)