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
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter10: Transaction Management And Concurrency Control
Section: Chapter Questions
Problem 6P
Related questions
Question
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
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.Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
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
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
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
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning