Question: Design a E/R Model using crow's foot notation for a Conference Review system in which researchers submit papers for peer-reviewing. Comments written by reviewers are

Design a E/R Model using crow's foot notation 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 a 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 them 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.

Your E/R model should be able to represent the following entity sets:

Authors

Reviewers

Papers

You are expected to identify attributes in relations and relationships, whenever appropriate. Key attributes should also be identified.

ERD File only please. So I can see how to include everything in the code. Thank you

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!