Question

Consider an ABC digital library that manages technical books, the data requirements are summarized as follows: A book is identified by its ISBN number, and it has a title, a price, and a date of publication. It is published by a publisher, which has its own ID number and a name. Each book has exactly one publisher, but one publisher typically publishes multiple books over time. A book is written by one or multiple authors. Each author is identified by an author number and has a name and date of birth. Each author has either one or multiple books; in addition, occasionally data are needed regarding prospective authors who have not yet published any books. Rgarding the relationship between a book and its authors, it is important to record the percentage of the royalties that belongs to a specific author, whether or not a specific author is a lead author of the book, and each author's position in the sequence of the book's authors. A book can be part of a series, which has its own ISBN number, title and publication date. One book can belong to several series, and a series consists of at least one but potentially many books. Reviewers of books are uniquely identified by e-mail address. Each reviewer's first name, last name, phone number, and affiliation are also recorded. Each book is reviewed by between two and four reviewers. A reviewer may review multiple books. A reviewer rates each book on a scale of 1 to 10 in three categories: technical merit, readability, and originality. Finally, each reviewer provides an overall recommendation regarding each book. Construct the E-R diagram for the publishing company. Document any assumptions that you make, but do not change the given requirements. Make sure that your model properly depicts entities, attributes and relationships and weak entities (if any). Note: It is very important that you stay within the bounds of the problem as stated above. Take the description above referring to actors as an example, it does not mention or imply anything about if an actor is associated with any production company. Therefore, don’t even attempt to create a model that connects them. It is also very important that you do not add attributes if they are not necessary or required by the problem. Take the description above referring to actors as an example, it does not mention or imply anything about actor sex (i.e. female or male). Therefore, don't even attempt to create a model that includes sex as an attribute, it would be superfluous. These are just examples of how you can find yourself out of bounds. Developing a general, all inclusive model to solve the problem is as important as creating a well-bounded model to solve the problem.

Answer 1

ER diagram: it is a graphical representation of the entities in the database.

ER DIagram of the ABC digital Library System: