Topic: Communication with measurement many to many
Faced the task which most likely demands not the obvious decision. Though I think it is spread enough.
There is a structure:
The organization - Clinic - Separation
In separations there are specializations, communication many to many as in one separation can be some specializations, and one specialization can be in several separations.
Further it is even more interesting under specific specialization there are doctors, again communication many to many, i.e. some doctors can concern one specialization, and one doctor can be in different specializations and accordingly work in different separations.
In initial system there is one label (we name its sheaf) which connects the doctor, specializations, separations.
In storage as I understand tables bridge for the communication organization between separations and specializations, and one more between specializations and doctors are necessary.
Let's consider for example the organization of communication of separation - specializations: if the table bridge to make with 2 fields separations and specialization if the facts will lie on specialization that we we do not understand on what to precisely separation they as some separations are anchored to specialization.
All facts under the total lie on doctors, i.e. there is a doctor, it rendered services, on such that the total how correctly to organize the data in the fact table, and communications to many that could be traced many that the fact on such that to the doctor has been made on the given specialization in the given separation, I can not understand.
To store in tables a bridge and the facts one more pointer on from the table a sheaf, precisely to understand on what specialization and separation this fact but as then dimension tables and tables bridge should look.
Thanks big if help, couples with this task.