hello:

the problem is that:

i have two processes to modeling(problem with relation to a hospital)
1. a diagnostic process :
in this a doctor make a test(each test can be analisys,x-ray) to the patient and finds which disease(can be a disease or a diseases combination(ejem a diagnostig can be the patient have headache and cancer) this patient have, the doctor register the date of the tratment and the cost (according to test).

2. a process of tratment:
in this a doctor to give a drug or a drugs combination to the patient, each drug have a dose , a cost, and a number of daily doses.

problems :

1. I have a fact table which register a diagnostic process of a patient , a diagnostic is compound of multiples diseases and i don't know how to connect many diseases with one diagnostic fact table.

2. I have a fact table which register a tratment process of a patient , a tratment is compose of many drugs, where each drug have a daily doses, a cost, and i don't know how to connect many drugs with a tratment fact table.
And a last favour, which books you recommend me to learn how to design data warehouse?

Any idea is welcome,thanks in advance.