0
12kviews
Design star and snowflake schema for Clinical information system.
1 Answer
0
406views

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.

Continue reading...

The best way to discover useful content is by searching it.

Search