topic Link table in App Development

Link table

Tanish — Wed, 07 Sep 2022 10:14:11 GMT

Hi,

Can anybody explain, why we create link table rather than directly linking it with Composite keys.

salonicdk28 — Wed, 07 Sep 2022 11:31:19 GMT

Hi.

link table must be used when possible, as it keeps your data model more understandable and creates less 'hassle' on the front-end
With the use of link tables, it’s possible to keep the fact tables separated from each other. The advantage of this solution for choosing this method is to keep the data model a logical one.
To remove synthetic keys and circular reference as well

Please refer below link and close the thread

MendyS — Wed, 07 Sep 2022 11:30:05 GMT

couple reasons,
the main to avoid syntactic and circles,
you can read about that - how to create ERD.