Feb 13: Creating Tables

Learning Objectives

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

• Explain the syntax of the CREATE TABLE statement.
• Use MySQL Workbench to create a relational database.

Lesson Outline

HW3 Debrief [10 min]

• See the Sample Solution on Canvas

Lecture Slides [20 min]

• SQL DDL - Data Definition Language

Lab Activity [30 min]

• Forward Engineering with MySQL Workbench

Workbench Tour [15 min]

• Exploring what's in the menus
• Running queries in the SQL tab
  • Example Queries from SQLite lab

Your To-Do List

• Start reading zyBook sections 2.8 – 2.12 and 11.4 – 11.6
• Start working on Homework 4 (due Monday)
  • To be completed individually this time