Make a table for each "entity", such as "article" and "producer".  Each such table would have an `id` and a variety of attributes (name, etc).

Then characterize the "relationships" between those entities:

* 1:1
* 1:many
* Many:many

Then build relations:

For 1:1, rethink why you have two separate tables; consider merging the tables together.

For 1:many, the "many" table needs the `id` of the "1".

For many:many, you need an extra table with _only_ two columns, namely an id into each of the other tables.  (Note:  it is a waste to have a new `id` for this column.  More discussion:  http://mysql.rjweb.org/doc.php/index_cookbook_mysql#many_to_many_mapping_table )