Warning! It seems that you are using Dodona within another webpage, so not everything may work properly. Let your teacher know so that he can solve the problem by adjusting a setting in the learning environment. In the meantime, you can click this link to open Dodona in a new window.
Warning! The page was not fully loaded, probably because of a network issue. It could be that not all functionalities work as expected. Please try reloading the page.
Sql exercise
Tabel bestelling aanmaken
Sign in to hand in your solution and get feedback.
CREATE TABLE bestelling (
bestelcode INTEGER PRIMARY KEY AUTOINCREMENT,
klantnummer INTEGER,
bezorgernummer INTEGER,
bestel_datum TEXT,
bezorg_tijd TEXT
);
-- Verwijder deze regel niet, die controleert of je foreign key correct is.
SELECT "table", "from", "to" FROM pragma_foreign_key_list('bestelling');