Question

Design a E/R Model for a "Conference Review" system in which researchers submit papers for peer-reviewing. Comments written by reviewers are recorded by the system. Reviewers also answer evaluation questions for each paper they review and make recommendations regarding whether to accept or reject the paper. The data requirements for the system are summarized as follows:

• Authors of papers are uniquely identified by email. First and last names are also recorded.

• Each paper is assigned a unique identifier by the system and is described by title, abstract, and the name of the electronic file associated with the paper.

• A paper may have multiple authors, but only one of the authors is designated as the “contact” author.

• Reviewers of papers are uniquely identified by email. Reviewer's first name, last name, phone number, affiliation, and topics of interest are also recorded by the system.

• Each paper is assigned between 2 and 4 reviewers. A reviewer rates each paper assigned to him or her on a scale of 1 to 10 in 4 categories: technical merit, readability, originality, and relevance to the conference. Finally, each reviewer provides an overall recommendation regarding each paper, which can be "strong accept", "accept", "weak accept", "borderline", "weak reject", "reject", or "strong reject".

• Each review also contains two types of written comments: one to be seen by the review committee only and the other as feedback to the authors.

Answer 1

Solution : I am providing you ER Model using Crow's Foot Notations. In the below ER Model, " FK " stands for foreign keys, whereas " PK " stands for the Primary Key.

ER Diagram :