database – Should You Avoid Many-to-Many Relationships?

Question:

Heard that many-to-many relationships should be avoided and reduced to one-to-many. Is it true? And why should you do this?

Answer:

Probably it means that when, for example, you have a table of articles and a table of tags, then:

  • It would be wrong to add additional columns to the table of articles for a certain number of tags like ID тега 1 , ID тега 2 , ID тега 3

  • It will be correct to create one more table of the form ID связи ID статьиID статьи ID тегаID тега

Why is it so easy to see when trying to do a tag search in either case.

Scroll to Top