All Forums Data Modeling
mukejee 2 posts Joined 05/14
20 May 2014
Bridge tables

Hi Experts,
Is there any limit in the number of bridge tables in a data model.
I am having a scenario where we store accident details in a table. One accident is associated with many behaviour types and 1 behaviour type will affect many people.
its like accident1 --> behaviour1, behaviour2
                               behaviour1 --> person1, person 2
 
Also like behaviour property, we have 3-4 properties associated with the accident in the same pattern. could you please suggest a model for this?
Also what could be the possible measures for accidents? Any thoughts?
 
Regards
Mukesh
 
 

Raja_KT 1246 posts Joined 07/09
21 May 2014

With limited understanding of scenario, I am thinking of   grouping  behaviours into a behavior group helper table. It has factors.This helper table in turn connects to dimension.
I remember one person, who maintains hierarchy by concatenation but keying of correct data is mandatory :).
Please let me know your views too.

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

mukejee 2 posts Joined 05/14
21 May 2014

I am planning to consider behaviour  as a serperate fact table with behaviour at the center and behaviour type and persons as individual dimenstions. Like this i will create seperate fact tables. then at the end will create a accident summary with the number of each of the properties from these fact tables.
So that I can use these individual tables in dash boards to display the details.
 
Regards..Mukesh
 

You must sign in to leave a comment.