Author

idname
1John Doe
2Jane Smith
3Michael Johnson
4Emily Davis
5Robert Brown

Publisher

idname
1ABC Publishers
2XYZ Publishers
3PQR Publishers
4LMN Publishers
5STU Publishers

Genre

idgenre_name
1Fantasy
2Romance
3Thriller
4Horror
5Historical Fiction

Character

idcharacter_name
1Alice
2Bob
3Charlie
4David
5Eve

Book

idtitleage_groupillustratorauthor_idpublisher_idgenre_idmain_character_id
(→ Author.id)(→ Publisher.id)(→ Genre.id)(→ Character.id)
1The Enchanted ForestChildren's BookJane Smith1231
2Adventures of Tom SawyerChildren's BookMark Twain2342
3Gone With The WindYoung Adult BookJane Smith3453
4To Kill A MockingbirdYoung Adult BookHarper Lee4564
51984GeneralGeorge Orwell5175