1. Learn
    2. /
  2. Courses
    3. /
  3. Introduction to Relational Databases in SQL

Exercise

Add a SERIAL surrogate key

Since there's no single column candidate key in professors (only a composite key candidate consisting of firstname, lastname), you'll add a new column id to that table.

This column has a special data type serial, which turns the column into an auto-incrementing number. This means that, whenever you add a new professor to the table, it will automatically get an id that does not exist yet in the table: a perfect primary key!

Instructions 1/3

undefined XP
    1
    2
    3

Add a new column id with data type serial to the professors table.