Case 2 Star Schema (23 points) Convert the relational schema of Global Bike, Inc. below to a star schema based on the following assumptions. Be sure to appropriately label and connect the tables in your schema. You may create the relational schema in other software and copy into this answer sheet. Global Bike Inc. wants to create an analytical database (data warehouse) to analyze its sales by revenue, cost of goods sold, and quantities sold, and would like to be able to conduct analysis for each transaction. No additional detail is needed. The data warehouse should support an analysis of revenue, costs and quantity by: R Date (include typical columns) = Material (include material related columns below) - Customer (include customer related columns below) = Sales Organization (include sales org columns below) B Distribution Channel (include distribution channel below) Irl..-llhn_- MatCroupTeat