Consider the following database schema and example instance: ingredient recine fooditem stock Hints: - Underlined attribute form the primary key of a relation - The attribute recipe of relation ingredient is a foreign key to relation recipe. The attribute foodItem of relation ingredient is a foreign key to relation foodItem. - The attribute fooditem of relation stock is a foreign key to relation fooditem. a) [20 points] Write complete DDL statements to create these four tables, you must include in your create statements the appropriate actions (reject, cascade, set to NULL, set to default) for each referential integrity constraint. b) [5 points] Write an SQL statement that would delete each Italian recipe. c) [25 points] Write each of the following queries in SQL: 1) List all food items that are sold at "Aldi" and their price. 2) List all items and their price for all items of type "Wheat product" sold at Aldi. 3) List all food items required to cook the recipe "Pasta and Meatballs". For each such food item return the item paired with the number of ounces required by the recipe. 4) List all recipes that contain both "Onions" and "Cheese". 5) List all food items (item) that are of type "Wheat product" or of type "Meat" and have at least 20 calories per ounce (attribute calories)