SQLIntermediate

Foreign key

PreviousProblem 29 of 40Next

Create two tables:

departments with dept_id INTEGER PRIMARY KEY and dept_name VARCHAR NOT NULL
staff with staff_id INTEGER PRIMARY KEY, name VARCHAR and dept_id INTEGER that must refer to an existing department

This question starts with an empty database.

Hints(0/2)

Each hint gives a little more help. Try on your own first.

Unlocks after you solve it or after 3 submissions

SQLCtrl + Enter to run

Run your code to see the output here.