PLEASE ANSWER B ONLY

b) Using the data from the two sources (Source A and Source B) show how the tables in the dimensional model would be populated.

45) STATEWIDE HEALTH DATA WAREHOUSE based on two sources (Source A and Source B) Source A) STATEWIDE HEALTH PRESCRIPTIONS DATABASE: Statewide Health Prescriptions Database ER Diagram Statewide Health Prescriptions Database Relational Schema Statewide Health Prescriptions Database Data PATIENT \begin{tabular}{|l|l|l|} \hline PatientlD & PatientName & PatientWeight \\ \hline P11 & Jim & 160lb \\ \hline P22 & Mary & 125lb \\ \hline P33 & Fred & 250lb \\ \hline \end{tabular} DOCTOR SPECIALTY \begin{tabular}{|l|l|l|} \hline DoctorID & DectorName & Specialty \\ \hline D11 & Lee & S1 \\ \hline D22 & Hank & S1 \\ \hlineD33 & Luisa & S2 \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline SpecialtuID & SpecialtyName \\ \hline S1 & Family Medicine \\ \hline S2 & Internal Medicine \\ \hline \end{tabular} MEDICATION \begin{tabular}{|l|l|l|} \hline MedicationID & MedicationName & Dosage \\ \hline M11 & Zolex & 2mg \\ \hline M22 & Luneva & 1mg \\ \hline M33 & Luneva & 2mg \\ \hline \end{tabular} PRESCRIPTION \begin{tabular}{|l|l|l|l|l|l|l|} \hline PresclD & Patient & Doctor & PrescDate & PrescTimeOfDay & PrescMedication. & PrescQty \\ \hline RX11 & P11 & D11 & 1/1/2020 & 8:00 a.m. & M11 & 12 \\ \hline RX22 & P22 & D22 & 1/1/2020 & 8:30 a.m. & M22 & 10 \\ \hline RX33 & P22 & D22 & 1/1/2020 & 8:30 a.m. & M11 & 20 \\ \hline RX44 & P33 & D11 & 1/1/2020 & 8:00 a.m. & M11 & 10 \\ \hline RX55 & P33 & D33 & 1/2/2020 & 9:00 a.m. & M33 & 30 \\ \hline \end{tabular} Source B) STATEWIDE HEALTH PRESCRIPTIONS FILLED BY PHARMACIES TABLE: PRESCRIPTIONS FILLED BY PHARMACIES a) Based on the two sources (Source A and Source B) create a star schema whose purpose is to analyze quantities of prescribed medications by all dimensions provided by its sources