Consider a conference review system database (exercise problem from your textbook) in which researchers submit their research papers for consideration. Reviews by reviewers are recorded for use in the paper selection process. The database system caters primarily to reviewers who record answers to evaluation questions for each paper they review and make recommendations whether to accept or reject the paper. The data requirements are summarized as follows:Authors of papers are uniquely identified by their email id. Their first and last names are also recorded.Each paper is assigned a unique identifier by the system and is described by a title, an abstract, and a file name.A paper may may have multiple authors, but one of the authors is designated as the contact author.Reviewers of papers are uniquely identified by their email address. Each reviewer's first name, last name, phone number, affiliation, and topics of interest are also recorded.Each paper is assigned between two and four reviewers. A reviewer rates each paper assigned to him or her on a scale of 1 to 10 in four categories : technical merit, readability, originality, and relevance to the conference. Finally, each reviewer provides an overall recommendation regarding each paper.Each review contains two types of written comments: one to be seen by the review committee only and the other as feedback to the the author(s).Design Entity-Relationship diagrams for the conference review database and enter the design using any data modeling tool. Be sure to identify entities, key attributes, relationships, mapping cardinalities, and participation constraints. You are free to make any reasonable additional assumptions (as long as they do not conflict with any stated requirements.), and if you do, you need to list them in your document.

Actually, An Entity relationship diagram is a graphical representation a database that describes how…

Answered: ir research papers for consideration.…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Consider a conference review system database (exercise problem from your textbook) in which researchers submit their research papers for consideration. Reviews by reviewers are recorded for use in the paper selection process. The database system caters primarily to reviewers who record answers to evaluation questions for each paper they review and make recommendations whether to accept or reject the paper. The data requirements are summarized as follows:

Authors of papers are uniquely identified by their email id. Their first and last names are also recorded.
Each paper is assigned a unique identifier by the system and is described by a title, an abstract, and a file name.
A paper may may have multiple authors, but one of the authors is designated as the contact author.
Reviewers of papers are uniquely identified by their email address. Each reviewer's first name, last name, phone number, affiliation, and topics of interest are also recorded.
Each paper is assigned between two and four reviewers. A reviewer rates each paper assigned to him or her on a scale of 1 to 10 in four categories : technical merit, readability, originality, and relevance to the conference. Finally, each reviewer provides an overall recommendation regarding each paper.
Each review contains two types of written comments: one to be seen by the review committee only and the other as feedback to the the author(s).

Design Entity-Relationship diagrams for the conference review database and enter the design using any data modeling tool. Be sure to identify entities, key attributes, relationships, mapping cardinalities, and participation constraints. You are free to make any reasonable additional assumptions (as long as they do not conflict with any stated requirements.), and if you do, you need to list them in your document.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions