SERVER

Create the Pizza and Toppings tables, including all of their columns, datatypes, and constraints, including the foreign key constraint.
Insert at least four rows into the Pizza table. One of the pizzas should be named "Plain" because it will not have any toppings. Other than this, you select the ids, names, dates, and prices of your choosing (maybe you have some favorite pizzas?).

Insert toppings of your choosing into the topping table. One of the toppings should not be associated with any pizza, that is, the topping should be an "add-on" which is not included in any pizza’s standard toppings. Ensure that the "Plain" pizza has no toppings, and that all other pizzas have at least two toppings. Select all rows in both tables to view what you inserted.

As an exercise, attempt to insert a topping that references a pizza that doesn’t exist. Summarize:
why the insertion failed, and
how you would interpret the error message from your RDBMS so that you know that the error indicates the Pizza reference is invalid.
Fulfill the following request:

List the names and availability date of all pizzas whether or not they have toppings. For the pizzas that have toppings, list the names of the toppings that go with each of those pizzas. Order the list by the availability date, oldest to newest.

There are two kinds of joins that can be used to satisfy this request. Write two queries using each type of join to satisfy this request.
Fulfill the following request:

List the names of all toppings whether or not they go with a pizza, and the names of the pizzas the toppings go with. Order the list by topping name in reverse alphabetical order.