Question: Please make an ERD conceptual data model for the following BookClub system: BookClub - Never miss a reading group meeting. BookClub provides an on-line environment

Please make an ERD conceptual data model for the following BookClub system:

Please make an ERD conceptual data model for the following BookClub system:BookClub - Never miss a reading group meeting. BookClub provides an on-line

BookClub - Never miss a reading group meeting. BookClub provides an on-line environment for users to network, to share and discuss books with their friends. Through discussions with BookClub's founders the following requirements have emerged. Obviously the site should have a large number of books on file, so before the site goes live a large database of books would be added. After startup, users would be able choose a book from the existing list or add their own books if the book they have read is not listed. Books are often available in multiple editions. It is important that all are included in the database. All books have a title, copyright year and possibly multiple authors. Each book may also have multiple editions. An edition has a date, a publisher, an ISBN and a type (hardcover, trade paperback and so on). When a user reads a book they note the date read, give it a ranking (1- 10), and optionally assign it to a shelf". A shelf can be anything that a user wants, usually these are things like: fiction, non-fiction, history, computers, manga etc. After the site has been running a while books will have a ranking - the average of all the rankings that users have given the book and it will have been placed on a number of shelves. Users sign up for the site using an email to identify them. Users can add a profile consisting of a descriptive paragraph, and an avatar image. Users create a network of friends (their book club). Users should be able to search for books by title, year, author and shelf. Users should be able to look at the list of books another user has read only if they are friends. Users can add "reviews" for the books they have read. A review consists of the date of the review and a block of text. Users can "like" other user's reviews. The total number of likes will be displayed along with the review. When a book and its reviews are displayed, it should be possible to display the reviews for a book in a variety of orders: 1. chronological (oldest to newest and newest to oldest); 2. by likes (most to least, least to most); 3. by number of comments (replies) (most to least, least to most). Users can comment on reviews (even their own). In addition a user can comment on a comment. When displaying the comments you will need to be able to recreate the thread

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!