Create two tables: customer and "order".
The customer table must contain at least the columns id and name.
The "order" table must contain at least the columns id, customer_id, and order_date.
customer_id must be a foreign key referencing customer(id).
In SQLite you can use double quotes for reserved names: "order".
Hints
-
Hint 1
The foreign key of the order table must point to customer.
So it is better to define customer first.
-
Hint 2
order is a special word in SQL.
In SQLite, wrap it in double quotes.
-
Hint 3
Inside CREATE TABLE "order", add a constraint that links customer_id to customer(id).
It can go after the list of columns.