Create a star schema diagram that will enable the wholesale company to analyze the orders of the products The fact table will include: for every instance of a product being ordered - the quantity ordered The star schema will include all dimensions that can be useful for analyzing product orders The only data source available is the wholesalers company operational database

Use data from image below to create star schema diagram:

Wholesale Company ER Diagram (for Operational Database) Sname Sd Region Cid CNetWorth SUPPLER Cname CRname (NoOfEmployees Noof Customers; CUSTOMER CUSTOMERRE Assigned To TotalCustNetW; Supplies Quantity CRid Pid Submit Works With Ptype PRODUCT Ocid Otime Includes Pname ORDER X Processes ORDERCLERK OClocation Storedat Oid Odate OCname WAREHOUSE Wsize Wid Wocation