Database schema development for books, publishers, and authors

The task considers three entities: book:id, title. publisher:id, title. author:id, full_name. It is necessary to determine what relationships exist between the tables (one-to-many or many-to-many) and which foreign keys should be added.