1 Reply Latest reply: Apr 2, 2012 6:55 AM by Jason Michaelides RSS

    Need help to create un good data model with keys tables

      Hi,

       

      I have 4 tables :

      Time (Temps), Store(Boutique),Sales(Ventes), Budget(Budget).

      I would like to create a middle table (keys tables) to observe optimization model and Application.

       

      Someone can help me to build my data model ?

       

      In advance, Thanks.

        • Need help to create un good data model with keys tables
          Jason Michaelides

          Why do you want to do this?  Using a link table doesn't improve performance just by being there.  In fact I think link tables should anly be used if there is no other way to get the right result as they introduce more joins.  You should limit the amount of joins where possible and practical.

           

          I think your model looks OK as it is.  You could maybe even join some of those tables into each other, but it's probably not necessary.

           

          Hope this helps,

           

          Jason