1. Develop a view named SUNNEE_PASTRY_V  that includes the proper joins to produce the following result when all records are selected from the view: 

 

 

Use the proper syntax so that even if the view exists, the create statement will still execute and not error.   

PK SUN CUSTOMER CUST_CODE CUST_BUSINESS_NAME CUST_AREA_CODE CUST_PHONE_NUM +--PLACES--+ SUN_ORDER PK ORDER NUM ORDER DATE PK PK FK CUST_CODE # CONTAINS- PK SUN_ORDER_LINE PK FK ORDER_NUM ORDER_LINE_NUM -APPEARS ON-+- FK PASTRY_CODE QUANTITY ORDERED SUN_RAW_MATERIAL RAW_MATERIAL_CODE RAW_MAT_NAME RAW MAT_QTY_PER_UNIT APPEARS ON- + RAW_MAT_UNIT RAW MAT_PRICE_P_UNIT RAW_MAT_STRG_INSTRUCT SUN_RECIPE_LINE PK FK RECIPE_CODE RECIPE_LINE_NUM PK FK RAW MATERIAL CODE RAW_MAT_AMOUNT RAW_MAT_AMT_UNIT RECIPE INGRED SPEC INST SUPPLIED BY SUN VEND_TO_RAW_MAT FK VENDOR_CODE PK FK RAW_MATERIAL_CODE + -SUPPLIES + PK SUN VENDOR VENDOR_CODE VENDOR_BUSINESS_NAME VENDOR_AREA_CODE VENDOR_PHONE_NUM + CONTAINS- + SUN_PASTRY PK PASTRY_CODE PASTRY_NAME PASTRY_DESC PASTRY_PRICE_PER_UNIT FK RECIPE_CODE PASTRY_BAKED DATE CREATES SUN_RECIPE RECIPE_CODE RECIPE_TITLE RECIPE_DESC RECIPE SPEC INSTRUCT