SQL

Consider the following database schema and example instance: ingredient recipe fooditem stock Notes: - 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 foodttem. Q1) Write a relational algebra expression that returns the 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. Answer: Q2) Write a relational algebra expression that returns food items that are sold at "Aldi" and their price. Answer: Q3) Write a relational algebra expression that returns food items (item) that are of type "Wheat product" or of type "Meat" and have at least 20 calories per ounce (attribute calories). Answer: Q4) Write a relational algebra expression that returns the items and their price for all items of type "Wheat product" sold at Aldi. Answer: Q5) Write a relational algebra expression that returns the names of all recipes that contain meat products (food items of type "Meat")