DAILYPURCHASES Purchasell P1 P2 P3 P3 SoldProduct ID PD1 PD2 PD1 PD2 Sold Product Name Sponge Towel Sponge Towel PurchasedBy PatronID PT1 PT2 PT3 PT3 SoldBy SEID SE1 SE2 SE1 SE1 Purchase Date 1/1/2020 1/2/2020 1/3/2020 1/3/2020 Purchase TimeOfDay 9:00 a.m. 9:30 a.m. 9:30 a.m. 9:30 a.m. 8a) Based on the two sources (Source A and Source B) create a star schema whose purpose is to analyze revenue by all dimensions provided by its sources. 8b) Using the data from the two sources (Source A and Source B) show how the tables in the dimensional model would be populated. Amount Charged $10 $15 $10 $15