QUESTION $6$

Observe the STATEWIDE HEALTH DATABASE:

Statewide Health Prescriptions Database ER Diagram

Statewide Health Prescriptions Database Relational Schema

Statewide Health Prescriptions Database Data

PATIENT

PatientID

PatientName

PatientWeight

P$11$

Jim

$160$lb

P$22$

Mary

$125$lb

P$33$

Fred

$250$lb

DOCTOR SPECIALTY

DoctorID

DoctorName

Specialty

SpecialtyID

SpecialtyName

D$11$

Lee

S$1$

S$1$

Family Medicine

D$22$

Hank

S$1$

S$2$

Internal Medicine

D$33$

Luisa

S$2$

MEDICATION

MedicationID

MedicationName

Dosage

M$11$

Zolex

$2$mg

M$22$

Luneva

$1$mg

M$33$

Luneva

$2$mg

PRESCRIPTION

PrescID

Patient

Doctor

PrescDate

PrescTimeOfDay

PrescMedication

PrescQty

RX$11$

P$11$

D$11$

$1/1/2020$

$8$:$00$ a$.$m$.$

M$11$

$12$

RX$22$

P$22$

D$22$

$1/1/2020$

$8$:$30$ a$.$m$.$

M$22$

$10$

RX$33$

P$22$

D$22$

$1/1/2020$

$8$:$30$ a$.$m$.$

M$11$

$20$

RX$44$

P$33$

D$11$

$1/1/2020$

$8$:$00$ a$.$m$.$

M$11$

$10$

RX$55$

P$33$

D$33$

$1/2/2020$

$9$:$00$ a$.$m$.$

M$33$

$30$

The following question assumes that a single$-$source star schema is created. The purpose of this star schema is to analyze quantities of prescribed medications by all dimensions provided by its source: the STATEWIDE HEALTH PRESCRIPTIONS DATABASE shown above.

The STATEWIDE HEALTH PRESCRIPTIONS database column PatientWeight provides data for a dimension in the STATEWIDE HEALTH star schema.

True

False