Design Better Tables

Let’s improve your table-building skills. In this lesson, you’ll add constraints and smarter data types to make your data more reliable and meaningful.

Goal

You’ll aim to:

• Choose better data types.

• Add constraints like PRIMARY KEY, NOT NULL, and DEFAULT.

Smarter table design

Smarter table design ensures your data is clean, accurate, and easier to work with. By using the right data types and constraints, you prevent bad data from entering your database. Here’s a better way to define your students table: