This question may be too easy to ask, but I can't understand how to do it.
I am new in SQL.
I have two tables.
book_id (AI & Primary Key)
writer_id (AI & Primary Key)
I want to create a relation between book_id and writer_id. When I add a new book, I don't want to store the writer's name for the every single time, I want to connect it to a specific writer_id. That's how relational databases work, right?
A writer could be written more than one book, but a book also can be written by more than one writers. How can I make the relation?
I also appreciate any kind of link to understand how this works.