The request
“A veterinary pharmacy dispensing star schema with a dispense fact linked to date, animal, patient, medication, veterinarian, clinic, and diagnosis dimensions.”
Then tryAdd a refill indicator to the factAdd a supplier dimension for medication
What is in this drawing
Read the decisions behind it.
01
Use a central fact table with foreign keys to five conformed dimensions
02
Model relationships as many-fact-rows to one-dimension-row
03
Include descriptive attributes in dimensions for filtering and grouping
Reusable for any animal health or veterinary pharmacy analytics requiring time, patient, product, prescriber, and location dimensions.
More like this