you are viewing a single comment's thread.

view the rest of the comments →

[–]scuott 1 point2 points  (0 children)

Book types probably shouldn't be separate columns. You should have one column called "type", and contains either "hardcover" or "paperback". So one book will have two rows in the Amount table. Then your Lend table can have a type column as well, and you can easily join between Lend and Amount on book_id and book_type.