Merge - write merge script to correct the missing calorie


Problem

1. Allergen tags- Implement allergen tags with whichever SQL mechanism you prefer.

Allergens In Recipes: Add tag at beginning of each line below to each of the recipes listed. lactose - Avocado Toast (butter), Cheese and Crackers peanuts - PB & J Bites gluten - Cheese and Crackers, PB & J Bites, Avocado Toast

2. Merge - Write MERGE script to correct the missing calorie count information. Use the cals.txt document provided.

Calories per Serving per Recipe ------------------------------------ Cheese & Crackers - serving size, 3 crackers with topping - 150 kcal (1 cubic inch cheddar = 69 kcal, would cover 2 crackers; each cracker about 16 kcal) PB & J Bites - serving size, 1/2 sandwich - 163 kcal Avocado Toast - serving size, 1/2 slice - 350 kcal.

Request for Solution File

Ask an Expert for Answer!!
PL-SQL Programming: Merge - write merge script to correct the missing calorie
Reference No:- TGS02699352

Expected delivery within 24 Hours