Help sql

Question

I want to know if The following table from a library database is already in its three normal forms.
books.
Book Code, Isbn, Title, Publisher Code, Author Code, Genre Code, Category Code, Edition, Country Code

Answer 1

Can a book have more than one of the codes, such as Author Code, Genre Code, Category Code, or Edition? If so, then consider adding more relational tables.

Answer 2

What I mean to ask is, can there be more than one Author Code for the same book, or more than one Genre Code, etc? If so, then you might make a separate table for Authors or Genre where each uses a foreign key column to relate back to the book by its primary key, Book Code. You would then remove Author Code, Genre Code, etc. from the books record definition. That will normalize the DB.

Answer 3

Reframe your question in easy language

Answer 4

What do you recommend

Answer 5

Yes, there can be more than one author for a book.