In my application database there are patients and those patients have parents. I am generated a patient dimension. Analysis will be done on just patient, patients and their parents, or even just parents.

1-Should I have one many columned dimension with patient and parent info - each patient can have 1 parent in the current transactional database design, many patients can have the same parent?

2-Should I have that and also a separate parent dimension?

3-Should I have 2 separate patient - > parent dimensions with a relationship between them?