A CONFERENCE REVIEW database system is a system where researchers submit their research papers for considerations. Reviews by reviewers are recorded for use in the paper selection process. The database system caters primarily to reviewers who record answers to evaluation question for each paper they review and make recommendations regarding whether to accept or reject the paper. The data requirements are summarized as follows: Authors of papers are uniquely identified by e-mail id. First and last name are also recorded. • Each paper is assigned a unique identifier by the system and is described by a title, abstract, and the name of the electronic file containing the paper. • A paper may have multiple authors, but one of the authors is designated as the contact author. • Reviewers of papers are uniquely identified by e-mail 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 overall recommendation regarding each paper.

Database Systems: Design, Implementation, & Management
11th Edition
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Chapter5: Advanced Data Modeling
Section: Chapter Questions
Problem 8C
icon
Related questions
Question

Subject: Database
Question: Draw an ERD based on the given info

A CONFERENCE REVIEW database system is a system where researchers
submit their research papers for considerations. Reviews by reviewers are
recorded for use in the paper selection process. The database system caters
primarily to reviewers who record answers to evaluation question for each paper
they review and make recommendations regarding whether to accept or reject the
paper. The data requirements are summarized as follows:
Authors of papers are uniquely identified by e-mail id. First and last name are
also recorded.
Each paper is assigned a unique identifier by the system and is described by a
title, abstract, and the name of the electronic file containing the paper.
A paper may have multiple authors, but one of the authors is designated as the
contact author.
• Reviewers of papers are uniquely identified by e-mail 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 overall recommendation regarding each paper.
Transcribed Image Text:A CONFERENCE REVIEW database system is a system where researchers submit their research papers for considerations. Reviews by reviewers are recorded for use in the paper selection process. The database system caters primarily to reviewers who record answers to evaluation question for each paper they review and make recommendations regarding whether to accept or reject the paper. The data requirements are summarized as follows: Authors of papers are uniquely identified by e-mail id. First and last name are also recorded. Each paper is assigned a unique identifier by the system and is described by a title, abstract, and the name of the electronic file containing the paper. A paper may have multiple authors, but one of the authors is designated as the contact author. • Reviewers of papers are uniquely identified by e-mail 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 overall recommendation regarding each paper.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Research
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.
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning