Consider a conference review system database in which researchers submit their research papers for consideration. The database system also caters to reviewers of papers who make recommendations on whether to accept or reject the paper. The data requirements are summarized as follows: Authors of papers are uniquely identified by their email id. Their first and last names are also recorded.
• Papers are assigned unique identifiers by the system and are described by a title, an abstract, and a file name containing the actual paper.
• Papers may have multiple authors, but one of the authors is designated as the contact author.
• Reviewers of papers are uniquely identified by their email id. Their first and last names are also recorded.
• Each paper is assigned between two and four reviewers. The reviewer rates the paper assigned to him on a scale of 1 to 10.
• Each review contains two types of written comments: one to be seen by the review committee only and the other by the author(s) as well.
1. Design an Entity-Relationship diagram for the conference review database and enter the design using a data-modeling tool such as ERWin.
2. Consider the ER diagram for the AIRLINE database of the Elmasri/Navathe text. Enter this design using a data-modeling tool such as ERWin.