***You need to show all your work in .sql files. Please attach a .sql file

Build the data sources defined in E 8.3 of your textbook in MySQL. Please make sure to store the two data sources in two separate databases. These two databases will server as an operational database.

1) Big Z Inc. Order Database (this is an operational database, which is designed to keep track of orders)

2) Human Resources Database (this is an operational database, which contains a single table that keeps track of employee data)

Figure 8.43 Source 1: The Big Z Inc. Orders Database vv

E8.3 Consider the following scenario involving Big Z Inc., an automotive products wholesaler. Big Z Inc. wants to create the analytical database (data warehouse) to analyze its order quantities. The two available data sources, Source 1 and Source 2, are described below. Source 1 The Big Z Inc. Orders Database, shown in Figure 8.43. -08-2 Source 2 The Big Z Inc. Human Resources Department Table, shown in Figure 8.44. The data warehouse has to enable an analysis of order quantities by: .date, including: full date day of week day of month month quarter *year . time *product, including: -pud ID .product name product type Personal use only, do not reproduce. 2020-08-20 product supplier name PAYER Dimension Payer PayerLN Payer Paper Peper Name Gender BirthYear Officer Paper Vehicle TicketTypeTicket Amat Key Key Key Key Figure 8.42 CALENDAR Dimension Calendar Fulbute Bay Day Of Menth Year Week Monik OFFICER Dimension OfficerKey Officer Office Officer Na Rak TICKETTYPE Dimension Ticket Ticket Ticket Ticke Category Violation Fee VEHICLE Dimension Vehiclekey Vehicle Vehicle Vehicle Vehicle Vehicle Vehicle Vehicle Vehicle Model Owner Owner DLN Owner Owner Gender BirthYear TICKETREVENUE Factable Calendar Key 10 Oce DEPOR 10 cxe EX ORDER ORDERCLERK 221882: SCI mal BONILL PL ** Lange 19 ORDERCLERK CUSTOMER C CC Cont 1 Ny C Cs 10 COCO OrdeTime C 3-20300000 OCE 3--20 4:00 4:00 3-530 $30.00 400000 DEPOT a R 14 24 10 PRODUCT 24 PRODUCT DADER DO O MODUCT expec BHO Prod Te pair Shop C MU ST St PL & Prod PL 24 64 PI 040 000 stomers many Commanda SUPPLIER ST K CUSTOMER na 01 SUPPLIER 19 00 00 06 De T . 11 13 IL 4 Depotzip Depot Size OCName DEPOT DepotID ORDERCLERK OCID DEPOT DepotID DepotSize Depotzip OCID OCName ShipsFrom ORDERCLERK 8888 03 Processes 588588 ProductID C3 ProductName Product Type PRODUCT Includes 0 ORDER Quantity OrderID 8888 C3 CustomerType Repair Shop Repair Shop Retailer Order Date ProductID (FK) OrderID (FK) Quantity ORDER OrderID Order Date Order Time CustomerID (FO DepotID (FK) OCID (FK) DEPOT PRODUCT DepotiD DepotSize DepotZip ProductID ProductName ProductType Supplier D D1 Smal 60611 P1 BigGripper Tire ST D2 Large 60660 P2 Traction Wiz Tire ST D3 Large 60611 P3 SureStart Battery BE ORDERCLERK ORDER OCID OCName OrderID CustomerID DepotID OCID Order Date OrderTime OC1 Antonio 01 D1 OC1 1-Jan-2013 9:00:00 AM D1 OC2 OC2 Wesley OC3 Lilly OC3 2-Jan-2013 9:30:00 AM OC1 3-Jan-2013 9:00:00 AM OC2 3-Jan-2013 9:15:00 AM 06 OC3 3-Jan-2013 9:30:00 AM CUSTOMER CustomerID CustomerName C1 Auto Doc C2 Bo's Car Repair C3 JJ Auto Parts PRODUCT ProductID Product Name Product Type SupplierID (K) ORDEREDVIA CustomerZip 60137 60140 60605 Supplies Order Time Submits SUPPLIER Supplier ID Supplier Name CUSTOMER CustomerID CustomerName CustomerType CustomerZip Customer1D CustomerName 30 CUSTOMER CustomerZip CustomerType 2-Jan-2013 9:00:00 AM P2 3333333 P2 SUPPLIER Supplier D SupplierName ST Super Tires BE Batteries Etc ORDEREDVIA ProductID OrderID Quantity P1 4 8 12 4 7 5 8 4 P3 P3 P2 66888888 02 000 03 Supplier D 06 SUPPLIER SupplierName HUMAN RESOURCES DEPARTMENT TABLE (EMPLOYEE DATA) EmployeeID Name Title Education Level OC1 Antonio Order Clerk High School OC2 Wesley Order Clerk College OC3 Lilly Order Clerk College Figure 8.44 Source 2: The Big Z Inc. Human Resources Department Table Year of Hire 2010 2016 2016