166k views
0 votes
Design a relational database schema (include a diagrammatic representation) for a Conference Review System where in researchers submit their research papers for consideration in various conferences. For each conference, reviews of the research papers completed by reviewers are recorded in this database to facilitate the paper selection process. The database system caters to researchers who submit their papers for specific conferences and the reviewers who record answers to evaluation questions for each paper they review and make recommendations on whether to accept or reject the paper for a given conference. The data requirements for this system are provided below. Be sure to indicate all keys and constraints, and any assumptions you make including business rules.

User Zahabba
by
3.3k points

1 Answer

3 votes

Answer:

Check the explanation

Step-by-step explanation:

paper_authors is a table in which all the authors name will be there with the paper they have written, but the contact author will be in table papers because a paper can have many authors but can have only one contact author.

paper_review is a table with two primary key because a reviewer can review many papers and a paper can be reviewed by atleast 2 reviewers and max 4 reviewers so table must have paperID along with reviewers emailAddress as its primary key.

Comment also have two primary key like paper_review because a reviewer can pass 2 comment, one for reviewCommittee and another will be feedback so reviewer emailAddress along with paperID is necessary for comment.

Design a relational database schema (include a diagrammatic representation) for a-example-1
User Ckuri
by
3.5k points