Book's data structure

Books

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 author's 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

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