Question Completion Status: STATEWIDE HEALTH The following questions citing STAT

Question

Question Completion Status: STATEWIDE HEALTH The following questions citing STATEWIDE HEALTH assume that a single-source star schema is created. The purpose of this star schema dimensions provided by its source: the STATEWIDE HEALTH PRESCRIPTIONS DATABASE shown below. In this database, each prescriptic contains one medication. STATEWIDE HEALTH PRESCRIPTIONS DATABASE PATIENT PatientiD PatientName PatientWeight P17 P22 P33 160lb 125b 250b Fred DOCTOR DectoriD DoctorName Specialty 011 SPECIALTY SpecialtyIo SpecialtyName Lee S1 Family Medicine Internal Medicine St 022 D33 Luisa MEDICATION MedicationID MedicationName Dosage M11 M22 M33 Zolex 1ms Luneva PRESCRIPTION PrescID Patient Doctor PrescDate PrescTimeofDay PrescMedication Prescoty RX P D1/1/2013 8:00 a.m RX22P22 D22 /1/20138:30a.m RX33 P22 022 /2013 8:30 a.m M11 M22 M11 M11 M33 12 10 RX44P33 011 1/1/2013 8:00 a.m Rx66 P33 033 1/2/2013 900 a.m Based on the dato shown in the STATEWIDE HEALTH PRESCRIPTIONS DATABASE, the dimension PRESCRIPTION in the STATEWIDE HEALTH star schema has 10 30 record(s) 0

Explanation / Answer

Here in the given diagram the dimension PRESCRIPTION in the STATEWIDE HEALTH schema has 5 records.

In PRESCRIPTION Dimension PrescID is the UniqueKey/PrimaryKey .

So here the second option will be correct one.

Notes:

The star schema is the simplest style of data mart schema and is the approach most widely used to develop data warehouses and dimensional data marts. The star schema consists of one or more fact tables referencing any number of dimension tables. The star schema is an important special case of the snowflake schema, and is more effective for handling simpler queries.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.