Question: 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

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.

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 SpecialtyID SpecialtyName MedicationID PrescDate Medication Name PrescID (PrescTimeOfDay SPECIALTY Dosage TH MEDICATION Prescribes -04 PRESCRIPTION Contains Has 46 DOCTOR IsFor PatientWeight th Quantity PATIENT DoctorID Doctor Name PatientID PatientName MEDICATION MedicationID Medication Name Dosage (FK) (U) Statewide Health Prescriptions Database Relational Schema PATIENT PRESCRIPTION PatientiD PresciD PatientName Patientin (FK) PatientWeight DoctorID SPECIALTY DOCTOR PrescDate SpecialtyID DoctorID PrescTimeOfDay Specialty Name Doctor Name PrescMedication (FK) SpecialtyID (FK) PrescQty Statewide Health Prescriptions Database Data PATIENT PatientID PatientName Patient Weight P11 1601b P22 Mary 12516 P33 Fred 2501b Jim DOCTOR DoctorID DoctorName D11 Lee D22 Hank D33 Luisa Specialty S1 S1 S2 SPECIALTY SpecialtyID SpecialtyName 51 Family Medicine S2 Internal Medicine Dosage MEDICATION Medication ID Medication Name M11 Zolex M22 Luneva M33 Luneva 2mg img 2mg PRESCRIPTION PrescID Patient Doctor PrescDate RX11 P11 D11 1/1/2020 RX22 P22 D22 1/1/2020 RX33 P22 D22 1/1/2020 RX44 P33 D11 1/1/2020 RX55 P33 D33 1/2/2020 PrescTimeOfDay PrescMedication PrescQty 8:00 a.m. M11 12 8:30 a.m. M22 10 8:30 a.m. M11 20 8:00 a.m. M11 10 9:00 a.m. M33 30 Source B) STATEWIDE HEALTH PRESCRIPTIONS FILLED BY PHARMACIES TABLE: PRESCRIPTIONS FILLED BY PHARMACIES PrescID PharmacyID PharmacyZip Pharmacy Owner RX11 Ph1 35401 Wallblue RX22 Ph1 35401 Wallblue RX33 Ph2 35402 PQZ RX44 Ph2 35402 PQZ RX55 Ph3 35401 Wallblue 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 SpecialtyID SpecialtyName MedicationID PrescDate Medication Name PrescID (PrescTimeOfDay SPECIALTY Dosage TH MEDICATION Prescribes -04 PRESCRIPTION Contains Has 46 DOCTOR IsFor PatientWeight th Quantity PATIENT DoctorID Doctor Name PatientID PatientName MEDICATION MedicationID Medication Name Dosage (FK) (U) Statewide Health Prescriptions Database Relational Schema PATIENT PRESCRIPTION PatientiD PresciD PatientName Patientin (FK) PatientWeight DoctorID SPECIALTY DOCTOR PrescDate SpecialtyID DoctorID PrescTimeOfDay Specialty Name Doctor Name PrescMedication (FK) SpecialtyID (FK) PrescQty Statewide Health Prescriptions Database Data PATIENT PatientID PatientName Patient Weight P11 1601b P22 Mary 12516 P33 Fred 2501b Jim DOCTOR DoctorID DoctorName D11 Lee D22 Hank D33 Luisa Specialty S1 S1 S2 SPECIALTY SpecialtyID SpecialtyName 51 Family Medicine S2 Internal Medicine Dosage MEDICATION Medication ID Medication Name M11 Zolex M22 Luneva M33 Luneva 2mg img 2mg PRESCRIPTION PrescID Patient Doctor PrescDate RX11 P11 D11 1/1/2020 RX22 P22 D22 1/1/2020 RX33 P22 D22 1/1/2020 RX44 P33 D11 1/1/2020 RX55 P33 D33 1/2/2020 PrescTimeOfDay PrescMedication PrescQty 8:00 a.m. M11 12 8:30 a.m. M22 10 8:30 a.m. M11 20 8:00 a.m. M11 10 9:00 a.m. M33 30 Source B) STATEWIDE HEALTH PRESCRIPTIONS FILLED BY PHARMACIES TABLE: PRESCRIPTIONS FILLED BY PHARMACIES PrescID PharmacyID PharmacyZip Pharmacy Owner RX11 Ph1 35401 Wallblue RX22 Ph1 35401 Wallblue RX33 Ph2 35402 PQZ RX44 Ph2 35402 PQZ RX55 Ph3 35401 Wallblue

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Source A) CUSTOM SPA DAILY VISITS DATABASE: Custom Spa Daily Visits Database ER Diagram PATRON PROCEDURE 4 #SEMOVE Custom Spa Daily Visits Database Relational Schema VISIT PROCEDURE Procedure...

8 a ) 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. 8 b ) Using the data from the two sources...

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...

CUSTOM SPA DATA WARFHOUSE based oe twa sources (Sourse A and Source B) Source A) CUSIOM SPA DAIL.Y VISITS DATABASE: Custom Spa Daily Visics Databsae ER Disgram Source B) CUSTOM SPA DAILY PURCHASES...

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...

Can someone help me with these questions regarding Data Warehousing? Thank you. Section 2: 40 Points 5. Consider the CUSTOM SPA DATA WAREHOUSE based on two sources (Source A and Source B) Source A)...

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...

Auto Dealership PINEVIEW FORD is organized as follows: - Dealership keeps track of Vehicle Identification number of every vehicle that is for sale, sold, or serviced by the dealership. - Vehicles are...

Assignment 4 - Mini Case for Practice Problems in Module 3/Lecture 3 This mini case study provides practice and preparation for the concepts that you learned in module 3. You will get to apply most...

Calculate the energy released in the fission reaction n + 235/92U 88/38Sr + 136/54Xe + 12n. Use Appendix B, and assume the initial kinetic energy of the neutron is very small.

The following example illustrates this scenario: - Bob acquired a dwelling in August 1996 for $400,000, which was his main residence. - The land is less than two hectares. - In September 2012, the...

1 0 points eBook Print References Item 1 4 Predictive analytics help identify future tax liabilities. What data would a tax accountant need in order to perform a predictive analysis?

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...