Sep 03: MySQL, Constraints, DDL

Learning Objectives

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

• Explain the relational model structure and key constraints.
• Interpret Data Definition Language (DDL) statements in SQL.

Lesson Outline

Lecture Slides [30 min]

• HW1 debrief, introduction to HW2
• Relational Model, Constraints & DDL

Lab Activity [45 min]

• Relational Concepts in MySQL
• Steps 0–2 today, Steps 3–5 Thursday

Your To-Do List

• Read zyBook sections 2.7 – 2.12
  • Ideally before Thursday's class
• Start working on HW2 (due Monday)