Questionnaire for medical record entries

View previous topic View next topic Go down

Questionnaire for medical record entries

Post  DrRobotto on Mon Jul 27, 2009 11:38 am

Good afternoon,

I am currently working on a data warehouse in the health care sector and I currently facing this problem:

The aim of this warehouse is to have an overview of a cancer therapy. So, I have created the following fact table (extract):

Medical Record Fact
Patient Key (FK)
Entry Key (FK)

Entry Dimension
Entry Key (PK)
Group Name
Name
Unit

For measurements the tables are filled as follows:
Medical Record Fact:
1|1| 5.4

Entry Dimension
1|Blood Count|White Blood Cells|microgram

But I have a problem if the patient fills up a questionnaire. I came up with two designs, but I do not know, which design is more appropriate:

First approach:
Entry Dimension
1|Fever|< 38|degrees
2|Fever|< 40|degrees

Medical Record Fact:
1|1|null
2|1|null
3|2|null

Second approach:
Entry Dimension
1|Fever|n.a.|n.a.

Medical Record Fact:
1|1|< 38 degrees
3|2|> 40 degrees

For the first design, I save alle the answers in the dimension table and for the second approach I save
the responses in the fact table. Note: There are also questions, which do not have any unit for example symptoms.

I have tried also to consult the book where a design for survey questionnaire data
is described but this design is confusing me:
In the picture I see the response attribute in the fact table and in the last sentence we can read that we have
a response dimension table.

Thank you in advance for any help!

DrRobotto

Posts : 1
Join date : 2009-07-27

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum