0
23kviews
Design star and snowflake schema for Clinical information system.
1 Answer
1
1.5kviews

Dimensions:

  1. Patient
  2. Doctor
  3. Procedure
  4. Diagnose
  5. Date of Service
  6. Location
  7. Provider

Fact:

  1. Adjustment
  2. Charge
  3. Age

Figure : Star Schema for Hospital Management System

Figure : Snowflake Schema for Hospital Management System

Please log in to add an answer.