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 foodItemstock Hints: - Underlined attribute form the primary key of a relation

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!