Assumptions:
Each paper has one or more authors, each author can write one or more papers.
Ea...
Computers and Technology, 15.02.2021 20:10 Wolfb21345
Assumptions:
Each paper has one or more authors, each author can write one or more papers.
Each paper is assigned to an editor. Each editor can oversee multiple papers.
Each paper is assigned to multiple (normally at least two) reviewers. The review process usually has two or more rounds. In each round assigned reviewers will submit a decision (accept, minor revision, major revision, or reject) and comments. Editor will make a decision based on reviews. Normally a paper can only be accepted if all reviewers agree to accept. Otherwise the paper is either rejected (e. g., if majority reviewers recommend to reject), or go for a major or minor revision. After revision, the paper will be sent to the same reviewers for the next round.
The list of tables is:
Author table has the following columns
aid, -- author id
aname, --- author name
aemail, --- author email
affliation, --- author affliation
Editor table has the following columns
eid, --- editor ID
ename, --- editor name
eemail, --- email
paper table has the following columns
pid, -- paper id
title, -- paper title
eid, -- assigned editor id
submit_date, --- date of submission
status, -- status: 1 accept, 2 under review, 3 revision, 4 reject
paper_author table has the following columns
pid, -- paper id
aid, -- author id
Reviewer table has the following columns
rid, --- reviewer id
rname, --- reviewer name
remail, --- reviewer email
paper_review table has the following columns
prid, -- paper review id
pid, -- paper id
rid, -- reviwer id
due_date, -- review due date
receive_date, -- review received date
round, -- round of review, 1 means first round, 2 means second round, most paper will go through 2 rounds of review
decision, -- 1 accept, 2 minor revision, 3 major revision, 4 reject
rcomment, -- comments of review
Problem 2. Insert at least three rows of data to each table. Make sure you keep the primary key and foreign key constraints. [50 points]
Answers: 1
Other questions on the subject: Computers and Technology
Computers and Technology, 22.06.2019 05:00, Siebee23
This program will store roster and rating information for a soccer team. coaches rate players during tryouts to ensure a balanced team. (1) prompt the user to input five pairs of numbers: a player's jersey number (0 - 99) and the player's rating (1 - 9). store the jersey numbers in one int vector and the ratings in another int vector. output these vectors (i. e., output the roster). (3 pts) ex: enter player 1's jersey number: 84 enter player 1's rating: 7 enter player 2's jersey number: 23 enter player 2's rating: 4 enter player 3's jersey number: 4 enter player 3's rating: 5 enter player 4's jersey number: 30 enter player 4's rating: 2
Answers: 1
Computers and Technology, 23.06.2019 00:00, destinysmithds7790
Suppose you have 9 coins and one of them is heavier than others. other 8 coins weight equally. you are also given a balance. develop and algorithm to determine the heavy coin using only two measurements with the of the balance. clearly write your algorithm in the form of a pseudocode using the similar notation that we have used in the class to represent sorting algorithms
Answers: 1
Computers and Technology, 24.06.2019 00:50, anthonycraig0205
3. what is the output of the following statements? temporary object1; temporary object2("rectangle", 8.5, 5); temporary object3("circle", 6, 0); temporary object4("cylinder", 6, 3.5); cout < < fixed < < showpoint < < setprecision(2); object1.print(); object2.print(); object3.print(); object4.print(); object1.set("sphere", 4.5, 0); object1.print();
Answers: 1
You know the right answer?
Questions in other subjects:
History, 28.01.2021 05:30
Social Studies, 28.01.2021 05:30
Engineering, 28.01.2021 05:30
Mathematics, 28.01.2021 05:30
