RENAME and DROP COLUMNs in affiliations

As mentioned in the video, the still empty affiliations table has some flaws. In this exercise, you'll correct them as outlined in the video.

You'll use the following queries:

ALTER TABLE table_name
RENAME COLUMN old_name TO new_name;

ALTER TABLE table_name
DROP COLUMN column_name;