Books data structure

The Books database is a simple structure that holds details on a sample list of books and their authors. The recipes that use the Books database are based on you being part of a fictitious book store. In the following diagram, you can see the relationship between the authors' and books' tables, where a single author can have many books:

Books

The Books table stores the following details for each book:

Field	Description	Example
id_title	Identification for the book. It is a string with the format CCC-CCC (3 characters, a hyphen, and 3 more characters).	123-456
title	Title of the book.	The Tommyknockers
id_author	Identification for the author of a book; it references to the authors' data.	A00002
price	Price for the book. It's a decimal value.	39.00
genre	Genre of the books.	Fiction Possible values are: Fiction, Non-fiction, Business or Children

Authors

The Authors table stores the following details for each author:

Field	Description	Example
id_author	Identification for the author	A00002
lastname	Author's last name	King
firstname	Author's first name	Stephen
nationality	Author's nationality	American
birthyear	Year of author's birth. It's a numeric value.	1947