myQSL

Q.1) (15 points) Write 2 queries to create copies of the addresses and orders tables. Name them address_copy and order_copy To allow for repeated clean executions of your script, precede the CREATE TABLE statements with DROP TABLE statements. To ensure that the script will run cleanly even when the tables have not yet been created, use the IF EXISTS feature of the DROP statement. my guitar_shop Tables addresses | Columns address id customer_id linel line2 city state zip_code phone disabled Indexes PRIMARY addresses_fk_customers Foreign Keys addresses_fk_customers addresses fk_customens > Triggers administrators admin_id email_address password first_name last_name ep Indexes PRIMARY Foreign Keys Triggers | categories Columns category_id category_name ep Indexes PRIMARY PRIMARY category-name Foreign Keys Triggers | | customers C] columns customer_id email address password first name last_name shipping-addressid billing-address-d - E Indexes PRIMARY emailaddress - Foreign Keys Triggers -order-items | order-items -Columns item_id orderid - product_id item-price discountamount - quantity Indexes PRIMARY items fk orders items_fk_products Foreign Keys items.fk-orders Triggers Columns items_fk_produds orders order-id order_id customer_id order date ship-amount tax amount ship_date ship-address-id card_type card_number card-expires billing address_id ep Indexes PRIMARY ordersfkcustomers - - VE Foreign Keys orders_fk_customers ] Triggers products [05] Columns o columns product_id category_id product-code product-name description list-price discount-percent dateadded - ep Indexes PRIMARY product-code products-fk. categories VE Foreign Keys products_fk_categories Triggers Views Stored Procedures Functions