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.