Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 1 : You have been assigned by a startup to assist in designing and implementing a database system for an app named Bookworms. Develop

Question 1:
You have been assigned by a startup to assist in designing and implementing a database system for an app named "Bookworms". Develop an Entity-Relationship (ER) diagram based on the data requirements below:
-The app involves readers, individuals having their unique readerID, name, multiple contact numbers, and email addresses stored within the database. Each email is composed of an initial and a domain.
-Additionally, the app includes authors. Authors have a unique authorID, name, a brief biography, and awards stored in the system.
-Readers can own multiple books, and each book, identified by ISBN_no and copy_no, has info like title, genre, price and publication year. Books can have contributions from multiple authors, and every author must have written at least one book.
-The app also incorporates information about book clubs. Book clubs have a unique clubID, a name, and details about the club's genre preference. A book club must have multiple members, and a reader must belong to at least one book club.
-A book club organizes multiple reading sessions, each with a unique serial number (such as 1,2,3,...) within the club. While sessions in different clubs can have the same serial number, within the same club, they are unique. Reading sessions also have a budget, multiple discussion points, themes and notes, and a designated chair of the reading session.
-Readers join different reading Sessions, and we keep track of when they join using a timestamp composed of the date and time. Also readers get points for joining a reading Session.
-Additionally, readers can be reading partners to each other.
-Readers can borrow books, and details like borrowDate, returnDate, and the specified timespan for borrowing are recorded. Each transaction involves a reader borrowing one or more books and the same book can be borrowed by multiple readers over a period of time. While borrowing books, readers have to pay a certain amount. The amount is calculated from the price of the book and the point stored for the reader.
Design an ER diagram for the Book Club Management app, adhering to the provided data requirements and incorporating appropriate symbols for relationships and entities.
Do not assume any attributes/entities/relationships/multivalued/composite other than the ones mentioned above. For participation constraints/cardinality ratios, if they are not hinted at in the question, you may assume according to your logical reasoning.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Students also viewed these Databases questions