+ Start a Discussion

Multilevel data model design


I have to create data model with 5 levels of objects. All are master details relationships. 
Account --> Regions -->Country --> Unit --> Line Of Business.

An Account ( Pfizer) can have many regions - Europe, Asia, NA
A Region( Ex: Europe) can have many countries - UK, France, Germany.
A Country( UK )  have many units - Pfizer UK1, Pfizer UK2, Pfizer3.
An Unit ( Pfizer UK1) have many Line Of Business - Health , Carrier, Wealth.

As you all know that from child to parent we cant query more than 3 levels. Also i would like to do native reports. 
What is the best data model design to this problem