Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.

Step by Step Solution

3.42 Rating (155 Votes )

There are 3 Steps involved in it

Step: 1

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 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data Analysis And Decision Making

Authors: Christian Albright, Wayne Winston, Christopher Zappe

4th Edition

538476125, 978-0538476126

More Books

Students also viewed these Databases questions

Question

write a note on Moll Cutpurse Life?

Answered: 1 week ago