CUSTOM SPA DATA WAREHOUSE based on two sources (Source A and Source B) Source A) CUSTOM SPA DAILY VISITS DATABASE: Custom Spa Daily Visits Database ER Diagram PatronlD Patron Name PatronZip ProcedurelD ProcedureName AmountCharged VisitID Serves PATRON PROCEDURE I Includes VISIT VisitTimeOfDay Facititates + SPAEMPLOYEE SEYearOfHire VisitDate SEID SEname Custom Spa Daily Visits Database Relational Schema PROCEDURE ProcedureID ProcedureName VISIT VisitID PatronID (FK) SEID (FK) VisitDate VisitTimeOfDay PATRON PatronID PatronName PatronZip Includes VisitID (FK) ProcedurelD (FK) AmountCharged SPAEMPLOYEE SEID SEname SEYearOfHire Custom Spa Daily Visits Database Data PATRON PatronID PT1 PT2 PT3 PT4 PatronName Daisy Elena Nelly Marcia PatronZip 60611 60650 60611 60650 VISIT Visit ID V1 V2 Patronid PT1 PT2 PT3 PT1 SEID SE1 SE2 SE1 SE2 SE1 VisitDate 1/1/2020 1/2/2020 1/3/2020 1/3/2020 1/4/2020 VisitTimeOfDay 8:00 a.m. 8:30 a.m. 8:30 a.m. 8:00 a.m. 8:00 a.m. V3 V4 V5 PT4 SPAEMPLOYEE SEID SEName SE1 Claire SE2 Jamie SEYearOfHire 2000 2008 INCLUDES VisitID ProcedureID V1 PR1 V1 PR2 V2 PR1 V3 V4 PR3 V5 PR1 V5 PR2 V5 PR3 PROCEDURE ProcedurelD PR1 PR2 PR3 PR2 ProcedureName Mani Pedi Massage Amount Charged $20 $30 $25 $35 $100 $15 $20 $80 Source B) CUSTOM SPA DAILY PURCHASES SPREADSHEET: DAILYPURCHASES PurchaseID Sold Product ID P1 PD1 P2 PD2 P3 PD1 P3 PD2 Sold Product Name Sponge Towel Sponge Towel PurchasedBy PatronID PT1 PT2 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. Amount Charged $10 $15 $10 $15 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