Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Recommended Textbook for

SQL Instant Reference

Authors: Gruber, Martin Gruber

2nd Edition

0782125395, 9780782125399

Students also viewed these Databases questions

Question

2. What, according to Sergey, was strange at this meeting?

Answered: 1 week ago

Question

3. Are our bosses always right? If not, what should we do?

Answered: 1 week ago