how understanding m..n family relational database?

let's feeling during an instance - books. book have 1..n authors. an author have 1..m books. good proceed paint authors book?

i came adult an thought emanate books list an authors table. authors list primary authorid pivotal author's name. books list primary book id metadata book (title, announcement date, on). however, there needs proceed couple books authors authors books. where problem is.

let's contend have 3 books bob. however, book, wrote bob, phd. another wrote dr. bob, third wrote dr. robert. i wish means brand fact authors are, reality, same chairman nonetheless credited underneath opposite names. i also wish heed slip another slip wrote opposite books.

now let's also supplement another biased an application, chairman list keeps lane engaging people. let's contend slip an engaging person. i wish wholly contend author 3 books bob, nonetheless engaging slip same slip author bob.

so strategies exist such potentially difficult mapping, while ensuring book authors identified name cover?