Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Construct the Entity Relationship model for the following set of requirements for conference review database. The ER model should contain all necessary information. Datubase reamitements You are asked by top management to develop a database for aCONFERENCE REVIEW database 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 teview and make recommendations regarding whether to accept or reject the paper. The data requlrements are summarized as follows: Authors of papers are uniquely identified by e-mail id. First and last names are also recorded. Each paper is assigned a unique identifier by the system and is deseribed 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 the other as feedback to the author(s)

Construct the Entity Relationship model for the following set of requirements for conference review database. The ER model should contain all necessary information. Datubase reamitements You are asked by top management to develop a database for aCONFERENCE REVIEW database 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 teview and make recommendations regarding whether to accept or reject the paper. The data requlrements are summarized as follows: Authors of papers are uniquely identified by e-mail id. First and last names are also recorded. Each paper is assigned a unique identifier by the system and is deseribed 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 the other as feedback to the author(s)

Database Systems: Design, Implementation, & Management
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
Chapter10: Transaction Management And Concurrency Control
Section: Chapter Questions
Problem 1P
See similar textbooks
icon
Related questions
Question
Construct the Entity Relationship model for the following set of requirements for conference review database. The ER model should contain all necessary information. Database reauizements: You are asked by top management to develop a database for aCONFERENCE REVIEW database 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 teview 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 names are also recorded. Each paper is assigned a unique identifier by the system and is deseribed 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 the other as feedback to the author(s).
Transcribed Image Text:Construct the Entity Relationship model for the following set of requirements for conference review database. The ER model should contain all necessary information. Database reauizements: You are asked by top management to develop a database for aCONFERENCE REVIEW database 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 teview 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 names are also recorded. Each paper is assigned a unique identifier by the system and is deseribed 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 the other as feedback to the author(s).
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Dataset
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
  • SEE MORE QUESTIONS
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
SEE MORE TEXTBOOKS