Add foreign keys to the "affiliations" table
At the moment, the affiliations table has the structure {firstname, lastname, function, organization}, as you can see in the preview at the bottom right. In the next three exercises, you're going to turn this table into the form {professor_id, organization_id, function}, with professor_id and organization_id being foreign keys that point to the respective tables.
You're going to transform the affiliations table in-place, i.e., without creating a temporary table to cache your intermediate results.
This exercise is part of the course
Introduction to Relational Databases in SQL
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Add a professor_id column
___ ___ ___
___ COLUMN ___ ___ REFERENCES ___ (___);