Need Help on Data Modeling.

[agni_gold]

Hi Friends ,

I have a situation

I have basically 8 Tables which are linked 2 by 2 , you can ssee in below image

• Site Table is linked with Site ,
• SubSegment is linked with SubSegment
• Segment is linked with Segment
• Corporate is linked with Corporate

So in this case i have 4 different year field and different Month field ,

I just want 1 common year field and 1 common Month field .

For that i have tried to make link table for SIte, SubSegment,Segment,Corporate table , but it is making circular reference .

Please help me !!!!

Thanks

[tamilarasu]

I just done the data modelling. Post here your sample output.

[agni_gold]

Can you please share your application.

[tamilarasu]

Sorry for the late reply. I am not sure what is your scope of the project. Let me know if you need any changes in the attachment.

!