Coding task · SQL and MySQL course · Module 9: Indexes and normalization

Add a foreign key

A foreign key is a cross-reference in the catalog - a book scroll points to which shelf holds the description of its author, and the Library makes sure that description exists.

Task

Add to the ksiazki table a foreign key on the autor_id column that points to the id column in the autorzy table. Use ALTER TABLE.