Question: Consider the following database schema and example instance: ingredient recipe foodItem stock Hints: - Underlined attribute form the primary key of a relation - The


Consider the following database schema and example instance: ingredient recipe 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. 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)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
