Assignment: design a database for the following application. You must use ERM notation

presented and discussed in class and you must use a software design tool. HAND drawn

diagrams will not be accepted.

Conference Paper Review Database

This database will be used to store information relative to the submission and review process of

research papers to computer science conferences.

The database will store the following data:

Conferences: conference name, conference year, contact email address, contact phone

number, and conference web site URL.

Authors: email address, last name, first name.

Submitted papers: paper ID number, paper title, abstract$,$ PDF file name.

Reviewers: email address, last name, first name, phone number, reviewer affiliation

When an author submits a paper to a conference, it is assigned an ID number. While no two

papers submitted to the same conference will have the same ID number, there is no way to

guarantee that these numbers are unique across multiple conferences. Each paper can have

multiple authors but only one of them is designated as the contact person. Note the paper title,

abstract$,$ and file name cannot serve as a unique identifier since the same paper may be

submitted to multiple conferences.

Each conference assigns its submitted papers to at least two reviewers and no more than four

reviewers. Each reviewer of each paper for each conference reviews the paper and produces

the following evaluation: review comments, technical merit, readability, overall

recommendation, relevance, originality, and feedback to the author. Each of these categories

will stored as a single attribute in the database.