Sep 05: Joins, Project Overview

Learning Objectives

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

• Explain the difference between JOIN USING and JOIN ON.
• Write DML that violates primary and foreign key constraints.

Lesson Outline

Lecture Slides [20 min]

• Relational Algebra and Joins

Lab Activity [30 min]

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

Lecture Slides [25 min]

• Group Project Overview
• Sample Project Proposal

Your To-Do List

• Finish reading zyBook sections 2.7 – 2.12
• Finish working on HW2 (now due Tuesday)