Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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