Answer Happy

1. Create the following tables in a database called "holiday" 0 FAMILY_MEMBER (FAMILY MEMBER_ID, FIRST_NAME, LAST_NAME, TITLE) • RECIPE (RECIPE ID, RECIPE_NAME, FAMILY_MEMBER_ID) o Note: All "ID" fields are int, and the rest of the fields are char(35) 2. RECIPE table details: o Insert at least 3 recipes that are traditions in your family (if you don't celebrate, any recipes will do) o The "family member_id" will represent the person who traditionally prepares the recipe 3. FAMILY_MEMBER table details: o Insert at least 3 different family members (or any made-up names) who prepare recipes at your home. o The "title" field is their relationship (e.g., grandma, uncle, dad, sister, etc.). 4. Create a join that gives an output that looks like the output below o Be sure that the output has your own unique data and is thus DIFFERENT from the output data below o Be sure that the output has the EXACT same field names as shown in the output below + | RECIPE | COOK | Turkey Brian Stone (Brother) | Oreo Pie | Tiffany Stone (Wife) | Deviled Eggs | Linda Stone (Mom) | Green Stuff | Jeff Stone (Self) +-