An avid reader has been keeping track of all the books he has read over the years in a spreadsheet. However, it has recently gotten to be so large of a spreadsheet that he needs to migrate his data to a database. He primarily wants the database to store information about the books he read. Each book has a title, date read, ISBN number. Some books are physical books. Each physical book is either paperback or hardback and has a number of pages. Some books are audiobooks. Each audiobook has a format (digital, CD, or cassette) and a length (in minutes). A single book can be reread multiple times. He also reviews each book he has read, a review consists of a rating (1-5) and a brief paragraph on his thoughts about the book. Each book is written by one or many authors. Each author has an author ID, name, and multiple addresses. Each book is published by only one publisher. Each publisher has a name (which uniquely identifies the publisher) and a single address. We also want to record the publication year of each book. Draw an ER diagram to capture all information possible related to this problem. Indicate all keys and cardinality constraints. Identify any constraints that cannot be captured in the ER diagram and briefly explain why you could not express them. Explicitly state any assumptions that are made.

Answer rating: 100% (QA)

Solution ER Diagram erDiagram BOOKisbn INT title VARCHAR255 dateread DATE publicationyear INT PHYSICALBOOKisbn INT pages INT type VARCHAR255 AUDIOBOOKisbn INT format VARCHAR255 length INT REVIEWisbn INT rating INT review TEXT AUTHORauthorid INT name VARCHAR255 address VARCHAR255 bookisbn INT PUBLISHERname VARCHAR255 address VARCHAR255 BOOK o AUTHOR BOOK o PUBLISHER BOOK o REVIEW PHYSICALBOOK o BOOK AUDIOBOOK ... View the full answer