Need Help On Entity-Relationship Design

I need to design a schema that will provide me a hierarchical view in reporting. I mean by this is, lets say:



Hospital

|_________> Hospital Entity

| | |

| | V

| | Clinic A

| | - Jane Doe MD

| | - Janette Brown MD

| | ACME Clinic

| | - Jennifer Smith MD

| | Clinic of Jennifer Smith MD

| | - Jennifer Smith MD

| | - Billy Johnson MD

| |

| V

| - Earl Brown MD (Hospital Entity Resident Practitioner)

| - Janette Brown MD

V

- John Smith MD

- Bob Jones MD





The design should also allow me to query a practitioner and the query will show all the entities he or she is a member of.



If this is not the correct place to post this posting, please let me know the correct place and I will make the necessary changes.



Thanks,



Stephen