The Requirements have been defined as follows by Claudette Harrington :-
Well I'm stuck again. 

I have searched your site for this information and I found several health care designs but 
none of them had all the tables I needed , so again I am humbly asking for your help. 

I need an example of a star schema data warehouse that tells about "what fraction of patients
Tends to go to doctors in their hometown.
That gives the top 10n diseases by cost of treatment.
Give the most effective treatment 4 each disease
Give the treatment with the highest /lowest side effect. 

The analysis should take the age of the patients into account.




Barry says The Things of Interest are :-
 Doctors
 Patients
 Visits