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
Computers and Technology, 21.06.2019 19:10
Select the correct answer. emma, the quality control manager in a software development company, asks the testing team to check whether the user interface is friendly. to which type of testing is emma referring? a. usability testing b. data comparison c. validation testing d. stress testing e. destruction testing
Answers: 1
Computers and Technology, 22.06.2019 02:00
Which of the following is a way the operating system prevents unknown or unauthorized users from accessing the system?
Answers: 2
Computers and Technology, 22.06.2019 03:40
Hello my name is mihai and i need your : )i have to do a python project in computer science and i’m really busy with my mocks this period of time besides this i’m not good at coding so could someone pls pls pls sort me out ? i actually beg ; ))
Answers: 1
Computers and Technology, 23.06.2019 09:30
Light travels at a speed of 186,000 miles a second. the distance light travels in a year is 5,865,690,000,000 miles/year 5,865,695,000,000 miles/year 58,656,950,000,000 miles/year 6,789,000,0000 miles/year
Answers: 1
Chemistry, 18.10.2020 14:01
Law, 18.10.2020 14:01
Biology, 18.10.2020 14:01
Social Studies, 18.10.2020 14:01
Mathematics, 18.10.2020 14:01
Biology, 18.10.2020 14:01
Mathematics, 18.10.2020 14:01
Mathematics, 18.10.2020 14:01