Following are given two diagrams one is ER and 2^nd one is star schema of the same ER diagram.your task is to write script in sql for ETL(Extract,Transform,Load) to transfer data from ER to star schema

orders (sales) order_id customer_id order_status - staffs (sales) 9 staff_id first_name last_name email phone active store_id manager_id order_items (sale order_id item_id product_id quantity order_date required_date shipped_date list_price ko discount store_id staff_id stocks (productio store_id 8 product_id quantity customers (sales) Y customer_id first_name last_name phone email stores (sales) store_id store_name street phone city email state street zip code city state zip_code products (production) 8 product_id product_name brand_id category_id model_year brands (production brand_id brand_name list_price categories (production) 7 category_id category_name Staff (salu) first name Lastnom Order items (we & order id item_id product_id quantity email phone active tore-ld manager-id list price discount Order (sales) onder id customer_id oudu status Ordu-date required - dele shipped date slon Lid Customer (sales) wistonen id ourt last_name stoxes (salu) ston_id On nang phone immil stut city utate zip-code phone email swt lity Italic Categories (Production) locategory.id Centegay-name , Stocks (production) Ltorid product_id quanlity 0 Products Production) Product_id product name branch TL category.id modil you brands (Production) lobrane id list-price brand none orders (sales) order_id customer_id order_status - staffs (sales) 9 staff_id first_name last_name email phone active store_id manager_id order_items (sale order_id item_id product_id quantity order_date required_date shipped_date list_price ko discount store_id staff_id stocks (productio store_id 8 product_id quantity customers (sales) Y customer_id first_name last_name phone email stores (sales) store_id store_name street phone city email state street zip code city state zip_code products (production) 8 product_id product_name brand_id category_id model_year brands (production brand_id brand_name list_price categories (production) 7 category_id category_name Staff (salu) first name Lastnom Order items (we & order id item_id product_id quantity email phone active tore-ld manager-id list price discount Order (sales) onder id customer_id oudu status Ordu-date required - dele shipped date slon Lid Customer (sales) wistonen id ourt last_name stoxes (salu) ston_id On nang phone immil stut city utate zip-code phone email swt lity Italic Categories (Production) locategory.id Centegay-name , Stocks (production) Ltorid product_id quanlity 0 Products Production) Product_id product name branch TL category.id modil you brands (Production) lobrane id list-price brand none